Consolidated purchase summary grouped by item. Shows total quantity, average unit cost, and purchase value with and without tax for procurement and inventory planning.
What it shows. One row per item with total purchased quantity, average unit amount, pre-tax amount, and tax-inclusive total across all purchase invoices in the period.
When to use it. Use to identify high-volume purchases, compare item costs over time, and support reorder and budget decisions.
Report view
Date filter
Include Returns — toggle next to the filter icon. Off by default; shows purchase totals only. When on, the report adds return (debit note) quantity and amount columns and net figures. Click again (Hide Returns) to return to the standard view.
When Include Returns is enabled, purchase invoice totals and debit note (purchase return) totals are shown side by side for each item. Net quantity and net amount are calculated as purchase minus return.
Quantity section — Purchase Qty, Return Qty, Net Qty.
Amount section — Purchase Amount, Return Amount, Net Amount (pre-tax).
Avg Unit Amt and Total Including Tax use net values when returns are included.
Items with returns but no purchases in the period still appear when Include Returns is on. The same date range and advanced filters apply to both purchase invoices and debit notes.
Inventory, service, and asset items are listed in separate sections when applicable.
Default view (Include Returns off):
| **Column** | **Description** | |------------|-----------------| | Item | Item name or description. | | Item Code | Item code or SKU. | | Unit | Unit of measure. | | Quantity | Total units purchased in the period. | | Amount | Total purchase amount excluding tax. | | Avg Unit Amt | Average cost per unit (Amount ÷ Quantity). | | Total Including Tax | Total purchase value including tax. |With Include Returns on, additional columns appear in grouped Quantity and Amount sections:
| **Column** | **Description** | |------------|-----------------| | Purchase Qty | Total purchased quantity from purchase invoices. | | Return Qty | Total returned quantity from debit notes. | | Net Qty | Purchase Qty minus Return Qty. | | Purchase Amount | Pre-tax purchase amount. | | Return Amount | Pre-tax return amount. | | Net Amount | Purchase Amount minus Return Amount. |Avg Unit Amt and Total Including Tax in the returns view are based on net amount and net quantity.
How is Avg Unit Amt calculated?
It is the total pre-tax Amount divided by total Quantity for that item in the selected period.
Can I see purchases for one item only?
Yes. Use Advanced Filter and set Item or Item Code.
Does this report show individual invoices?
No. It aggregates by item. Click an item to open Bill Item Wise Purchase for that item. The include-returns setting is kept when you drill down.
Are purchase returns included?
Not in the default view. Turn on Include Returns next to the filter icon to show purchase quantity and amount alongside return quantity and amount, with net figures. For bill-line return detail, use Bill Item Wise Purchase with Include Returns, or Purchase Return Report.
Which invoice statuses are included?
Approved and Closed purchase invoices only.
Why is an item missing from the report?
The item may have no approved invoice activity in the period, or advanced filters exclude its group, branch, or supplier.
Does this report include tax in Avg Unit Amt?
No. Avg Unit Amt is based on pre-tax line amounts divided by quantity for the selected period.