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.