A/R Future Receivables Breakdown
Hi all
Let me know if you can help with the below
As we know, the report A/R Details with Aging shows the overdue amounts as per below
| Total | Not Due Yet | Due | Overdue | Overdue | Overdue | Overdue | |
| Customer | Open Amount | Future | Current | 31-60 | 61-90 | 91-120 | … |
| XXX | 100 | 60 | 20 | 10 | 5 | 5 |
The user would like to see forecast instead
Like in the second table below
| Total Future | Not Due Yet | Not Due Yet | Not Due Yet | Not Due Yet |
| 0-30 | 31-60 | 61-90 | 91-120 | |
| 60 | 30 | 15 | 10 | 5 |
0