Stock Valuation reports

The measures used in Stock Valuation reports are sourced from the Stock Valuation fact. These measures are analyzed by Inventory Valuation Date and use the Sum aggregation.

Stock Valuation by Valuation Round and Date

Description: This report shows the trend analysis of the Inventory Value (IAS2) over the available Stock Valuation Dates. This report is used to analyze the increase or decrease in the inventory value over a certain period.

Measure: Inv Value IAS2 – Company

Chart type: 1 data series column chart

Partition: If more than one valuation round has occurred on the same date, the column is partitioned by the attribute Inventory Valuation Round to avoid adding valuation rounds.

Top Inventory Value by Product

Description: This report shows the products with the highest Inventory Value (IAS2). You can use the column selector to change the category displayed to Product Group, Item Group, or Item.

Measure: Inv Value IAS2 – Company

Chart type: 1 data series bar chart

Column selector: Product Group, Item Group, Item

Bottom Inventory Value by Product

Description: This table shows the products with the lowest Inventory Value (IAS2). You can use the column selector to change the category displayed to Product Group, Item Group, or Item.

Measure: Inv Value IAS2 – Company

Chart type: 1 data series bar chart

Column selector: Product Group, Item Group, Item

Stock Valuation Details

Description: This report shows a detailed list of the selected inventory valuation round, their inventory valuation date, value-based and cost-based measures and Warehouse.

Measure: Inv Value IAS2 – Company, FIFO Amt – Company, LIFO Amt – Company, Average Amt – Company

Chart type: Table

Bottom Inventory Value by Warehouse

Description: This table shows the warehouses with the lowest Inventory Value (IAS2).

Measure: Inv Value IAS2 – Company

Chart type: 1 data series bar chart

Top Inventory Value by Warehouse

Description: This table shows the warehouses with the highest Inventory Value (IAS2).

Measure: Inv Value IAS2 – Company

Chart type: 1 data series bar chart