KPIs
Amount
The total value of all inventory transactions posted in the selected period.
The value can be calculated using this formula: Sum (Transaction Qty × Unit Cost)
Amount Received
The total monetary value of inventory receipt transactions recorded during the selected period. The quantity greater than zero is only considered.
The value can be calculated using this formula: Sum (Posted Amount summed when Qty > 0)
Amount Issued
The total monetary value of inventory receipt transactions recorded during the selected period. The quantity less than zero is only considered.
The value can be calculated using this formula: Sum (Posted Amount summed when Qty < 0)
Amount Adjusted
The total monetary value impact of inventory adjustment transactions posted in the selected period.
The value can be calculated using this formula: Sum (Posted Amount summed when Qty=0)
Cycle Count Variance Quantity
The total variance quantity identified during cycle counts. This count is calculated as the difference between the counted quantity and the system quantity.
The variance quantity can be calculated using this formula: Sum (Qty) where transaction type is equal to cycle count
Cycle Count Variance Value
The monetary value impact of cycle count variances. This count can be calculated by applying inventory value to the cycle count variance quantity.
The value of cycle count variances can be calculated using this formula: Sum (Posted Amount) where transaction type is equal to cycle count