Running the Vendor Payables Report

Run a Vendor Payables Report to create a summary of all the payables for each vendor as of a designated date. Typically run at the end of the month, this report shows you what is due to your vendors and outstanding in your books. For example, you can run this report to verify that you have paid all vendor bills due by close of business on the last day of the month.

The report provides the following information for each vendor:

Totals for the current month and the previous month.
Totals for the current year and the previous year.
Open payables.
Month-to-date and year-to-date payments.

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

To run a Vendor Payables Report:

From the A/P > Reports menu, select Vendor Payables to display the Vendor Payables Report screen.
In the Br/Tr/All field, enter the branch, territory, or All to include in the report.
In the As of Date field, enter the first date of the period to be included in the report. The system uses this date to calculate the MTD (month to date) and YTD (year to date) totals.
In the Sort by Vendor/Payable field, press F10 and select one of the following to determine how to sort the vendors on the report:

Vendor – Lists the vendors alphabetically.
Payable – Lists the vendors by descending payable totals. This is the default.

In the Vendor Currency field, to include in the report only those vendors who have a designated primary currency that is different from your company's base currency, select from a list of currencies.
In the Report Currency field, do one of the following to determine in which currency to print the report:
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.

Set options, if needed, and generate the report.

What the Report Shows

The Vendor Payables Report shows the following information:

Column	Description
Branch	The branches for which the report was run.
Vendor Name	The vendor that made a particular purchase.
MTD Payable	The month-to-date payables owed by a vendor.
LYMTD Payable	The previous year's month-to-date payables owed by a vendor.
YTD Payable	The year-to-date payables owed by a vendor.
LYTD Payables	The previous year-to-date payables owed by a vendor.
Open Payables	The total open payables owed by a vendor.
MTD Pymnts	The month-to-date payments made by a vendor.
YTD Pymnts	The year-to-date payments made by a vendor.