Inventory analysis fact

Inventory Analysis is used to analyze on-hand inventory. You can select data to review at several levels such as ABC code, warehouse, product code, item, and buyer. The fact granularity is one row for every item record.

These calculation rules are used:


Name	Calculation Rule
SUM Qty MRB	`SUM(itemwhse.qty_mrb) group by item`
Quantity on Hand	`itemwhse.qty_on_hand + Sum_Qty_Mrb`
Cost Type	`Actual if item.cost_type = A` `or Standard if item.cost_type = S` `else item.cost_type`
Cost Item at Warehouse	`If invparms_mst.cost_item_at_whse = 1, get unit cost from itemwhse_mst.unit_cost` `If invparms_mst.cost_item_at_whse = 0, get unit cost from item.unit_cost`
Adjusted Unit Cost	`item.unit_cost if item.cost_type = S` `else item.avg_u_cost` `or itemwhse.unit_cost if item.cost_type = S` `else itemwhse.avg_u_cost`
Total on Hand Cost	`(itemwhse.qty_on_hand + SUM(itemwhse.qty_mrb)) * Adjusted_Unit_Cost`
Total WIP Cost	`itemwhse.qty_wip * Adjusted_Unit_Cost`
Total Inventory Item Cost	`(itemwhse.qty_on_hand + Sum_Qty_Mrb) * Adjusted_Unit_Cost + itemwhse.qty_wip * Adjusted_Unit_Cost`
Source	`Purchased if item.p_m_t_code = P` `else Manufactured if item.p_m_t_code = M` `else Transferred if item.p_m_t_code = T` `else item.p_m_t_code`

Multi-currency

Birst uses the current exchange rate to convert the amount to the report currency amount. To get the report currency amount, Birst multiplies the domestic amount by the current rate. If there is no currency rate, then 0 displays.

Calculation:

current rate amount = domestic amount * current exchange rate.

If there is no exchange rate, then 0 displays.