Items (Inventory): Transaction Summary Report

The Transaction Summary Report gives you a beginning balance and and ending balance for a specified date range by calculating all the additions and deduction that accrued. Below is an example. 

The Transaction Summary Report has the following columns.

  • Item Number: This is your part number.

  • Description: This is the description of your part number.

  • Warehouse: The is the warehouse your product is stored at.

  • Begin Balance: This is the beginning balance of the date range your are looking at. This is at the beginning of the day

  • Sales Qty: This is composed of all IF transactions.

  • Receipts: This is composed of IR and OV transactions except if the receipt is an RMA or Undeliverable. These receipts will be under the Return Qty column.

  • Assembled Qty: This is composed of all IC transactions.

  • Transfer Qty: This is composed of all II, IM, RI, ID, IU, IO transactions.

  • Adjusted Qty: This is composed of all IA transactions.

  • Return Qty: This is composed of all OV transaction that are RMA’s or Undeliverables.

  • Count Adjusted: This is composed of all PI, IP and IQ transactions.