Report Yearly Vendor Purchases Comparison
Access
This report compares the purchase dollars spent with each selected vendor during two user-specified periods. Buyers and upper management personnel can use this report for planning purchases. Selection is by vendor class and vendor number. You can rank vendors by
-
dollars spent with them during the earlier period (Compare From),
-
amount spent with them during the more recent period (Compare To), or
-
by Vendor Code.
The report uses written purchase dollars for any given period on which you report. Note that this program ignores the Closed Purchase Order Retention Days field in the Purchasing Control Settings, and instead retains 2 years of purchase order data.
The run-time options for this report are:
Vendor ClassEnter the vendor class (from the Vendor record ) wanted for this report or leave blank to include all vendor classes.
Vendor CodeThis field is used to indicate the vendor or vendors to be included on this report. One, multiple, or All vendors may be selected. To report on a single vendor select a specific vendor code at this field. To report on all vendors, leave this field blank. To report on multiple vendors, use the Multiple Vendors Selection screen (available from Actions) to select the vendors for this report.
Compare From
Start PeriodSelect the starting period for the historical period that the report is to compare from.
Start YearEnter the starting year for the historical period that the report is to compare from.
End PeriodSelect the ending period for the historical period that the report is to compare from.
End YearEnter the ending year for the historical period that the report is to compare from.
Compare To
Start PeriodSelect the starting period that the report is to compare to.
Start YearEnter the starting year that the report is to compare to.
End PeriodSelect the ending period that the report is to compare to.
End YearEnter the ending year that the report is to compare to.
Minimum AmountEnter the minimum purchase dollar amount to report on. This field is optional.
Rank BySelect From to rank the report by the historical period. Select To for ranking by the current period. Select Number to rank by vendor number.
Send Output toThe output destination of the report displays. To change the output destination, click on the Actions button and select Output Settings.
Export PathIf you select either the Personal Report Viewer (PRV), Excel Export, or ASCII Export, this field displays the pre-set computer drive and folder location to which the system exports the report data. You cannot edit the export path using this process.
Once the run-time options have been selected, choose Run to produce the report.