Accounts Payable Aged Invoices

Overview

Account Payable Aged Invoices displays the accounts payable documents with an open balance. Use this report to determine what your company owes to your vendors and when the vendor is expecting payment. 

Report Options

Internal Company – The company from which the data is being reported.

Vendor(s) – Click Lookup to select the vendors to be included on the report. One or more vendor id’s may be selected. If the field is empty, all vendors will be considered for inclusion on the report.

In Select Documents By, choose the date type to use to determine which payables documents to include on the report. 

In Selection Date, select the date to use as the cutoff date for payables documents to include on the report.

In Using, select which method to use for aging the payables document on the report. Options include:

Last Aging Process Results – This option uses the date used the last time the Aging process was run.

Specific Aging Date – This option uses the date entered in Aging Date on Report Options. This implies aging will be done "on the fly" as the report is running.

Note: A valid date must be entered in Aging Date when Using is set to Specific Aging Date. This is a required field.

Note: When Using is set to Specific Aging Date, the payables document will be aged "on the fly" using the date selected for Age Invoices By on the Settings tab of Receivables Policies under Financials | Setup.

Vendor Class – Click Lookup to select the customer class to be included on the report. One or more customer class IDs may be selected. If the field is empty, all customer classes will be considered for inclusion on the report.

Payment Hold Invoices Only – Select this check box to include only those accounts payable invoices that have a document status = HOLD.

Hold Reason – Select a hold reason from the dropdown box. The values in the dropdown box are defined in Reasons under Administration | Setup.

Summary or Detail – Select Summary to have the transactions summarized by Project ID. Select Detail to display individual transactions. This option defaults to Detail.

Print Zero Balance Vendors – Select this check box to have vendors with a current balance of zero included on the report.

For information about using this report in the financial reconciliation process, see Reconciling Account Balances.