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.