Transaction Listing Report

This report prints inventory transaction detail.

Header Details

• Report process date and time
• Posting period start and end dates
• Page number

Line Details

For each inventory item included in the report range, these details print:

• Item code
• Item description
• Item unit of measure
• Item dimension, if item is dimension controlled and option to output is selected
• Item opening balance (based on the period start date)
• Item closing balance (based on the period end date)
• Transactions that meet the selection criteria entered in the report parameters, including:
  • Location
  • Posting date
  • Transaction type
  • Reference
  • Batch
  • Quantity
  • Unit cost
  • Total cost
  • Markup/Margin % detail

You can filter the output by tree (and transaction trees, if the IN Transaction Analysis module is in use) and transaction type, so that you can view transactions only for specific groups of items, or for specific transaction types. You can sort the output by posting date or by the transaction time entry stamp.

Company

Select the company for which to run the report.

Tree

Select the transaction tree. You can also select the branches of the tree on which to report.

Markup

Select the price markup or margin percentage that applies to the transactions.

IN Transaction Type

Select the transaction types to include in the report. By default, the report includes all transactions. You can select a subset of transactions to further filter the report.

Note: Transactions on this report with an asterisk beside them do not affect the closing balance of the item.

Exclude zero quantity on hand and no transactions

Select this option to remove items that are not available or for which there are no transactions.

Sorted by

Select the method by which to sort the entries in the report.

Include dimension details

Select this option to include dimension details for items that are dimension controlled in the report.

Print Based on Transaction Analysis

Select this option, then click the AND or OR option. Click the Transaction Analysis Options button to select one or more trees and branches to use as the basis of the analysis.

Inventory Code

Enter the range of inventory codes for items to include in the report. Leaving the From field empty and entering zzz in the To field includes all inventory codes in the report.

Location

Enter the range of locations to include in the report. Leaving the From field empty and entering zzz in the To field includes all locations in the report.

Posting Date

Enter the range of posting dates to include in the report.