Inventory Transaction Analysis Detail Report

Purpose: Use this report to review the details of inventory transactions by date, warehouse, transaction code and reason code. Totals are provided at the end of the report for each warehouse, date, and across all warehouses and dates.

For each inventory transaction that included on the report, the system provides unit and dollar totals. See Positive or Negative Effect on Inventory Levels for more information on how the system determines which inventory transactions in the Item Transaction History table have a positive or negative effect on inventory.

This report sorts in date/warehouse/transaction code/reason code/item number/SKU code/time sequence.

How to print: Complete the Print Inventory Transaction Analysis Screen with the Print detail flag selected.

For more information: See the sample report in PDF format.

Contents:

• Transaction dates: The date range you entered at the Print Inventory Transaction Analysis Screen, limiting the report to inventory transactions that occurred on or within this date range.

• Excluded item classes: Code(s) for the item class(es) you excluded at the Print Inventory Transaction Analysis Screen. If you excluded an item class, the system does not include inventory transactions associated with the item class on the report.

• Alloc/Non-alloc/Store: A code for the warehouse type you selected at the Print Inventory Transaction Analysis Screen. If you defined a warehouse type, the system limits the data on this report to those inventory transactions associated with the specified warehouse type.

• Warehouse: A code for the warehouse you selected at the Print Inventory Transaction Analysis Screen. If you defined a warehouse, the system limits the data on this report to those inventory transactions associated with the specified warehouse.

• Transaction code: A code for the inventory transaction you selected at the Print Inventory Transaction Analysis Screen. If you defined a transaction code, the system limits the data on this report to those inventory transactions associated with the specified transaction code.

Note: The system does not create a * transaction history record when you update the standard or average cost of an item. See * = Change Average or Standard Cost.

• Reason code: A code for the inventory transaction reason you selected at the Print Inventory Transaction Analysis Screen. If you defined a reason code, the system limits the data on this report to those inventory transactions associated with the specified reason code.

For each inventory transaction in the Inventory Transaction History table that falls within the report’s date range:

• Date: The date on which the inventory transaction occurred. This is the Date field from the Inventory Transaction History table.

• Whse (warehouse): A code for the warehouse where the inventory transaction occurred. This is the Warehouse field from the Inventory Transaction History table.

• T (transaction code): A code for the inventory transaction code associated with the inventory transaction. This is the Transaction code field from the Inventory Transaction History table.

• RC (reason code): A code for the inventory transaction reason code associated with the inventory transaction. This is the Transaction reason field from the Inventory Transaction History table. 0 indicates that the inventory transaction is not associated with a reason code.

• Item: A code for the item associated with the inventory transaction. This is the Item number field from the Inventory Transaction History table.

• SKU: The SKU code for the item associated with the inventory transaction. This is the SKU code field from the Inventory Transaction History table.

• Description: A description of the item.

• Qty: The number of units of the item associated with the inventory transaction for the specified date, warehouse, transaction code, and transaction reason. Included for each inventory transaction record in the Item Transaction History table that meets the specified Item, SKU, Date, Warehouse, Transaction code, and Transaction reason on a separate line of the report.

• Cost: The dollar value for the number of units of the item associated with the inventory transaction for the specified date, warehouse, transaction code, and transaction reason. Included for each inventory transaction record in the Item Transaction History table that meets the specified Item, SKU, Date, Warehouse, Transaction code, and Transaction reason.

• User: The user ID of the user who performed the inventory transaction. This is the User field in the Item Transaction History table.

• Time: The time the inventory transaction occurred. This is the Time field in the Inventory Transaction History table.

Totals:

• Total for transaction code/reason code: Totals by transaction code and reason code for:

• Qty: The number of units of the item associated with the inventory transaction for the specified date, warehouse, transaction code, and transaction reason. The system totals the Qty field in the Item Transaction History table for each record that meets the specified Item, SKU, Date, Warehouse, Transaction code, and Transaction reason.

• Cost: The dollar value for the number of units of the item associated with the inventory transaction for the specified date, warehouse, transaction code, and transaction reason. The system totals the Cost field in the Item Transaction History table for each record that meets the specified Item, SKU, Date, Warehouse, Transaction code, and Transaction reason.

• Total for Whs: Totals by warehouse for:

• Qty: The number of units of the item associated with the inventory transaction for the specified date and warehouse, across all transaction codes and transaction reasons. The system totals the Qty field in the Item Transaction History table for each record that meets the specified Item, SKU, Date, and Warehouse.

• Cost: The dollar value for the number of units of the item associated with the inventory transaction for the specified date and warehouse, across all transaction codes and transaction reasons. The system totals the Cost field in the Item Transaction History table for each record that meets the specified Item, SKU, Date, and Warehouse.

• Total for date: Totals by date for:

• Qty: The number of units of the item associated with the inventory transaction for the specified date, across all warehouses, transaction codes and transaction reasons. The system totals the Qty field in the Item Transaction History table for each record that meets the specified Item, SKU, and Date.

• Cost: The dollar value for the number of units of the item associated with the inventory transaction for the specified date, across all warehouses, transaction codes and transaction reasons. The system totals the Cost field in the Item Transaction History table for each record that meets the specified Item, SKU, and Date.

• Grand total: Final totals across all warehouses and dates for:

• Qty: The number of units associated with the inventory transactions that occurred within the date range, across all items, warehouses, transaction codes and transaction reasons. The system totals the Qty field in the Item Transaction History table for each record whose Date falls within the report’s Transaction dates.

• Cost: The dollar value associated with the inventory transactions that occurred within the date range, across all items, warehouses, transaction codes and transaction reasons. The system totals the Cost field in the Item Transaction History table for each record whose Date falls within the report’s Transaction dates.