Running the Vendor Purchases Report

Run a Vendor Purchases Report to create a summary of purchase and payment information for all received inventory, including tagged and direct, for each vendor as of a designated date. Typically run at the end of the year, this report can be used to reconcile rebates that are due. For example, if you are part of a buy group for Sylvania and they send you a rebate check based on their records, you can use this report to verify that their totals are correct and you are being paid the correct amount.

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.
Current 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 Purchases Report:

From the A/P > Reports menu, select Vendor Purchases to display the Vendor Purchases Report screen.
In the Br/Tr/All field, enter the branch, territory, or All to include in the report.
In the Start Date field, enter the first date of the period to include in the report.
In the End/As of Date field, enter one of the following to determine the last date of the period to be included in the report:
If you populated the Start Date field, enter the last date of the period to be included in the report.
If you left the Start Date field blank, enter the date to be used in calculating the MTD (month to date) and YTD (year to date) totals.

In the Vendor field, do one of the following to determine which vendor's invoices to include in the report:
To include only those invoices from a particular vendor, enter that vendor's name in this field.
To run the report for all vendors, leave the field blank.

Note: This field accepts only pay-to vendor information. For information on a report that allows entry of a pay-to vendor or a ship-from vendor, see Running the Product Purchases Report.

In the Sort by field, enter one of the following to indicate how to sort the vendors on the report:
Purchases – Lists the vendors by descending purchase totals. Vendors with the highest totals are listed at the top of the report, and vendors with zero totals are listed at the bottom of the report.
Vendor – Lists the vendors alphabetically.

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 Purchases Report shows the following information:

Column	Description
Vendor	The vendor for whom the report was run.
Branch(es)	The branches for which the report was run.
Vendor Name	The vendor from whom a particular purchase was made.
MTD Purch	The month-to-date purchases from a vendor.
LYMTD Purch	The previous year's month-to-date purchases from a vendor.
YTD Purch	The year-to-date purchases from a vendor.
LYTD Purch	The previous year-to-date purchases from a vendor.
DT Range Purch	The range of dates that purchases were made.
Curr Pybles	The current payables owed to a vendor.
MTD Pymnts	The month-to-date payments made to a vendor.
YTD Pymnts	The year-to-date payments made to a vendor.
VN#	The vendor number.
Dt Range Pybles	The ranges of dates that payables were made.