# Route Wise Sale
Aggregates sale invoice activity by route — total sales, returns, and net value per route for territory performance analysis.
Overview
Go to Sales → Reports → Route Wise Sale.
Report title in ERP: Route Wise Sale
What it shows. One row per route with sale count, sale quantity, sale amount, return amount, net sale, and customer count.
When to use it. Use to compare route performance, plan field sales coverage, and allocate targets by territory.
How amounts are calculated. Aggregates approved sale invoices for customers assigned to each route within the selected date range.
Use Cases
- Territory review — Rank routes by net sale value for the period.
- Target allocation — Set route-level sales targets based on historical performance.
- Return analysis — Compare return rates across routes to spot problem territories.
- Resource planning — Assign sales staff based on route volume and growth potential.
Filters
Date, Route, Employee. Advanced Filter: Route Group, Branch, Center, Payment Mode, Customer Group.
Columns
| **Column** | **Description** |
|------------|-----------------|
| Route | Route name or code. |
| Route Group | Group the route belongs to. |
| Customer Count | Active customers on the route. |
| Sale Count | Number of sale invoices. |
| Sale Qty | Total quantity sold. |
| Sale Amount | Total sale value. |
| Return Amount | Total return value. |
| Net Amount | Sale Amount minus Return Amount. |
| Avg Sale/Customer | Net Amount divided by Customer Count. |
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 are sales assigned to routes?
Sales are attributed to the route assigned to the customer on the invoice.
Can I see route group totals?
Use Route Group Wise Sale for group-level aggregation.
Does this include cash and credit sales?
Yes. Filter by payment mode if you need cash-only or credit-only route sales.
Are unassigned customers included?
Customers without a route may appear under a blank or unassigned category.
Which field links invoice to route?
Route on sale invoice or customer master per your entry configuration.
Can van sales use this?
Yes when route is captured on field sale invoices — pair with check-in reports for coverage.