Open topic with navigation

Select Inventory Management Reports menu > Inventory Detail Transaction Report.

Use Inventory Detail Transaction Report to print or preview a detailed list of all activities. When printed for the current report period, this report is generally used as an audit tool for checking against the on-hand balance in the Inventory file. The report shows the beginning on-hand balance for the period, followed by every transaction posted against that item for the period. All sales, receipts, issues, adjustments, and transfers are shown.

Note The beginning balance quantity information is printed only when By Period is selected in the Selection Criteria field.

Note If you are using this report as an audit tool or for comparison purposes with general ledger balances, select the Print Inactive Items check box to include recorded history for any inactive items.

If the Sales Order and Purchase Order modules are integrated with Inventory Management, sales order invoice and purchase order receipt activity is included. If the Work Order module is installed and set up, work order issue and receipt activity is included. If the Bill of Materials module is activated, issue, receipt, and negative adjustment activity is included.

You can enter a selection of item codes, product lines, primary vendor numbers, item descriptions, warehouses, user-defined categories (if descriptions have been entered in Inventory Management Options), and user-defined fields (UDFs) to print. By entering these selections, you can obtain a list of items that allows you to identify pertinent information.

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks