...
Click Setup tab
Click Aged Balance Report Settings
Add the number of days each column should represent (example below)
Click the Save button
Confirm the changes took effect by going to the Aged Report
Load the Reports tab
Click on Aged Balance
Click the Date button in the lower right
On the page that loads select a date (this forces the system to regenerate the report with your new configuration)
Note: the Date value returns values that are less than the selected date. For example, to report on transactions that are dated April 30th or older, select a date of May 1. If you select April 30th as the date the report will return date up until the end of day, April 29thConfirm that the report shows the columns as needed
Automating Aged Report Generation
The below allows you to setup an SQL job to generate an AR report on any schedule you wish. If your AR report takes a long time to load then this approach may be a good option.
...