Payables aging report

1. Navigate to ACCOUNTING > Payables > Payables Reports.

2. Select Payables Aging Report.

3. Filter using the following fields:

As At - Click and define specific date parameter

• Specific date
• Accounting Month/Accounting Year

Report Currency - Select a reporting currency

• Office currency
• Invoice currency

Include FX Revaluations - Check to include FX revaluations
Group by Master Supplier? - Check to group the payables report by a master supplier.
Group by Accounts Payable GL Account? - Check to group the payables by accounts payable GL accounts.
Aged By - Select an aged by timeframe.

• Invoice Date/Month
• Due Date/Month

Supplier Totals Only - Check to show supplier totals only.
Supplier - Enter or select a supplier.
Supplier Code Range - Enter a supplier code range.
Master Supplier - Enter or select a master supplier.
Entity - Select an entity if applicable.
Include Inactive Offices? - Check to include inactive offices.
Separate Report for Each Office - Check to view a separate report for each office.

4. The following are the buttons available on the page:

Excel - Click Excel to view and download an Excel version of the report.
Print - Click to export the report as a PDF.
Preview - Click preview to view and save a PDF version of the report.
Arrow Back - Click to close to return to the previous screen.
Offices - Click and select the offices that need to be included in the report.
Supplier Types - Click and select the supplier types that need to be included in the report.
Master Supplier Types - Click and select the master supplier types that need to be included in the report.
Payment Types - Click and select the payment types that need to be included in the report.

Tip: You can access outstanding supplier invoices directly from the Payables Aging report by clicking a link from the Excel version of the report.