Stock Valuation sourced measures and KPIs
These tables show the Stock Valuation measures that are sourced directly in Data Warehouse.
Aggregations available are Avg, Max, Min, and Sum. For cases where this does not apply, the available aggregations are indicated in this table:
Stock Valuation
| Measure | Description |
|---|---|
| FIFO Adjustment – Division | FIFO amount minus the replacement cost in the division currency |
| FIFO Adjustment – Company | FIFO amount minus the replacement cost in the company currency |
| FIFO Unit Price – Division | FIFO amount in the division currency divided by the sellable quantity |
| FIFO Unit Price – Company | FIFO amount in the company currency divided by the sellable quantity |
| FIFO Amt – Division | Inventory value of the item according to FIFO in the division currency |
| FIFO Amt – Company | Inventory value of the item according to FIFO in the company currency |
| LIFO Amt – Division | Inventory value of the item according to LIFO in the division currency |
| LIFO Amt – Company | Inventory value of the item according to LIFO in the company currency |
| Avg Amt – Division | Inventory value of the item according to the average value in the division currency |
| Avg Amt – Company | Inventory value of the item according to the average value in the company currency |
| Inv Value IAS2 – Division | Inventory value which is the lowest, non-zero amount of either outgoing value or sales value in the division currency |
| Inv Value IAS2 – Company | Inventory value which is the lowest, non-zero amount of either outgoing value or sales value in the company currency |
| Inv Value Replacement Cost – Division | Inventory value of the item according to the replacement cost method in the division currency |
| Inv Value Replacement Cost – Company | Inventory value of the item according to the replacement cost method in the company currency |
| Inv Value Sales – Division | The difference between the inventory valuation balance and excess quantity on each inventory valuation date in the division currency |
| Inv Value Sales – Company | The difference between the inventory valuation balance and excess quantity on each inventory valuation date in the company currency |
| Inv Value Manual – Division | Manually specified inventory value of the item in the division currency |
| Inv Value Manual – Company | Manually specified inventory value of the item in the company currency |
| Inv Value Outgoing – Division | Inventory value of the item according to the replacement method in the division currency |
| Inv Value Outgoing – Company | Inventory value of the item according to the replacement method in the company currency |
| Depr Amt Bucket 1 – Division | Amount in the division currency by which the net sales value for an item is depreciated for bucket 1 based on historic consumption |
| Depr Amt Bucket 1 – Company | Amount in the company currency by which the net sales value for an item is depreciated for bucket 1 based on historic consumption |
| Depr Amt Bucket 2 – Division | Amount in the division currency by which the net sales value for an item is depreciated for bucket 2 based on historic consumption |
| Depr Amt Bucket 2 – Company | Amount in the company currency by which the net sales value for an item is depreciated for bucket 2 based on historic consumption |
| Depr Amt Bucket 3 – Division | Amount in the division currency by which the net sales value for an item is depreciated for bucket 3 based on historic consumption |
| Depr Amt Bucket 3 – Company | Amount in the company currency by which the net sales value for an item is depreciated for bucket 3 based on historic consumption |
| Depr Amt Bucket 4 – Division | Amount in the division currency by which the net sales value for an item is depreciated for bucket 4 based on historic consumption |
| Depr Amt Bucket 4 – Company | Amount in the company currency by which the net sales value for an item is depreciated for bucket 4 based on historic consumption |
| Depr Amt Bucket 5 – Division | Amount in the division currency by which the net sales value for an item is depreciated for bucket 5 based on historic consumption |
| Depr Amt Bucket 5 –- Company | Amount in the company currency by which the net sales value for an item is depreciated for bucket 5 based on historic consumption |
| Total Depr Amt – Division | Sum of depreciation amount buckets 1-5 in the division currency |
| Total Depr Amt – Company | Sum of depreciation amount buckets 1-5 in the company currency |
| Demand Qty Bucket 1 | Demand quantity for an item for bucket 1 as defined in CAS025 |
| Demand Qty Bucket 2 | Demand quantity for an item for bucket 2 as defined in CAS025 |
| Demand Qty Bucket 3 | Demand quantity for an item for bucket 3 as defined in CAS025 |
| Demand Qty Bucket 4 | Demand quantity for an item for bucket 4 as defined in CAS025 |
| Demand Qty Bucket 5 | Demand quantity for an item for bucket 5 as defined in CAS025 |
| Total Demand Qty | Sum of demand quantity buckets 1-5 |
| Sellable Qty | The on-hand balance (status 2) on each inventory valuation date |
| Unsellable Qty | The on-hand balance for inspection (status 1) on each inventory valuation date |
| Rejected Qty | The rejected on-hand balance (status 3) on each inventory valuation date |
| Total On-Hand Qty | Sum of sellable, unsellable, and rejected quantities |
| No. of Records | The number of stock valuation records Aggregations: Avg, Sum |
Stock Valuation All Levels
| Measure | Description |
|---|---|
| Costing Element Subtotal 1 – Division | Standard cost from all levels with costing element subtotal of 1 in the division currency multiplied by the sellable quantity |
| Costing Element Subtotal 2 – Division | Standard cost from all levels with costing element subtotal of 2 in the division currency multiplied by the sellable quantity |
| Costing Element Subtotal 3 – Division | Standard cost from all levels with costing element subtotal of 3 in the division currency multiplied by the sellable quantity |
| Costing Element Subtotal 4 – Division | Standard cost from all levels with costing element subtotal of 4 in the division currency multiplied by the sellable quantity |
| Costing Element Subtotal 5 – Division | Standard cost from all levels with costing element subtotal of 5 in the division currency multiplied by the sellable quantity |
| Costing Element Subtotal 6 – Division | Standard cost from all levels with costing element subtotal of 6 in the division currency multiplied by the sellable quantity |
| Costing Element Subtotal 7 – Division | Standard cost from all levels with costing element subtotal of 7 in the division currency multiplied by the sellable quantity |
| Costing Element Subtotal 8 – Division | Standard cost from all levels with costing element subtotal of 8 in the division currency multiplied by the sellable quantity |
| Costing Element Subtotal 9 – Division | Standard cost from all levels with costing element subtotal of 9 in the division currency multiplied by the sellable quantity |
| Costing Element Subtotal 1 – Company | Standard cost from all levels with costing element subtotal of 1 in the company currency multiplied by the sellable quantity |
| Costing Element Subtotal 2 – Company | Standard cost from all levels with costing element subtotal of 2 in the company currency multiplied by the sellable quantity |
| Costing Element Subtotal 3 – Company | Standard cost from all levels with costing element subtotal of 3 in the company currency multiplied by the sellable quantity |
| Costing Element Subtotal 4 – Company | Standard cost from all levels with costing element subtotal of 4 in the company currency multiplied by the sellable quantity |
| Costing Element Subtotal 5 – Company | Standard cost from all levels with costing element subtotal of 5 in the company currency multiplied by the sellable quantity |
| Costing Element Subtotal 6 – Company | Standard cost from all levels with costing element subtotal of 6 in the company currency multiplied by the sellable quantity |
| Costing Element Subtotal 7 – Company | Standard cost from all levels with costing element subtotal of 7 in the company currency multiplied by the sellable quantity |
| Costing Element Subtotal 8 – Company | Standard cost from all levels with costing element subtotal of 8 in the company currency multiplied by the sellable quantity |
| Costing Element Subtotal 9 – Company | Standard cost from all levels with costing element subtotal of 9 in the company currency multiplied by the sellable quantity |
Stock Valuation This Level
| Measure | Description |
|---|---|
| Costing Element Subtotal 1 – Division | Standard cost from each cost component with costing element subtotal of 1 in the division currency multiplied by the sellable quantity |
| Costing Element Subtotal 2 – Division | Standard cost from each cost component with costing element subtotal of 2 in the division currency multiplied by the sellable quantity |
| Costing Element Subtotal 3 – Division | Standard cost from each cost component with costing element subtotal of 3 in the division currency multiplied by the sellable quantity |
| Costing Element Subtotal 4 – Division | Standard cost from each cost component with costing element subtotal of 4 in the division currency multiplied by the sellable quantity |
| Costing Element Subtotal 5 – Division | Standard cost from each cost component with costing element subtotal of 5 in the division currency multiplied by the sellable quantity |
| Costing Element Subtotal 6 – Division | Standard cost from each cost component with costing element subtotal of 6 in the division currency multiplied by the sellable quantity |
| Costing Element Subtotal 7 – Division | Standard cost from each cost component with costing element subtotal of 7 in the division currency multiplied by the sellable quantity |
| Costing Element Subtotal 8 – Division | Standard cost from each cost component with costing element subtotal of 8 in the division currency multiplied by the sellable quantity |
| Costing Element Subtotal 9 – Division | Standard cost from each cost component with costing element subtotal of 9 in the division currency multiplied by the sellable quantity |
| Costing Element Subtotal 1 – Company | Standard cost from each cost component with costing element subtotal of 1 in the company currency multiplied by the sellable quantity |
| Costing Element Subtotal 2 – Company | Standard cost from each cost component with costing element subtotal of 2 in the company currency multiplied by the sellable quantity |
| Costing Element Subtotal 3 – Company | Standard cost from each cost component with costing element subtotal of 3 in the company currency multiplied by the sellable quantity |
| Costing Element Subtotal 4 – Company | Standard cost from each cost component with costing element subtotal of 4 in the company currency multiplied by the sellable quantity |
| Costing Element Subtotal 5 – Company | Standard cost from each cost component with costing element subtotal of 5 in the company currency multiplied by the sellable quantity |
| Costing Element Subtotal 6 – Company | Standard cost from each cost component with costing element subtotal of 6 in the company currency multiplied by the sellable quantity |
| Costing Element Subtotal 7 – Company | Standard cost from each cost component with costing element subtotal of 7 in the company currency multiplied by the sellable quantity |
| Costing Element Subtotal 8 – Company | Standard cost from each cost component with costing element subtotal of 8 in the company currency multiplied by the sellable quantity |
| Costing Element Subtotal 9 – Company | Standard cost from each cost component with costing element subtotal of 9 in the company currency multiplied by the sellable quantity |
Stock Valuation Details
| Measure | Description |
|---|---|
| No. of SV Costing Details Records |
The total number of stock valuation costing details records Aggregation: Avg, Sum |
Stock Valuation Details All Levels
| Measure | Description |
|---|---|
| Component Cost – Division | Standard cost from all levels in the division currency multiplied by the sellable quantity |
| Component Cost – Company | Standard cost from all levels in the company currency multiplied by the sellable quantity |
Stock Valuation Details This Level
| Measure | Description |
|---|---|
| Component Cost – Division | Standard cost from each cost component in the division currency multiplied by the sellable quantity |
| Component Cost – Company | Standard cost from each cost component in the company currency multiplied by the sellable quantity |