# Item Wise Invoice Price
Items aggregated across purchase invoices — total quantity, average invoice price, and total purchase value per item for a selected period.
Overview
Go to Purchase → Reports → Item Wise Invoice Price.
Report title in ERP: Item Wise Invoice Price
What it shows. One row per item summarizing all purchase invoice activity in the period — total quantity invoiced, average unit price across invoices, pre-tax amount, and total including tax. Unlike bill-level reports, data is rolled up by item regardless of how many invoices contributed.
When to use it. Use to analyze procurement volume and pricing trends at the item level, compare average invoice prices over time, and identify high-spend or frequently purchased items.
How amounts are calculated. Aggregates approved purchase invoice item lines within the date range. Average unit price is derived as total amount divided by total quantity. Cancelled invoices are excluded by default.
Use Cases
- Cost trend monitoring — Run monthly and compare average invoice prices to detect supplier price increases on key materials.
- Inventory planning — Identify top-purchased items by quantity to support reorder levels and safety stock decisions.
- Supplier negotiation — Export item totals before renegotiating rates with suppliers on high-volume products.
- Budget review — Summarize total spend per item for a quarter or financial year to validate procurement budgets.
Filters
Date range, Item, Item Group, Brand, Supplier, Center / Branch, Employee In charge. Advanced: Form Type, HSN Code
Columns
| **Column** | **Description** |
|------------|-----------------|
| Item | Name or description of the purchased item. |
| Item Code | System or supplier item code. |
| Quantity | Total units invoiced across all purchase invoices in the period. |
| Unit | Unit of measure. |
| Amount | Total purchase amount excluding tax. |
| Avg Unit Amt | Average price per unit (Amount ÷ Quantity). |
| Total Including Tax | Total purchase value including tax. |
Actions
- Generate — run the report for the selected filters
- Export / Export All — export to Excel
- Print — print the report
- Advanced Filter — open additional filter fields
- clear — reset active filters
FAQ
How is this different from Item Wise Purchase?
Both aggregate by item. Item Wise Invoice Price focuses on invoice-level pricing — average unit price and totals from purchase invoices specifically.
Are purchase orders included?
No. Only posted purchase invoice lines are included. Open orders without invoices do not appear.
Why is Avg Unit Amt different from the latest invoice rate?
Avg Unit Amt is a weighted average across all invoices in the period, not the rate on the most recent bill.
Does this include debit notes?
No. Debit notes and purchase returns are handled in separate reports.
Which invoice statuses are included?
Approved and Closed purchase invoices only.
Why is my report empty?
No approved invoice lines match the filters, or the item had no purchases in the selected date range.
Can I compare suppliers for the same item?
Run the report with an item filter, then review supplier columns or export to Excel for side-by-side comparison.