Accounts Payable > Other Reports on AP Transactions > Payable Management Reports

The Forecast AP Aging Report function allows you to print or preview information on the outstanding AP invoices as of a given future date. Aging ranges or age brackets are defined in the AP Module Setup function's Printing Page.

This report has the following uses:

•To determine cash requirements to pay off the outstanding payables

•To help manage the company’s payables since the report outlined clearly the invoices that are due for payment

To generate the Forecast AP Aging Report, follow these steps:

1.Access the Forecast Aging Report function from the Payable Management group in the Reports main menu.

2.Click the List box button next to the Configuration field; then, select the report configuration that you want to use.

3.Select the report sorting option by clicking on the List box button next to the Sort By field.

4.In the Layout field, click the List box button to select the report layout you want to use in generating the report.

To show multi-currencies in the report, select the option with 'multi-currency' in the layout name. Note that this layout option is only available if the multi-currency feature is activated.

5.In the Report Configuration area, define the report filters. Depending on the Sort By option you choose, you may mark the Individual checkbox if you want to generate the report for a single record and enter the appropriate value in the adjacent field; otherwise, select in the Filters area the preferred criteria in generating the report.

6.Enter in the Report Date field a date that will serve as the cut-off date for the report. You may click the Calendar button to display a calendar where you can select an appropriate date.

7.Select the option for which you want to age the invoices by:

oAge by Due Date

Select this option if you want the system to age the AP invoices based on their due dates.

oAge by Invoice Date

Select this option if you want the system to age the AP invoices based on their invoice dates.

8.Mark any or all of the following checkboxes:

oInclude Open Debit Transactions

Mark this checkbox to show in the report open debit transactions.

oShow Total On-Hold Checks

Mark this checkbox if you want the report to display the total check amounts that are put on "hold" status.

9.Click the Preview or Print button to preview or print the report. Click the Configure tab to return to the report configuration page.

The Forecast AP Aging Report function also provides you with flexibility to perform the following:

•Set up user-defined sort option

•Set up user-defined report layout

•Include notes in the printed report

•Export the report to various supported file formats

•Send the report as attachment to an email

•Drill-down on certain fields in the report:

oVendor #

AccountMate displays the Vendor Profile when you click the Vendor # in the report.

Forecast AP Aging Report

Forecast AP Aging Report

See Also