ACP - Invoice Aging Report
Overview
The Accounts Payable ‘Invoice Aging Report’ lists the unpaid amount of invoices at a nominated date aged into; current, 30 days, 60 days, 90 days and 90+ days periods. The report has two layout options:
A detailed layout with each unpaid invoice aged into; current, 30 days, 60 days, 90 days and 90+ days periods.
A summary layout with the unpaid invoice total for each supplier aged into; current, 30 days, 60 days, 90 days and 90+ days periods.
Important!
This report should not be used for balancing the AP Ledger with the AP Control Account in General Ledger. Use the AP Snapshot Report for this purpose.
The report will not run if there are unposted transactions for the 'Date' specified for earlier periods. To check postings run Finance > Accounts Payable > Period End > Post Period Activity.
General Tab
A 'Cut-off and Aging Date' for the report must be entered. The report will include all unpaid invoices with an invoice date less than or equal to this date.
The report can be generated for a single Supplier or other combinations by using the other fields on this tab to make selections.
The 'Supplier Type' and 'Terms' fields allow multiple selections. Holding down the 'Shift' key while clicking on your options permits a range selection; holding down the 'Ctrl' key enables selection of discrete (individual) criterion.
Print Tab
Sort By
The default is for the report to sort by 'Supplier Code'.
Alternatively, you can elect to sort by 'Supplier Name'.
Formatting Options
Choose the 'destination' of the report. This can be to Adobe® PDF viewer, Microsoft Excel® or Microsoft Word®.
The report is available in Summary or Detailed format. Select the required option from the drop-down provided.