All Collections
Using eFactory
Items (Inventory)
Items (Inventory): Transaction Summary Report
Items (Inventory): Transaction Summary Report

Get a beginning and an ending balance for a specified date range by calculating all the additions and deduction that accrued.

Written by Maureen
Updated over a week ago

Here is an example of a transaction summary report.

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.

  • End Balance: This is the ending balance.

    • This is calculated by: Beginning Balance - Sales qty + Receipts + Assembled Qty + Transferred Qty + Adjusted Qty + Return Qty + Count Adjusted = Ending Balance.

Did this answer your question?