Calculated measures

This table shows the measures that are calculated in the fact:


Name	Calculation Rule
Quantity on Hand	Quantity on Hand is the total quantity on hand in inventory, nettable and non-nettable.
WIP Quantity	Total WIP Quantity is the total quantity of WIP or open jobs.
On Hand Cost	If the item cost method is standard cost, then this is the on-hand quantity multiplied by the item main standard unit cost. If the item cost method is actual cost, then this is the on-hand quantity multiplied by the item average unit cost. Check the cost items at warehouse flag to get the unit cost from the item warehouse (itemwhse_mst) level. Uncheck the cost items at warehouse flag to get the unit cost from the item (item_mst) level.
WIP Cost	If the item cost method is standard cost, then this is the WIP quantity multiplied by the item main standard unit cost. If the item cost method is actual cost, then this is the WIP quantity multiplied by the item average unit cost. Check the cost items at warehouse flag to get the unit cost from the item warehouse (itemwhse_mst) level. Uncheck the cost items at warehouse flag to get the unit cost from the item (item_mst) level.
Total Cost	Total Cost is the total value of WIP Cost plus On-Hand Cost.
Finished Goods Cost	Finished Goods Cost is the cost of finished goods that are ready for sale in inventory. It is calculated by adding quantity on hand and non-nettable quantity, and then multiplying by item cost for the manufactured product only. Calculation: `Finished Goods Cost = (Quantity on Hand + Non-Nettable Quantity) * Unit Cost` when source is Manufactured. Unit cost decision reference: When cost type is standard choose standard cost, otherwise choose average cost (SELECT item, CASE WHEN cost_type = 'S' THEN unit_cost ELSE avg_u_cost END AS Unit_Cost FROM item) AS unit_cost) Check the cost items at warehouse flag to get the unit cost from the item warehouse (itemwhse_mst) level. Uncheck the cost items at warehouse flag to get the unit cost from the item (item_mst) level.
Raw Material Cost	Raw Material Cost is the cost of raw materials that are materials or substance used in the primary production or manufacturing of a good. It is calculated by adding quantity on hand and non-nettable quantity, and then multiplying by item cost for the not manufactured materials. Calculation: `Raw Material Cost = (Quantity on Hand + Non-Nettable Quantity) * Unit Cost` when source is not Manufactured. Unit cost decision reference: When cost type is standard choose standard cost, otherwise choose average cost (SELECT item, CASE WHEN cost_type = 'S' THEN unit_cost ELSE avg_u_cost END AS Unit_Cost FROM item) AS unit_cost) Check the cost items at warehouse flag to get the unit cost from the item warehouse (itemwhse_mst) level. Uncheck the cost items at warehouse flag to get the unit cost from the item (item_mst) level.