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) |
| INV-26-1009 | BMW Group | Aluminium HPDC – Chassis & Body | Export – Europe | ₹7.0 Cr | 58d | 31–60 | Allocated | Open | Collections · Export – Europe |
| INV-26-1024 | Tata Motors / Mahindra | Ferrous Castings | North India (Haryana cluster) | ₹7.0 Cr | 58d | 31–60 | Region-only | Open | Collections · North India (Haryana cluster) |
| INV-26-1003 | Hero MotoCorp | Aluminium HPDC (core) | North India (Haryana cluster) | ₹5.0 Cr | 41d | 31–60 | Actuals | Open | Collections · North India (Haryana cluster) |
| INV-26-1018 | Maruti Suzuki | Rico Fluidtronics (100%) | West India (Sanand / Hosur) | ₹5.0 Cr | 41d | 31–60 | Allocated | Open | Collections · West India (Sanand / Hosur) |
| INV-26-1033 | Bajaj / TVS | Rico Jinfei Wheels (94.8%) | Uttarakhand (Haridwar) | ₹5.0 Cr | 41d | 31–60 | Region-only | Open | Collections · Uttarakhand (Haridwar) |
| INV-26-1008 | BMW Group | Aluminium HPDC – Chassis & Body | Export – Europe | ₹5.0 Cr | 38d | 31–60 | Allocated | Open | Collections · Export – Europe |
| INV-26-1023 | Tata Motors / Mahindra | Ferrous Castings | North India (Haryana cluster) | ₹5.0 Cr | 38d | 31–60 | Region-only | Open | Collections · North India (Haryana cluster) |
| INV-26-1014 | Toyota / TKM | Rico Fluidtronics (100%) | South India (Chennai) | ₹6.0 Cr | 31d | 31–60 | Allocated | Open | Collections · South India (Chennai) |
| INV-26-1029 | Royal Enfield | Rico Jinfei Wheels (94.8%) | Uttarakhand (Haridwar) | ₹6.0 Cr | 31d | 31–60 | Allocated | Open | Collections · Uttarakhand (Haridwar) |
| INV-26-1005 | Export OEMs (Europe / NA) | Aluminium HPDC (core) | Export – Europe | ₹6.0 Cr | 22d | Current | Allocated | Open | Collections · Export – Europe |
| INV-26-1020 | Maruti Suzuki | Rico Fluidtronics (100%) | West India (Sanand / Hosur) | ₹6.0 Cr | 22d | Current | Allocated | Open | Collections · West India (Sanand / Hosur) |
| INV-26-1035 | Bajaj / TVS | Rico Jinfei Wheels (94.8%) | Uttarakhand (Haridwar) | ₹6.0 Cr | 22d | Current | Region-only | Open | Collections · Uttarakhand (Haridwar) |
| INV-26-1011 | Toyota / TKM | Rico Fluidtronics (100%) | South India (Chennai) | ₹8.0 Cr | 18d | Current | Allocated | Open | Collections · South India (Chennai) |
| INV-26-1026 | Honda (HMSI / Cars) | Aluminium HPDC (core) | North India (Haryana cluster) | ₹8.0 Cr | 18d | Current | Actuals | Open | Collections · North India (Haryana cluster) |
| INV-26-1001 | Hero MotoCorp | Aluminium HPDC (core) | North India (Haryana cluster) | ₹9.0 Cr | 14d | Current | Actuals | Open | Collections · North India (Haryana cluster) |
| INV-26-1016 | Renault-Nissan | Rico Fluidtronics (100%) | South India (Chennai) | ₹9.0 Cr | 14d | Current | Allocated | Open | Collections · South India (Chennai) |
| INV-26-1031 | Royal Enfield | Rico Jinfei Wheels (94.8%) | Uttarakhand (Haridwar) | ₹9.0 Cr | 14d | Current | Allocated | Open | Collections · Uttarakhand (Haridwar) |