Inventory history measures

Measure Measure caption Measure source Cube rule
AdjustmentInQuantity Adjust In Qty InventoryUsageHistory InventoryAdjustmentsArray.InventoryAdjustments. AdjustmentInQuantity (1-14)
AdjustmentOutExtendedCost Adjust Out Cost InventoryUsageHistory InventoryAdjustmentsArray.InventoryAdjustments. AdjustmentOutExtendedCost (1-14)
AdjustmentOutQuantity Adjust Out Qty InventoryUsageHistory InventoryAdjustmentsArray.InventoryAdjustments. AdjustmentOutQuantity (1-14)
Average Inventory Value* Average Inventory Value Calculation (PeriodBeginQuantity + PeriodEndQuantity) / 2
Average Stock on Hand Quantity* Average SOH Qty Calculation (PeriodBeginQuantity + PeriodEndQuantity) / 2
BeginningStockOnHandQuantity Beginning SOH Qty InventoryUsageHistory
Days on Hand Days on Hand Calculation Number of Days / Inventory Turn Rate
Inventory Turn Rate* Inventory Turn Rate Calculation IIF(( [Sum: Issue Quantity] + [Sum: Sales Quantity] + [Sum: Adjust Out Qty] + [Sum: Transfer Out Qty]) <> 0 AND (([Sum: Period Begin Qty] + [Sum: Period End Qty]) / 2) = 0, 0, ( [Sum: Issue Quantity] + [Sum: Sales Quantity] + [Sum: Adjust Out Qty] + [Sum: Transfer Out Qty]) / (([Sum: Period Begin Qty] + [Sum: Period End Qty]) / 2))
IssueExtendedCost Issue Cost InventoryUsageHistory InventoryIssuesArray.InventoryIssues.Issue ExtendedCost (1-14)
IssueQuantity Issue Quantity InventoryUsageHistory InventoryIssuesArray.InventoryIssues.Issue Quantity (1-14)
Net Transactions Net Transactions Calculation ReceiptQuantity + AdjustmentInQuantity + TransferInQuantity - (IssueQuantity + AdjustmentOutQuantity + TransferOutQuantity + SalesQuantity)
Number of Days Selected Number of Days Selected Calculation
PeriodBeginQuantity Period Begin Qty Calculation Prior period PeriodEndQuantity
PeriodEndExtendedCost Period Close Cost InventoryUsageHistory InventoryPeriodEndArray.InventoryPeriodEnd. PeriodEndExtendedCost (1-14)
PeriodEndQuantity Period End Qty InventoryUsageHistory InventoryPeriodEndArray.InventoryPeriodEnd .PeriodEndQuantity (1-14)
Period End Value Period End Value Calculation ICH_PeriodEndQuantity * ICH_PeriodEnd ExtendedCost
Period Open Value Period Open Value Calculation
ReceiptQuantity Receipt Qty InventoryUsageHistory InventoryReceiptsArray.InventoryReceipts .ReceiptQty (1-14)
SalesExtendedCost Sales Cost InventoryUsageHistory InventorySalesArray.InventorySales.Sales ExtendedCost (1-14)
SalesExtendedPrice Sales Price InventoryUsageHistory InventorySalesArray.InventorySales.Sales ExtendedPrice (1-14)
SalesQuantity Sales Quantity InventoryUsageHistory InventorySalesArray.InventorySales.Sales Quantity (1-14)
TransferInQuantity Transfer In Qty InventoryUsageHistory InventoryTransfersArray.InventoryTransfers .TransferInQuantity (1-14)
TransferOutExtendedCost Transfer Out Cost InventoryUsageHistory InventoryTransfersArray.InventoryTransfers. TransferOutExtendedCost (1-14)
TransferOutQuantity Transfer Out Qty InventoryUsageHistory InventoryTransfersArray.InventoryTransfers .TransferOutQuantity (1-14)
Inventory Turn Value Inventory Turn Value Calculation

(([IFXI_ICH_Measures:'IssueQuantity'] * [IFXI_ICH_Measures:'IssueExtendedCost'] ) + ([IFXI_ICH_Measures:'SalesQuantity'] * [IFXI_ICH_Measures:'SalesExtendedCost']) + ([IFXI_ICH_Measures:'AdjustmentOutQuantity'] * [IFXI_ICH_Measures:'AdjustmentOutExtendedCost']) + ([IFXI_ICH_Measures:'TransferOutQuantity'] * [IFXI_ICH_Measures:'TransferOutExtendedCost'])) /[IFXI_ICH_Measures:'Average Inventory Value']

* Month level only

Related dimensions
Calendar
Company
Inventory location
Item