Running the A/P Aging Report

Run an A/P Aging Report to create a picture of how much money your company owes your vendors and for how long your company has owed the money. While you probably do not want to run this report for use as a payables reference tool, you might want to run a file copy after an auditor has closed the accounting period, or a review copy for a branch or payables manager.

Before you run this report, we recommend that you set the Respect Authorized Branches for A/R and A/P Inquiry and Ledger control maintenance record.

To increase the speed of this report and allow for multiple phantom threads to run at the same time, set the PHANTOM.THREAD.COUNT authorization hot key.

For a description of the report, see What the Report Shows at the end of the topic.

To run an A/P Aging Report:

From the A/P > Reports menu, select A/P Aging to display the A/P Aging Report screen.
In the As of Date field, enter the date to determine which payables to include in the report. Only payables with payment dates prior to or equal to this date are included. The default is the current date.
In the Age as of field, enter the date to determine the age of the invoices to include in the report. The default is the current date.
In the Home Branches field, enter the branch, territory, or All to include in the report.
In the Incl Blank Home Br (Y/N) field, indicate whether to include those vendors that have no Home Branch assignment.

If you specified All in the Home Branches field, enter Y in this field.
If you run separate reports for different branches or territories, enter Y in this field for only one of the reports. Otherwise, you include the same vendors in multiple reports.

In the Purchase Branches field, enter the branch, territory, or All to restrict the report to only those areas that receive products and have accounts payable.

In the Detail/Summary field, press F10 and select one of the following to determine the level of detail to include on the report:

Detail – Includes all payables for each vendor, followed by the aging totals for that vendor, disbursements, and grand totals for all vendors displayed.
Summary – Includes only aging totals for each vendor, followed by grand totals for all vendors. This is the default.

In the Vendor Currency field, to select only those vendors who have a designated primary currency that is different from your company's base currency, press F10 and select a currency.
In the Report Currency field, to print the report in a currency other than your company's base currency, press F10 and select a currency.

Note: To print the report in U.S. currency, leave this field blank.

In the Display Branch field, press F10 and select one of the following to determine which branch to display on the report:

Home Branch – Includes an H.Br column at the right side of the report that lists the vendor's home branch.
Purchase Branch – Includes a P.Br column at the right side of the report that lists the vendor's purchase branch.
Both – Includes both an H.Br column and a P.Br column on the right side of the report, listing the vendor's home branch and the vendor's purchase branch, respectively. This option is only available when you run the report in Detail mode.
None – Does not include information about either the vendor's home or purchase branch.

In the Sort by field, press F10 and select one of the following to determine which branch to sort by:

Home Branch – Sorts vendors by their home branch.
Purchase Branch – Sorts vendors by their purchase branch.
Vendor – Sorts vendors by the following information:
First, by the value in the Sort By field on the Customer Maintenance screen.
Second, by the value in the Bill field on the Customer Maintenance screen.
Third, by the value in the Order # field on the Order Entry screen.
All orders for each vendor are followed by a total for that vendor. If you include blank home branches, vendors not assigned a home branch are listed after the vendors assigned a home branch. Grand totals for all vendors displays at the end of the report.

In the Vendor Level field, press F10 and select one of the following to determine how customer information displays.
Pay-To – Displays information for pay-to vendors only, with subtotals for each, and then displays the totals for all pay-to vendors.
Ship-From – Displays information for ship-from vendors only, with subtotals for each, and then displays the totals for all ship-from vendors.

Set options, if needed, and generate the report.

What the Report Shows

The A/P Aging Report shows the following information:

Column	Description
Home Branches	The main branch associated with this report.
Purchase Branches	Which purchasing branches the report includes.
ID#	The identification number associated with the vendor.
Vendor Name	The name of the vendor to which the payable is due.
Future	Those payables that are due after the due date of the current fiscal month.
Current	Those payables that are due within the current fiscal month.
31-60	Those payables that are between 31 and 60 days due.
61-90	Those payables that are between 61 and 90 days due.
91-120	Those payables that are between 91 and 120 days due.
Over 120	Those payables that are over 120 days due.
Total	The total of all amounts in all the columns.