Inventory Detail Transaction Report

 

Window Details

 

How Do I...

Navigation

 

Create a Report Setting

Overview

 

Print a Report, Listing, or Form

Fields

 

E-mail, Fax, or Print a Report as a PDF

Report Sample

 

Enter Multiple Values Using Separators

 

Related Topics

   

Item Maintenance

Fiscal Year Maintenance

Inventory Management Options

Transaction Types

 

Navigation

Select Inventory Management Reports menu > Inventory Detail Transaction Report.

Overview

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.

Notes

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 Bill of Materials module is activated, issue, receipt, and negative adjustment activity is included.

If the Production Management module is activated, issue and receipt activity is included. An exception is when a work ticket is linked to a purchase order. In that case, receipts bypass inventory and are directly applied to work tickets.

If the Work Order module is set up, work order issue and receipt 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.

Fields

 

Report Setting

Ending Period / Ending Date

Description

Include Items With a Balance

Type

Print Lot/Serial Information

Default Report

Product Types to Print

Print Report Settings

Print Condensed

Three Hole Punch

Procurement Types to Print

Number of Copies

Collated

Operand

Sort Report By

Value

Unit Cost to Use for Standard Cost Items

Printer/Output

Selection Criteria

Keep Window Open After Print

Fiscal Year / Calendar Year

Keep Window Open After Preview

Starting Period / Starting Date