Running the A/P Aging Report

Run the A/P Aging Report to create a picture of how much money your company owes your vendors and for how long the money has been owed. 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 an 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 Ledgercontrol maintenance record.

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

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

To run the A/P Aging Report:

1. From the A/P > Reports menu, select A/P Aging to display the A/P Aging Report window.

2. 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.

3. 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.

4. In the Vendor'sHome Branches field, enter the branch, branches, or territories, to include in the report. You are only able to report on home branches to which you are authorized.

5. Select the Include Vendors with Blank Home Branch check box to include vendors in the report that do not have a home branch assigned.

• If you entered All in the Home Branches field, select this check box.

• If you run separate reports for different branches or territories, select the check box for only one of the reports that you run. Otherwise, you multiple reports include the same vendors.

6. In the Purchase Branches field, enter the branch, branches, or territories to restrict the report to only those areas that receive products and have accounts payable. The default is ALL.

7. 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, select from a list of currencies.

8. In the Report Currency field, to print the report in a currency other than your company's base currency, select from a list of currencies.

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

9. In the DisplayBranch field, 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.

• None - Does not include information about either the vendor's home or purchase branch. This is the default.

10. In the Sort By field, select one of the following to determine how to sort the contents of the report:

11. 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 information in the Sort By field in the vendor's record in Vendor Maintenance.

• Second, by the information in theBillfield in the vendor's record in Vendor Maintenance.

• Third, by the information given in theOrder #field in the vendor's purchase orders..

All orders for each vendor are followed by a total for that vendor. If you select to include blank home branches, vendors who are nott assigned a home branch are listed after the vendors who do have a home branch assignment. Grand totals for all vendors displays at the end of the report.

11. In the Mode area, select one of the following to determine the level of detail to include in the report.

• Summary - Includes only aging totals for each vendor, followed by grand totals for all vendors. This is the default.

• Detail - Includes all payables for each vendor, followed by the aging totals for that vendor, disbursements, and grand totals for all vendors displayed.

12. In the Vendor Level area, select one of the following to determine how vendor information displays.

13. Pay-To - Displays information for pay-to vendors only, with subtotals for each, and then displays the totals for all pay-to vendors.

14. Ship-From - Displays information for ship-from vendors only, with subtotals for each, and then displays the totals for all ship-from vendors.

13. Set options, if needed, and generate report.

What the Report Shows

The A/P Aging Report shows the following information:

See Also:

A/P Reports Overview