Run the 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 what is 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 the Vendor Payables Report:
From the A/P > Reports menu, select Vendor Payables to display the Vendor Payables Report window.
In the Branch/Territory field, enter the branch, branches, or territories for which you want to run the report.
In the As of Date field, enter the first date of the period to include 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 field, 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, select a currency to include only those vendors who have a designated primary currency that is different from your company's base currency. The report runs for only vendors that use that currency.
In the Report Currency field, select a currency other than your company's base currency to print the report in that currency.
To print the report in U.S. currency, leave this field blank.
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. |
See Also: