To run the Vendor Scorecard File Report:After you build the vendor scorecard file, you can run reports on the data the system gathered. From the report, you can drill into purchase orders to review order and line item data. You can also drill into orders to log shipping inaccuracy codes for specific line items. If you are a member of the National Association of Electrical Distributors (NAED), you can run the report and print or download the results to send to NAED.
If you prefer to view a single vendor's scorecard data online in a summary inquiry screen without the individual purchase order detail, see Viewing Summary Vendor Scorecard Information.
The vendor scorecard includes only purchase orders, direct sales orders, and procurements that are completely received in the system. The scorecard excludes purchase orders that contain one or more credit items, as well as purchase orders that are flagged as exceptional.
The report shows the same metrics as the inquiry screen. For more information, see Viewing Summary Vendor Scorecard Information.
To run the Vendor Scorecard File Report:
From the Reprts > End of Month Reports > Vendor Scorecard menu, select Vendor Scorecard Report to display the Vendor Scorecard File Report/Download screen.
In the Br/Tr/All field, enter the shipping branch, branches, or territories for which you want to run the report.
In the Start Date and End Date fields, enter the first date and last date in the range of dates for which to select purchase orders, directs, and procurements to include in the report.
In the Vendor field, enter or select the vendor you want to include in the report.
To include more than one vendor in the report, use the Multi hot key and enter all the vendors you want to include. Leave this field blank to include all vendors in the report. To run the report for all vendors assigned to buy lines as Vendor Scorecard vendors, leave this field blank.
Select which order types to include in the report.
In the Page Break on Vendor? field, enter Y to insert a page break after each vendor. Enter N to use natural page breaks in the report and to not separate each vendor's data with a page break.
In the Show PO Details field, enter Y to break down the vendor data by individual purchase order for each vendor included in the report. To report only on the summary information without the detail, enter N in this field.
In the Show Inventory Metrics field, enter Y to include metrics for average, overstock, stagnant, and inventory turns.
To select the select the inventory types to include, and to change the date as of which the metrics are calculated, use the Inv Opts hot key, make your selections, and press Esc.
See Also:
Building the Vendor Scorecard File