Inventory History
Note: This relationship diagram is not applicable for Infor Government
Solutions (IGS) customers.
Source: Inventory Usage History
History Analyze by Date: Update Date
| Measure | Source and/or calculation |
|---|---|
| Adjust In Qty | AdjustmentInQuantity |
| Adjust Out Cost | AdjustmentOutExtendedCost |
| Adjust Out Qty | AdjustmentOutQuantity |
| Average Inventory Value | (Per-Begin-Qty* Average Cost) + (Per-End-Qty* Average Cost) / 2 |
| Average SOH Qty | ([Sum: Period Begin Qty] + [Sum: Period End Qty]) / 2) |
| Inventory Turn Rate |
( [Sum: Issue Quantity] + [Sum: Sales Quantity] + [Sum: Adjust Out Qty] + [Sum: Transfer Out Qty])/ (([Sum: Period Begin Qty] + [Sum: Period End Qty]) / 2)) |
| Inventory Turn Value |
(([Sum: Issue Quantity] * [Sum: Issue Cost]) + ([Sum: Sales Quantity] * [Sum: Sales Cost]) + ([Sum: Adjust Out Qty] * [Sum: Adjust Out Cost]) + ([Sum: Transfer Out Qty] * [Sum: Transfer Out Cost])) / ([Sum: Period Open Value] + [Sum: Period End Value] / 2) |
| Issue Cost | IssueExtendedCost |
| Issue Quantity | IssueQuantity |
| Net Transactions | SUM AdjustmentInQuantity + AdjustmentOutQuantity + IssueQuantity + ReceiptQty + SalesQuantity + TransferInQuantity + TransferOutQuantity |
| Period Close Cost | Close Cost |
| Period Begin Qty | Prior Period ( PeriodEndQuantity) |
| Period Close Cost | PeriodEndExtendedCost |
| Period End Qty | PeriodEndQuantity |
| Period End Value | PeriodEndQuantity * PeriodEndExtendedCost |
| Period Open Value | Prior Period ( PeriodEndQuantity * PeriodEndExtendedCost) |
| Receipt Qty | ReceiptQty |
| Sales Cost | SalesExtendedCost |
| Sales Quantity | SalesQuantity |
| Transfer In Qty | TransferInQuantity |
| Transfer Out Cost | TransferOutExtendedCost |
| Transfer Out Qty | TransferOutQuantity |