The Aged Accounts Payable Analysis Report is a detailed and comprehensive report that shows all your outstanding balances and payables in aging periods for all your suppliers. The aging period ranges from 30 days to 120+ days with indicated total days overdue. It also includes last-year-to-date and year-to-date analysis for each transaction. Each currency has sub totals recorded in the report.
View the Accounts Payable Aging Report
These reports can be easily accessed through the Report Center menu of any modules in Connected Business. On the Report Explorer pane, click on Reports ► System Reports ► Accounting ► Retrospective Analysis. These are the reports under the Accounts Payable Aging folder.
Aged Accounts Payable Analysis (Doc Date) - In this report, your outstanding payables to your suppliers are calculated based on the date when the transaction is created.
Aged Accounts Payable Analysis – Doc Date (Value in Base) - In this report, your outstanding payables to your suppliers are converted according to the home currency used by your business and based on the date when the transaction is created.
Click Image to Enlarge
Aged Accounts Payable Analysis – Due Date - In this report, your outstanding payables to your suppliers are calculated based on the due date of the transaction.
Aged Accounts Payable Analysis – Due Date (Value in Base) - In this report, your outstanding payables to your suppliers converted according to the home currency used by your business and based on the due date of the transaction.
Click Image to Enlarge
Set the Filter Criteria on Accounts Payable Aging Report
Suppose you would like to view the aging recap and statistical summary of all your accounts payables activities as of a particular date, select any A/P aging report layouts from above mentioned reports and click on the Print > Print Dialog button from the menu options.
On the Filter Criteria section, click the 
button to add a new condition. Select the “As of”, include the condition in the A/P Retrospective Reports and the date to which you want it to appear on your report. Setting the date criteria in all these reports will change the “As Of” date to the current condition.
Click Image to Enlarge
Print the A/P Aging Report
After setting the filter criteria, you may now print the file by clicking the Print button. Select the way you want it to print such as print to file, preview, print, fax or email. When you update any of these transactions, these automatically reflected real-time to the Accounts Payable Retrospective report. The snapshot below is a sample Aged A/P Analysis report.
Click Image to Enlarge
Thanks for reading this blog! Please refer to our Online Documentation about Accounts Payable Aging Report for more information.