Running the Vendor Payables Report

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:

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

To run the Vendor Payables Report:

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

  2. In the Branch/Territory field, enter the branch, branches, or territories for which you want to run the report.

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

  4. In the Sort By field, select one of the following to determine how to sort the vendors on the report:

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

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

  1. Set options, if needed, and generate 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.

 

See Also:

A/P Reports Overview