Viewing the Average Discount by Funds Report
The Average Discount by Funds report displays the average percentage discount between the E PRICE value and the PAID field amount in selected order records. To view vendor average discount information:
- Choose Average Vendor Discount from the reports menu. If a current report exists, the report displays in the report frame.
- To generate a new report, choose Calc and enter new report parameters as described by doing any one of the following:
- Enter a date range by specifying a Starting Paid or Invoice Date and Ending Date.
- Specify a date range by choosing MTD (month to date), Last Mo, or Fiscal YTD (year to date).
- Specify an order record range by entering record numbers in the Minimum Order Record # and Maximum Order Record # fields.
- Specify a review file by choosing the radio button next to the review file name. The list of review files includes only those that contain order records.
- Choose Submit.
The Average Vendor Discount report displays the following information:
- Date/Record/Review file range — Depending on how you created the report, this shows either the review file description or the record range chosen for this report, the range of PAID or INVOICE dates, and the date the report was created.
- Vendor code — The code used to identify the vendor.
- Avg. % discount all funds — The average percentage discount for all funds for the selected vendor. This value is used when you choose the Bar Graph tool from the toolbar.
- Fund code — The system-wide code for each fund found in order records included in the current report. See Maintaining Funds for more information.
- % discount for fund — The average percentage discount, positive or negative, for each fund for the selected vendor. These values are used to generate the average percentage discount for each fund when you choose the Bar Graph icon to the right of the vendor code.
Report Retention
- The system stores only one Average Discount report, and creating a new report overwrites the previous one. Note that generating a report can take a while.
- If the current report is for a different accounting unit, you may not view it. You can calculate a new report for your accounting unit, but it overwrites the existing report.
- The system deletes reports after seven days.