# Item Wise Sale Return
Aggregates sale return activity by item — total returned quantity, value, and average return rate for return trend analysis.
Overview
Go to Sales → Reports → Item Wise Sale Return.
Report title in ERP: Item Wise Sale Return
What it shows. One row per item with total returned quantity, return value, average unit rate, and return count across credit notes and returns.
When to use it. Use to identify high-return items, compare return volumes across periods, and support quality or procurement decisions.
How amounts are calculated. Aggregates approved return lines within the selected date range and filters.
Use Cases
- Product quality review — Identify items with the highest return volume or value.
- Category analysis — Combine with brand or item group filters to spot problem product lines.
- Period comparison — Run for consecutive months to detect rising return trends.
- Supplier feedback — Share return data with suppliers for items with recurring quality issues.
Filters
Date, Item, Return Reason, Employee. Advanced Filter: Customer, Brand, Item Group, Branch, Center.
Columns
| **Column** | **Description** |
|------------|-----------------|
| Item | Item name or description. |
| Item Code | Unique item code or SKU. |
| Item Group | Category the item belongs to. |
| Brand | Brand of the item. |
| Return Count | Number of return transactions for the item. |
| Qty | Total quantity returned. |
| Unit | Unit of measure. |
| Amount | Total return value. |
| Avg Unit Amt | Average return rate (Amount ÷ Qty). |
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 average unit amount calculated?
Total return amount divided by total returned quantity for the selected filters.
Does this include FOC returns?
Returns recorded on credit notes and return invoices are included per your filter settings.
Can I drill down to individual returns?
Use Sale Return Report Adv for line-level return detail.
Are cancelled returns included?
No, unless the status filter explicitly includes cancelled documents.
Which documents are included?
Approved credit note lines in the period, aggregated by item.
Why is return qty higher than sales?
Returns may span invoices from earlier periods. Match return date filter to the analysis window.