Our Historical Aged Trial Balance ages amounts based on days from invoice date:
0-30 days
31-60 days
61-90
91 and over
Total
However, not all of our customers have 30 day terms. Some have 35, 45, and even 60 day terms. I would like the aging to be based on the terms, so that the aging buckets reflect the current or past due status of the invoice, not how many days old it is.
Current
1-30 Days Past Due
31-60 Days Past Due
61+ Days Past Due
Total
Is there somewhere that I can change this?
Thank you.