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 displays 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 file 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 set to Y.

CWDirect Rel 8.5 Inventory Transaction Analysis Detail KBOTTGER INR1502 6/11/04 13:54:58 Page 1 KAB Co. Transaction Dates . . . . : 6/08/04 to 6/09/04 Excluded Item Classes . . : CPG CSH GC Alloc/Non-Alloc/Store . . : Warehouse . . . . . . . . : 000 Transaction Code . . . . : Reason Code . . . . . . . : 00 Date Whs T RC Item SKU Description Qty Cost User Time -------------------------------------------------------------------------------------------------------------------------------------- 6/08/04 30 A 0 TP1000 COPPER TEAPOT 8 64.0000 KBOTTGER 12:00:00 Total for Transaction Code/Reason Code : 8 64.0000 Total for Whs 30 : 8 64.0000 6/08/04 204 A 0 WL2020 SPATULA 1- 1.5000- KBOTTGER 12:52:01 Total for Transaction Code/Reason Code : 1- 1.5000- Total for Whs 204 : 1- 1.5000- Total for 6/08/04 : 7 62.5000 6/09/04 30 A 0 GL6098 8OZ TUMBLER 9 81.0000 KBOTTGER 01:14:15 Total for Transaction Code/Reason Code : 9 81.0000 6/09/04 30 A 6 PL3039 WHITE SAUCER 4 17.7600 KBOTTGER 01:26:12 Total for Transaction Code/Reason Code : 4 17.7600 6/09/04 30 A 7 NP4948 LINEN TABLECLOTH 12 119.8800 KBOTTGER 01:26:16 Total for Transaction Code/Reason Code : 12 119.8800 Total for Whs 30 : 25 218.6400 6/09/04 204 A 0 JP4948 JUICER 33 990.0000 KBOTTGER 01:36:44 6/09/04 204 A 0 GR8747 GARLIC PRESS 1- 1.5000- KBOTTGER 01:42:13 Total for Transaction Code/Reason Code : 32 988.5000 6/09/04 204 C 0 CH4847 CHEESE GRATER 5 27.5000 KBOTTGER 01:44:15 Total for Transaction Code/Reason Code : 5 27.5000 Total for Whs 204 : 37 1,016.0000 Total for 6/09/04 : 62 1,234.6400 Grand Total : 69 1,297.1400

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 file 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 file.

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

• 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 file.

• 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 file. 0 displays if 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 file.

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

• 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. The system displays the Qty field for each inventory transaction record in the Item Transaction History file 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. The system displays the Cost field for each inventory transaction record in the Item Transaction History file 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 file.

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

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 file 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 file 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 file 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 file 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 file 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 file 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 file 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 file for each record whose Date falls within the report’s Transaction dates.