Drill to the actual records behind every number — the open invoices, the down machines, the duplicate OEM-customer records, the at-risk programs. Sort, filter, and export the work-list.
Every open invoice behind the DSO / collections number — work the aged book and export the call list.
| Invoice | OEM customer | Division | Geography | Amount | Age | Bucket | Grain | Status | Owner |
|---|---|---|---|---|---|---|---|---|---|
| INV-26-1007 | Export OEMs (Europe / NA) | Aluminium HPDC (core) | Export – Europe | ₹2.0 Cr | 119d | 90+ | Allocated | Overdue | Collections · Export – Europe |
| INV-26-1022 | Tata Motors / Mahindra | Ferrous Castings | North India (Haryana cluster) | ₹2.0 Cr | 119d | 90+ | Region-only | Overdue | Collections · North India (Haryana cluster) |
| INV-26-1013 | Toyota / TKM | Rico Fluidtronics (100%) | South India (Chennai) | ₹2.0 Cr | 103d | 90+ | Allocated | Overdue | Collections · South India (Chennai) |
| INV-26-1028 | Honda (HMSI / Cars) | Aluminium HPDC (core) | North India (Haryana cluster) | ₹2.0 Cr | 103d | 90+ | Actuals | Overdue | Collections · North India (Haryana cluster) |
| INV-26-1004 | Export OEMs (Europe / NA) | Aluminium HPDC (core) | Export – Europe | ₹2.0 Cr | 96d | 90+ | Allocated | Overdue | Collections · Export – Europe |
| INV-26-1019 | Maruti Suzuki | Rico Fluidtronics (100%) | West India (Sanand / Hosur) | ₹2.0 Cr | 96d | 90+ | Allocated | Overdue | Collections · West India (Sanand / Hosur) |
| INV-26-1034 | Bajaj / TVS | Rico Jinfei Wheels (94.8%) | Uttarakhand (Haridwar) | ₹2.0 Cr | 96d | 90+ | Region-only | Overdue | Collections · Uttarakhand (Haridwar) |
| INV-26-1010 | BMW Group | Aluminium HPDC – Chassis & Body | Export – Europe | ₹2.0 Cr | 84d | 61–90 | Allocated | Overdue | Collections · Export – Europe |
| INV-26-1025 | Honda (HMSI / Cars) | Aluminium HPDC (core) | North India (Haryana cluster) | ₹2.0 Cr | 84d | 61–90 | Actuals | Overdue | Collections · North India (Haryana cluster) |
| INV-26-1015 | Renault-Nissan | Rico Fluidtronics (100%) | South India (Chennai) | ₹3.0 Cr | 77d | 61–90 | Allocated | Overdue | Collections · South India (Chennai) |
| INV-26-1030 | Royal Enfield | Rico Jinfei Wheels (94.8%) | Uttarakhand (Haridwar) | ₹3.0 Cr | 77d | 61–90 | Allocated | Overdue | Collections · Uttarakhand (Haridwar) |
| INV-26-1002 | Hero MotoCorp | Aluminium HPDC (core) | North India (Haryana cluster) | ₹3.0 Cr | 73d | 61–90 | Actuals | Overdue | Collections · North India (Haryana cluster) |
| INV-26-1017 | Renault-Nissan | Rico Fluidtronics (100%) | South India (Chennai) | ₹3.0 Cr | 73d | 61–90 | Allocated | Overdue | Collections · South India (Chennai) |
| INV-26-1032 | Bajaj / TVS | Rico Jinfei Wheels (94.8%) | Uttarakhand (Haridwar) | ₹3.0 Cr | 73d | 61–90 | Region-only | Overdue | Collections · Uttarakhand (Haridwar) |
| INV-26-1012 | Toyota / TKM | Rico Fluidtronics (100%) | South India (Chennai) | ₹3.0 Cr | 67d | 61–90 | Allocated | Overdue | Collections · South India (Chennai) |
| INV-26-1027 | Honda (HMSI / Cars) | Aluminium HPDC (core) | North India (Haryana cluster) | ₹3.0 Cr | 67d | 61–90 | Actuals | Overdue | Collections · North India (Haryana cluster) |
| INV-26-1006 | Export OEMs (Europe / NA) | Aluminium HPDC (core) | Export – Europe | ₹4.0 Cr | 64d | 61–90 | Allocated | Overdue | Collections · Export – Europe |
| INV-26-1021 | Maruti Suzuki | Rico Fluidtronics (100%) | West India (Sanand / Hosur) | ₹4.0 Cr | 64d | 61–90 | Allocated | Overdue | Collections · West India (Sanand / Hosur) |