You can change the ageing periods in Settings>Supplier Defaults> on the Ageing tab you will find a variety of options.
This report is in date order in most versions.
What version are you using?
You could add a sort to make it in date order in the report designer.
For just about anything Sage :- switch to renting, pay-as-you-go sage support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me