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.
Once the run-time options have been selected, choose Run
to produce the report.
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.
