Inventory Transaction Summary Report
How to print: Complete the Inventory Transaction Summary Screen.
CWDirect Rel 3.0 Inventory Transaction Summary The KL Mail Order Company From: 10/15/98 To: 11/13/98 Whs Cde Description Trans Dt Units Cost Extension 30 C Customer Return 10/15/98 1 11.79 30 C Customer Return 10/19/98 2 23.58 30 C Customer Return 10/26/98 1 11.79 Code C Total 4 47.16 ---------------------------------------------------------------------------------------- Whs 30 Total 4 47.16 ---------------------------------------------------------------------------------------- 40 A Adjustment 11/06/98 75 862.50 40 A Adjustment 11/12/98 5 250.00 Code A Total 80 1,112.50 ---------------------------------------------------------------------------------------- 40 G ITEM TO ITEM TRANSFER 11/06/98 Code G Total ---------------------------------------------------------------------------------------- 40 I Issue 10/15/98 2- 23.58- 40 I Issue 10/16/98 2- 23.58- 40 I Issue 10/19/98 4- 47.16- 40 I Issue 10/28/98 3- 35.37- Code I Total 16- 129.69- ---------------------------------------------------------------------------------------- 40 R Receiving 11/12/98 5 28.75 Code R Total 5 28.75 ---------------------------------------------------------------------------------------- 40 T Transfer 11/06/98 Code T Total ---------------------------------------------------------------------------------------- 40 V Return to vendor 11/06/98 1- 10.00- Code V Total 1- 10.00- ---------------------------------------------------------------------------------------- Whs 40 Total 69 951.52 ---------------------------------------------------------------------------------------- Final Total 73 998.72 Missing G/L# Total 12- 14.63 |
Contents:
• warehouse code
• inventory transaction code. This code indicates the type of transaction performed on inventory. Certain codes are supplied by the system, and you can set up your own. System-supplied codes are:
• A = Adjustment
• C = Customer Return
• E = Express Bill
• G = Item to Item Transfer
• I = Issue
• M = Makeup set
• O = On-hand
• P = Physical
• R = Receiving
• T = Transfer
• V = Return to Vendor
• inventory transaction description
• transaction date
• the total number of units that are affected by the inventory transactions
• the extended cost of all transactions of a specific type on this date. If you are using average or standard costing, the system multiples the total units by the average or standard cost from the SKU file to determine the extended cost of each transaction. If you are using FIFO Costing, the system uses the total cost of all FIFO cost layers selected for the transactions. The Costing Method (A25) system control value controls the costing method for your company.
• warehouse code and totals for each warehouse
• final total (net of number of units and total cost)
• missing G/L # total. The total number of units and dollar amount for which the system could not find a G/L number. See Accounts Payable General Ledger Overview, for an overview of general ledger number setup.
| Printing the Inventory Transaction Summary (PITS) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Inventory Transaction Summary by G/L# Report |
WH03_04r CWDirect 18.0.x 2018 OTN