# Route Group Wise Trade Receivables
Outstanding receivables summarized by route group — total unpaid balances across grouped territories for collection planning.
Overview
Go to Sales → Reports → Route Group Wise Trade Receivables.
Report title in ERP: Route Group Wise Trade Receivables
What it shows. Each route group with total outstanding balance, invoice count, customer count, and aging summary.
When to use it. Use for zone-level collection planning and receivables monitoring across grouped routes.
How amounts are calculated. Sum of unpaid sale invoice balances for customers on routes within each route group as of the selected date.
Use Cases
- Regional collection — Prioritize collection efforts by route group.
- Credit exposure — Monitor total receivables per geographic zone.
- Management reporting — Present zone-wise outstanding in finance review meetings.
- Employee assignment — Align collection staff with high-outstanding route groups.
Filters
As Of Date, Route Group, Employee. Advanced Filter: Branch, Center, Customer Group, Age On (Invoice Date / Due Date).
Columns
| **Column** | **Description** |
|------------|-----------------|
| Route Group | Route group name. |
| Customer Count | Customers with outstanding balances. |
| Invoice Count | Number of unpaid invoices. |
| Outstanding Amount | Total unpaid balance. |
| Current | Amount not yet due. |
| Overdue | Total past-due amount. |
| >90 Days | Amount more than 90 days past due. |
| PDC Amount | Post-dated cheque amount, if applicable. |
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
- Show Invoices / Hide Invoices — expand invoice detail per route group
FAQ
How is this different from Trade Receivables?
Trade Receivables is customer-level. This report groups outstanding by route group.
Can I see customer detail?
Use Show Invoices or run Trade Receivables filtered by route.
Does this include PDC?
PDC amounts may appear when configured. See individual customer statements for PDC detail.
How are routes assigned to groups?
Configure route groups in Sales settings and assign routes accordingly.
Why use route group for receivables?
Collection teams aligned to territories can prioritise by route group outstanding.
How is this different from Trade Receivables?
Trade Receivables is company-wide. This splits AR by route group.