Inventory Quantity Status Breakdown Metric
Author:
Holger Lierse
Changed on:
16 Sept 2025
Key Points
- Breakdown of total inventory by inventory quantity types (last on hand, reserved, sale, etc.).
Steps
What it measures
Breakdown of total inventory by inventory quantity types (last on hand, reserved, sale, etc.).

When to use this metric
- Understand how much inventory is actually sellable vs. tied up
- Identify operational issues causing inventory to be unavailable
- Plan inventory procurement based on truly available stock
- Monitor inventory quality and allocation efficiency
How to interpret
- Good performance: High percentage of inventory in "available" status
- Potential issues: Large amounts in "damaged" or "correction" status indicate operational problems
- Benchmark guidance: Varies significantly by business
Key considerations
- Reserved inventory reduces immediate availability but may indicate strong demand
- Damaged inventory represents lost investment and operational issues
- Status accuracy is critical for effective inventory management
Technical details
Formula:
SUM(inventoryPosition.onHand) grouped by inventoryQuantity.type as of current timestamp
Configurable elements:
- none