Purpose: Use the Inventory Valuation report to review a summary of warehouse activity for a range of dates, including:
• activity broken out according to types of transactions (transaction codes) and transaction reasons (transaction reason codes)
• totals for allocatable, non-allocatable, and retail warehouses; see Types of Warehouses for Inventory Valuation.
How to print: Select Submit at the Inventory Valuation Report Screen.
For more information: See the sample report in PDF format.
Contents:
• Date range: The date range defined for the report (the From and To dates selected at the Inventory Valuation Report Screen).
Units and dollars for each warehouse type (Allocatable, Store, Non-allocatable); see Types of Warehouses for Inventory Valuation).
• Valuation starting units: The number of inventory units up to, but not including, the From date entered at the Inventory Valuation Report Screen. Note: The system does not include the number of units associated with a * transaction code.
- Allocatable: The system totals the Units field in the Item Transaction Control table for each record whose Warehouse type is “Allocatable” and whose Date is before the From date.
- Store: The system totals the Units field in the Item Transaction Control table for each record whose Warehouse type is “Store” and whose Date is before the From date.
- Non-allocatable: The system totals the Units field in the Item Transaction Control table for each record whose Warehouse type is “Non-allocatable” and whose Date is before the From date.
• Valuation starting dollars: The dollar value of the inventory units up to, but not including, the From date entered at the Inventory Valuation Report Screen.
- Allocatable: The system totals the Cost field in the Item Transaction Control table for each record whose Warehouse type is “Allocatable” and whose Date is before the From date.
- Store: The system totals the Cost field in the Item Transaction Control table for each record whose Warehouse type is “Store” and whose Date is before the From date.
- Non-allocatable: The system totals the Cost field in the Item Transaction Control table for each record whose Warehouse type is “Non-allocatable” and whose Date is before the From date.
• Valuation ending units: The number of inventory units up to, and including, the To date entered at the Inventory Valuation Report Screen. Note: The system does not include the number of units associated with a * transaction code.
- Allocatable: The system totals the Units field in the Item Transaction Control table for each record whose Warehouse type is “Allocatable” and whose Date falls on or before the To date.
- Store: The system totals the Units field in the Item Transaction Control table for each record whose Warehouse type is “Store” and whose Date falls on or before the To date.
- Non-allocatable: The system totals the Units field in the Item Transaction Control table for each record whose Warehouse type is “Non-allocatable” and whose Date falls on or before the To date.
• Valuation ending dollars: The dollar value of the inventory units up to, and including, the To date entered at the Inventory Valuation Report Screen.
- Allocatable: The system totals the Cost field in the Item Transaction Control table for each record whose Warehouse type is “Allocatable” and whose Date falls on or before the To date.
- Store: The system totals the Cost field in the Item Transaction Control table for each record whose Warehouse type is “Store” and whose Date falls on or before the To date.
- Non-allocatable: The system totals the Cost field in the Item Transaction Control table for each record whose Warehouse type is “Non-allocatable” and whose Date falls on or before the To date.
• Valuation change units: The difference between the valuation starting units and the valuation ending units.
- Allocatable: The system uses this calculation: Allocatable valuation starting units - Allocatable valuation ending units = Allocatable valuation change units.
- Store: The system uses this calculation: Store valuation starting units - Store valuation ending units = Store valuation change units.
- Non-allocatable: The system uses this calculation: Non-allocatable valuation starting units - Non-allocatable valuation ending units = Non-allocatable valuation change units.
• Valuation change dollars: The difference between the valuation starting dollars and the valuation ending dollars.
- Allocatable: The system uses this calculation: Allocatable valuation starting dollars - Allocatable valuation ending dollars = Allocatable valuation change dollars.
- Store: The system uses this calculation: Store valuation starting dollars - Store valuation ending dollars = Store valuation change dollars.
- Non-allocatable: The system uses this calculation: Non-allocatable valuation starting dollars - Non-allocatable valuation ending dollars = Non-allocatable valuation change dollars.
• Transaction change units: The number of units for all inventory transactions that occurred within the date range entered at the Inventory Valuation Report Screen.
- Allocatable: The value from the Total allocatable units field on this report.
- Store: The value from the Total store units field on this report.
- Non-allocatable: The value from the Total non-allocatable units field on this report.
• Transaction change dollars: The dollar value for all inventory transactions that occurred within the date range entered at the Inventory Valuation Report Screen.
- Allocatable: The value from the Total allocatable dollars field on this report.
- Store: The value from the Total store dollars field on this report.
- Non-allocatable: The value from the Total non-allocatable dollars field on this report.
• Variance change units: The difference between the transaction change units and the valuation change units. A value in this field indicates a discrepancy between the inventory units in the Item Transaction Control table and the inventory units in the Item Transaction History table.
- Allocatable: The system uses this calculation: Allocatable transaction change units - Allocatable valuation change units = Allocatable variance change units.
- Store: The system uses this calculation: Store transaction change units - Store valuation change units = Store variance change units.
- Non-allocatable: The system uses this calculation: Non-allocatable transaction change units - Non-allocatable valuation change units = Non-allocatable variance change units.
• Variance change dollars: The difference between the transaction change dollars and valuation change dollars. A value in this field indicates a discrepancy between the inventory dollars in the Item Transaction Control table and the inventory dollars in the Item Transaction History table.
- Allocatable: The system uses this calculation: Allocatable transaction change dollars - Allocatable valuation change dollars = Allocatable variance change dollars.
- Store: The system uses this calculation: Store transaction change dollars - Store valuation change dollars = Store variance change dollars.
- Non-allocatable: The system uses this calculation: Non-allocatable transaction change dollars - Non-allocatable valuation change dollars = Non-allocatable variance change dollars.
• Totals: The totals for each of the above categories across all types of warehouses (Allocatable, Store, and Non-allocatable).
- Valuation starting units: The total valuation starting units, across all warehouse types. The system uses this calculation: Allocatable valuation starting units + Store valuation starting units + Non-allocatable valuation starting units = Total valuation starting units.
- Valuation starting dollars: The total valuation starting dollars, across all warehouse types. The system uses this calculation: Allocatable valuation starting dollars + Store valuation starting dollars + Non-allocatable valuation starting dollars = Total valuation starting dollars.
- Valuation ending units: The total valuation ending units, across all warehouse types. The system uses this calculation: Allocatable valuation ending units + Store valuation ending units + Non-allocatable valuation ending units = Total valuation ending units.
- Valuation ending dollars: The total valuation ending dollars, across all warehouse types. The system uses this calculation: Allocatable valuation ending dollars + Store valuation ending dollars + Non-allocatable valuation ending dollars = Total valuation ending dollars.
- Valuation change units: The total valuation change units, across all warehouse types. The system uses this calculation: Allocatable valuation change units + Store valuation change units + Non-allocatable valuation change units = Total valuation change units.
- Valuation change dollars: The total valuation change dollars, across all warehouse types. The system uses this calculation: Allocatable valuation change dollars + Store valuation change dollars + Non-allocatable valuation change dollars = Total valuation change dollars.
- Transaction change units: The total transaction change units, across all warehouse types. The system uses this calculation: Allocatable transaction change units + Store transaction change units + Non-allocatable transaction change units = Total transaction change units.
- Transaction change dollars: The total transaction change dollars, across all warehouse types. The system uses this calculation: Allocatable transaction change dollars + Store transaction change dollars + Non-allocatable transaction change dollars = Total transaction change dollars.
- Variance change units: The total variance change units, across all warehouse types. The system uses this calculation: Allocatable variance change units + Store variance change units + Non-allocatable variance change units = Total variance change units.
- Variance change dollars: The total variance change dollars, across all warehouse types. The system uses this calculation: Allocatable variance change dollars + Store variance change dollars + Non-allocatable variance change dollars = Total variance change dollars.
• Starting balance (value): The starting balances for each type of warehouse (Allocatable, Store, and Non-allocatable).
- Allocatable units: The value from the Allocatable valuation starting units field on this report.
- Allocatable dollars: The value from the Allocatable valuation starting dollars field on this report.
- Store units: The value from the Store valuation starting units field on this report.
- Store dollars: The value from the Store valuation starting dollars field on this report.
- Non-allocatable units: The value from the Non-allocatable valuation starting units field on this report.
- Non-allocatable dollars: The value from the Non-allocatable valuation starting dollars field on this report.
- Total units: The Valuation starting units across all warehouse types (Allocatable, Store, and Non-allocatable). The system uses this calculation: Starting balance allocatable units + Starting balance store units + Starting balance non-allocatable units = Starting balance total units.
- Total dollars: The Valuation starting dollars across all warehouse types (Allocatable, Store, and Non-allocatable). The system uses this calculation: Starting balance allocatable dollars + Starting balance store dollars + Starting balance non-allocatable dollars = Starting balance total dollars.
For all inventory transactions that occurred within the date range entered at the Inventory Valuation Report Screen, the system provides unit and dollar totals. If an inventory transaction did not have any activity during the date range specified, the unit and dollar totals are 0.
• Transaction code: A code that represents an inventory transaction, such as A = inventory adjustment. All transaction codes in the Item Transaction Code table are included on this report; the system sorts the transaction codes in alphabetical sequence.
Note: The system does not create a * transaction history record when you update the standard or average cost of an item.
• Description: A description of the transaction code. Note: If a transaction reason code has been used, separate totals are provided for each reason code; in this case, the description of the reason code is listed instead of the description of the transaction code; the reason code itself is also listed. Also, in this situation, the transaction code itself is listed first, with the totals for transactions that took place without a reason code, followed by a separate line for each different reason code used with the transaction. For example, you have processed transfer (T) transactions with:
- no reason code
- reason code 1 (REPLENISH PRIMARY)
- reason code 2 (OVERSTOCK TO BULK)
The report includes the following three lines for transfer totals:
- T Transfer
- T REPLENISH PRIMARY (1)
- T OVERSTOCK TO BULK (2)
For each inventory transaction code/reason:
- Allocatable units: The number of units in “Allocatable” warehouses for the specific inventory transaction code/reason that occurred within the date range entered at the Inventory Valuation Report Screen. The system totals the Qty field in the Item Transaction History table for the specified Transaction code and Transaction reason whose Warehouse type is “Allocatable” and whose Date falls on or within the date range defined.
- Allocatable dollars: The dollar value for the number of units in “Allocatable” warehouses for the specific inventory transaction code/reason that occurred within the date range entered at the Inventory Valuation Report Screen. The system uses this calculation for records in the Item Transaction History table with the specified Transaction code and Transaction reason whose Warehouse type is “Allocatable” and whose Date falls on or within the date range defined: Cost x Qty = Allocatable dollars.
- Store units: The number of units in “Store” warehouses for the specific inventory transaction code/reason that occurred within the date range entered at the Inventory Valuation Report Screen. The system totals the Qty field in the Item Transaction History table for the specified Transaction code and Transaction reason whose Warehouse is store and whose Date falls on or within the date range defined.
- Store dollars: The dollar value for the number of units in “Store” warehouses for the specific inventory transaction code/reason that occurred within the date range entered at the Inventory Valuation Report Screen. The system uses this calculation for records in the Item Transaction History table with the specified Transaction code and Transaction reason whose Warehouse type is “Store” and whose Date falls on or within the date range defined: Cost x Qty = Store dollars.
- Non-allocatable units: The number of units in “Non-allocatable” warehouses for the specific inventory transaction code/reason that occurred within the date range entered at the Inventory Valuation Report Screen. The system totals the Qty field in the Item Transaction History table for the specified Transaction code and Transaction reason whose Warehouse is non-allocatable and whose Date falls on or within the date range defined.
- Non-allocatable dollars: The dollar value for the number of units in “Non-allocatable” warehouses for the specific inventory transaction code/reason that occurred within the date range entered at the Inventory Valuation Report Screen. The system uses this calculation for records in the Item Transaction History table with the specified Transaction code and Transaction reason whose Warehouse type is “Non-allocatable” and whose Date falls on or within the date range defined: Cost x Qty = Allocatable dollars.
- Total units: The number of units across all warehouse types (Allocatable, Store, and Non-allocatable) for the specific inventory transaction code/reason that occurred within the date range entered at the Inventory Valuation Report Screen. The system uses this calculation: Allocatable units + Store units + Non-allocatable units = Total units.
- Total dollars: The dollar value for the number of units across all warehouse types (Allocatable, Store, and Non-allocatable) for the specific inventory transaction code/reason that occurred within the date range entered at the Inventory Valuation Report Screen. The system uses this calculation: Allocatable dollars + Store dollars + Non-allocatable dollars = Total dollars.
• Total: The totals for each of the above categories (Allocatable units, Allocatable dollars, Store units, Store dollars, Non-allocatable units, Non-allocatable dollars, Total units, Total dollars) across all types of inventory transactions.
- Allocatable units: The number of units in “Allocatable” warehouses across all inventory transactions that occurred within the date range entered at the Inventory Valuation Report Screen. The system totals the Qty field in the Item Transaction History table for each record whose Warehouse type is “Allocatable” and whose Date falls on or within the date range defined.
- Allocatable dollars: The dollar value for the number of units in “Allocatable” warehouses across all inventory transactions that occurred within the date range entered at the Inventory Valuation Report Screen. The system uses this calculation for records in the Item Transaction History table whose Warehouse type is “Allocatable” and whose Date falls on or within the date range defined: Cost x Qty = Allocatable transaction change dollars.
- Store units: The number of units in “Store” warehouses across all inventory transactions that occurred within the date range entered at the Inventory Valuation Report Screen. The system totals the Qty field in the Item Transaction History table for each record whose Warehouse type is “Store” and whose Date falls on or within the date range defined.
- Store dollars: The dollar value for the number of units in “Store” warehouses across all inventory transactions that occurred within the date range entered at the Inventory Valuation Report Screen. The system uses this calculation for records in the Item Transaction History table whose Warehouse type is “Store” and whose Date falls on or within the date range defined: Cost x Qty = Store transaction change dollars.
- Non-allocatable units: The number of units in “Non-allocatable” warehouses across all inventory transactions that occurred within the date range entered at the Inventory Valuation Report Screen. The system totals the Qty field in the Item Transaction History table for each record whose Warehouse type is “Non-allocatable” and whose Date falls on or within the date range defined.
- Non-allocatable dollars: The dollar value for the number of units in “Non-allocatable” warehouses across all inventory transactions that occurred within the date range entered at the Inventory Valuation Report Screen. The system uses this calculation for records in the Item Transaction History table whose Warehouse type is “Non-allocatable” and whose Date falls on or within the date range: Cost x Qty = Non-allocatable transaction change dollars.
- Total units: The total number of units, across all warehouse types and all inventory transactions, that occurred within the date range entered at the Inventory Valuation Report Screen. The system uses this calculation: Total allocatable units + Total Store units + Total Non-allocatable units = Total total units.
- Total dollars: The dollar value for the total number of units, across all warehouses and all inventory transactions, that occurred within the date range entered at the Inventory Valuation Report Screen. The system uses this calculation: Total allocatable dollars + Total Store dollars + Total Non-allocatable dollars = Total total dollars.
For each of the allocatable/store/non-allocatable unit and dollar buckets:
• Ending balance (transactions): The ending inventory balance from the Item Transaction History table, including all inventory transactions up to the To date.
- Allocatable units: The system uses this calculation: Starting balance allocatable units + Total allocatable units = Ending balance (transactions) allocatable units.
- Allocatable dollars: The system uses this calculation: Starting balance allocatable dollars + Total allocatable dollars = Ending balance (transactions) allocatable dollars.
- Store units: The system uses this calculation: Starting balance store units + Total store units = Ending balance (transactions) store units.
- Store dollars: The system uses this calculation: Starting balance store dollars + Total store dollars = Ending balance (transactions) store dollars.
- Non-allocatable units: The system uses this calculation: Starting balance non-allocatable units + Total non-allocatable units = Ending balance (transactions) non-allocatable units.
- Non-allocatable dollars: The system uses this calculation: Starting balance non-allocatable dollars + Total non-allocatable dollars = Ending balance (transactions) non-allocatable dollars.
- Total units: The system uses this calculation: Ending balance (transactions) allocatable units + Ending balance (transactions) store units + Ending balance (transactions) non-allocatable units = Ending balance (transactions) total units.
- Total dollars: The system uses this calculation: Ending balance (transactions) allocatable dollars + Ending balance (transactions) store dollars + Ending balance (transactions) non-allocatable dollars = Ending balance (transactions) total units.
• Ending balance (value): The ending inventory balance from the Item Transaction Control table, including all transaction dates up to the To date.
- Allocatable units: The Allocatable valuation ending units.
- Allocatable dollars: The Allocatable valuation ending dollars.
- Store units: The Store valuation ending units.
- Store dollars: The Store valuation ending dollars.
- Non-allocatable units: The Non-allocatable valuation ending units.
- Non-allocatable dollars: The Non-allocatable valuation ending dollars.
- Total units: The system uses this calculation: Allocatable valuation ending units + Store valuation ending units + Non-allocatable valuation ending units = Ending balance (value) total units.
- Total dollars: The system uses this calculation: Allocatable valuation ending dollars + Store valuation ending dollars + Non-allocatable valuation ending dollars = Ending balance (value) total dollars.
• Ending balance (variance): The difference between the transactions ending balance and the value ending balance. A value in these fields indicates a discrepancy between the inventory balance in the Item Transaction Control table and the inventory balance in the Item Transaction History table.
- Allocatable units: The system uses this calculation: Ending balance (transactions) allocatable units - Ending balance (value) allocatable units = Ending balance (variance) allocatable units.
- Allocatable dollars: The system uses this calculation: Ending balance (transactions) allocatable dollars - Ending balance (value) allocatable dollars = Ending balance (variance) allocatable dollars.
- Store units: The system uses this calculation: Ending balance (transactions) store units - Ending balance (value) store units = Ending balance (variance) store units.
- Store dollars: The system uses this calculation: Ending balance (transactions) store dollars - Ending balance (value) store dollars = Ending balance (variance) store dollars.
- Non-allocatable units: The system uses this calculation: Ending balance (transactions) non-allocatable units - Ending balance (value) non-allocatable units = Ending balance (variance) non-allocatable units.
- Non-allocatable dollars: The system uses this calculation: Ending balance (transactions) non-allocatable dollars - Ending balance (value) non-allocatable dollars = Ending balance (variance) non-allocatable dollars.
- Total units: The system uses this calculation: Ending balance (transactions) allocatable units + Ending balance (transactions) store units + Ending balance (transactions) non-allocatable units = Ending balance (value) total units.
- Total dollars: The system uses this calculation: Ending balance (transactions) allocatable dollars + Ending balance (transactions) store dollars + Ending balance (transactions) non-allocatable dollars = Ending balance (value) total dollars.
