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 |