Aggregates sales activity by item, showing total quantity sold, amount, and average unit price. Use it for item-level sales analysis, pricing trends, and high-volume product decisions.
What it shows. One row per item with total quantity sold across sale invoices, unit of measure, total sales amount, and average unit price.
When to use it. Identify high-volume or high-value items, compare average selling prices across periods, and support inventory and sales planning at the SKU level.
Report view
Filtration — Employee
Advanced Filter
Filtration — Date range
Include Returns dropdown — choose how returns are included. Off by default; the report shows sale totals only.
Only one returns option can be active at a time. Click the active option again to turn returns off. The button label changes to Hide Returns or Hide Invoice Returns when a mode is on.
More menu — show or hide the Description column.
When a returns option is enabled, sale invoice totals and credit note (sale return) totals are shown side by side for each item. Net quantity and net amount are calculated as sale minus return.
Counts credit notes whose credit note date falls within the selected period. The same date range and advanced filters apply to both sale invoices and credit notes.
Counts credit notes linked to sale invoices in the selected period. Matching uses the original invoice date and the same report filters — not the credit note date. Use this when you want returns tied to sales in the period, even if the credit note was posted later.
Referenceless credit notes (not linked to an invoice) are included only under Include Returns, not under Include Invoice Returns.
Quantity section — Sale Qty, Return Qty, Net Qty.
Amount section — Sale Amount, Return Amount, Net Amount (pre-tax).
Avg Unit Amt and Total (with tax) use net values when returns are included.
Items with returns but no sales in the period still appear when a returns option is on.
Default view (Include Returns off):
| **Column** | **Description** | |------------|-----------------| | Item | Name or description of the sold item. | | Item Code | Unique code or SKU of the item. | | Description | Optional item description (when shown from More). | | Brand | Item brand. | | Item Group | Item group name. | | Unit | Measurement unit (NOS, KG, PCS, etc.). | | Quantity | Total quantity sold across sale invoices. | | Amount (w/o Tax) | Total sales amount excluding tax. | | Avg Unit Amt | Average selling price per unit (Amount ÷ Quantity). |
| Total (with tax) | Total sales value including tax. |
With Include Returns on, additional columns appear in grouped Quantity and Amount sections:
| **Column** | **Description** | |------------|-----------------| | Sale Qty | Total sold quantity from sale invoices. | | Return Qty | Total returned quantity from credit notes. | | Net Qty | Sale Qty minus Return Qty. | | Sale Amount | Pre-tax sale amount. | | Return Amount | Pre-tax return amount. | | Net Amount | Sale Amount minus Return Amount. |Avg Unit Amt and Total (with tax) in the returns view are based on net amount and net quantity.
Click an item row to open the bill item-wise sale detail for that item.
How is average unit amount calculated?
It is total amount divided by total quantity for the selected filters. Mixed units on the same item code may affect the average if units differ across invoices.
Can I filter service items only?
Yes. Use item type or item group filters in Advanced Filter to show inventory, service, or pre-approved items.
Are cancelled invoices included?
Only active sale lines within the selected date range and filters are aggregated. Cancelled invoices are excluded unless the status filter includes them.
How is this different from Bill Item Wise Sale?
Item Wise Sale Report aggregates totals by item. Bill Item Wise Sale lists every item line with its parent bill detail.
What is the difference between Include Returns and Include Invoice Returns?
Include Returns uses the credit note date — all credit notes in the period are counted. Include Invoice Returns uses the linked invoice date — only credit notes against invoices in the period are counted, even if the credit note was posted later.
Does this include credit notes?
Not in the default view. Open the Include Returns dropdown and choose Include Returns (credit notes dated in the period) or Include Invoice Returns (credit notes linked to invoices in the period). Both show sale and return columns with net figures. For return-only analysis, use Item Wise Sale Return.
Where is the customer filter?
Use Advanced Filter and set Customer. The print header shows the customer name when that filter is active.
Can I see branch-wise item sales?
Use center or branch filter if available on the report before generate.