How Product Transaction Summary Works in iDempiere

The Product Transaction Summary report in iDempiere provides a consolidated view of all inventory movements for a product over a selected period. Instead of showing individual document lines in detail, this report summarizes product transactions by movement type, helping users quickly understand how stock quantities have changed.

This report is mainly used for inventory analysis, reconciliation, and audit review.

Product Transaction Data

The Product Transaction Summary is generated exclusively from posted material transactions, such as material receipts, customer shipments, inventory adjustments, internal movements, production issues and receipts, and physical inventory postings. Only completed and posted transactions are included, ensuring the report reflects actual stock movements rather than drafts.

Transaction Summary Calculation

When the report runs in iDempiere, it collects all inventory transactions for the selected product(s), groups them by transaction type, and calculates total quantity in, total quantity out, and net movement. This delivers a high-level picture of stock movements rather than document-by-document detail, making it ideal for understanding why stock increased or decreased without drilling into every transaction.

Report Line Breakdown

Each line in the report typically represents a product and a transaction category—such as Receipt, Shipment, Adjustment, or Production—along with total quantity moved in, total quantity moved out, and net quantity change. Users can immediately see whether stock changes are driven by purchasing, sales, internal usage, or corrections.

In iDempiere, the Product Transaction Summary delivers a consolidated overview of inventory movements by product and transaction type. It summarizes posted material transactions into meaningful totals, allowing users to understand stock changes quickly, validate inventory behavior, and support reconciliation and audit activities without reviewing individual documents.