Run the 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 the Vendor Purchases Report:
From the A/P > Reports menu, select Vendor Purchases to display the Vendor Purchases Report window.
In the Branch/Territory field, enter the branch, branches, or territories for which you want to run the report.
In the Start Date and End Date fields, enter the first and last dates in the period to include in the report.
If you leave the Start Date field blank, in the End Date field, enter the date to use in calculating the MTD (month to date) and YTD (year to date) totals.
In the Vendor field, enter a vendor to run the report for purchases only from that vendor. To run the report for all vendors, leave this field blank.
Note: This field accepts only pay-to vendor information. For information about 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, select 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 by vendor name.
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 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. |
See Also: