Inventory Transaction Summary Report

How to print: Complete the Inventory Transaction Summary Screen.

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

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 table 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 General Ledger Overview for an overview of general ledger number setup.