Viewing Summary Vendor Scorecard Information

After you build the vendor scorecard file, you can inquire about a single vendor's high level performance without running a detailed report. If you prefer to view a scorecard data with individual purchase order detail, or a scorecard with data for more than one vendor, see Running the Vendor Scorecard File Report.

For purchasing metrics, 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.

See the What the Inquiry Shows section for a description of the metrics included in the summary.

Note: If you want to evaluate inventory metrics using a different cost basis, number of overstock days, or stagnant inventory days, you need to purge and rebuild the vendor scorecard file.

To inquire about a vendor's performance:

1. From the Reprts > End of Month Reports > Vendor Scorecard menu, select Vendor Scorecard Inquiry to display the Vendor Scorecard Inquiry screen.

2. In the Vendor field, enter the vendor for which you want to view summary information.

   If there is more than one ship-from vendors linked to a pay-to vendor, enter the pay-to vendor to see all the purchase order data for all the associated ship-from vendors. To see data for only one ship-from vendor, enter that vendor in this field.

   The inventory metrics report on products that are associated with the vendor you enter in this field. You can select one vendor to associate with a buy line. If you enter a pay-to vendor in the inquiry screen, the inventory metrics are calculated for products linked to the pay-to vendor and all ship-from vendors under that pay-to vendor. To see inventory metrics for only products linked to a ship from, enter that ship-from vendor in this field.

   Note: If you associate a pay-to vendor with a buy line, and enter a ship-from vendor in the inquiry screen, the inventory metrics do not include that buy line.

3. In the Br/Tr/All field, enter the shipping branch, branches, or territories for which want to view vendor data.

4. 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 summary.

For the Inventory Management metrics, the end date is the as of date for the metrics displayed.

If you enter an end date that is later than the end date you used when you built the scorecard file, the inquiry shows only data up to the last date available in the file.

5. Select which order types to include in the inquiry and press Enter:

   Field	Description
   Include Stock	Enter Y to include stock purchase orders in the inquiry. The inquiry includes only purchase orders that are completely received in the system, and excludes purchase orders that contain credit items, and orders flagged as exceptional. To inquire about only stock purchase orders, set this field to Y and the other fields to N.
   Include Direct	Enter Y to include direct orders in the inquiry. The inquiry includes only directs that are completely received in the system, and excludes any directs that contain credit items, and orders flagged as exceptional. To inquire about only directs, set this field to Y and the other fields to N.
   Include Procure	Enter Y to include procurement purchase orders in the inquiry. The inquiry includes only procurements that are completely received in the system, and excludes any procurements with credit items, and orders flagged as exceptional. To inquire about only procurements, set this field to Y and the other fields to N.

See What the Inquiry Shows for details about the metrics that display. To change the order types included in the calculations after you populate the screen, use the Inventory Options hot key.

To create a detailed report, use the Report hot key to display the Vendor Scorecard Report screen, populated with information from the inquiry window. For more information about changing the report options, see Running the Vendor Scorecard File Report.

6. Press Esc to clear the screen to run it for a different vendor, or press F12 to exit the screen.

What the Inquiry Shows

The following view-only information displays for the vendor based on the information you enter in the Start Date and End Date fields, and when the vendor scorecard file was built.

• Vendor purchases

  Metric	Description
  Total	The total amount, in dollars, of the purchase orders for the vendor  that you have completely received in the system during the selected date range. This total includes stock purchase orders, direct orders, and procurements.
  Stock	The total amount, in dollars, of the stock purchase orders for the vendor that you have completely received in the system during the selected date range.
  Direct	The total amount, in dollars, of the purchase orders for the vendor that you have completely received in the system during the selected date range.
  Procure	The total amount, in dollars, of the procurements for the vendor that you have completely received in the system during the selected date range.

• Inventory management

  Metrics are calculated as of the date you entered in the As of Date field, which defaults to the date in the End Date until you change it to a different date. Metrics default to include stock and customer consignments only. Use the Inventory Options hot key to enter a different as of date and to select whether to include stock and nonstockin the inventory metrics.

  The total for the inventory metrics is based on the cost basis you selected when you built the vendor scorecard file

  Note: Vendor consigned inventory is not included in inventory performance calculations. To gather inventory metrics, you must tie a vendor to products through your buy lines. See Assigning Vendors to Buy Lines for more information.

  To view more detail about individual product statuses and types, use the Inventory Valuation Report and the Inventory GMROI Report.

  Metric	Description
  Average Inventory	The average cost of your on-hand inventory from the vendor for the 12 months prior to the date listed in the As of Date field.
  Overstock	The average dollar amount of inventory from the vendor in excess of the days supply that you specified when you built the vendor scorecard file. The system calculates this value by multiplying the demand per day by the number of days indicated as overstock when you built the vendor scorecard file. This value is compared to what is currently on hand. Anything above the days demand is considered excess. The default overstock days is 90. This metric also provides the percentage of overstock inventory dollars compared to the total inventory dollars for the vendor you entered in the Vendor field. To view the products in your overstock, use the Inventory On Hand With No Sales Report.
  Stagnant	The average dollar amount of inventory from the vendor that has not sold in the time period you specified as stagnant when you built the vendor scorecard file. The default stagnant time period is 12 months. Important: Branch transfers are not included in this calculation. This metric also provides the percentage of stagnant inventory dollars compared to total inventory dollars for the vendor you entered in the Vendor field.
  Turns	The average amount of inventory sold from the vendor. The system calculates this value by dividing the total annual cost of goods sold (COGS) by the average dollars of inventory on hand for the 12 months prior to the date in the As of Date field.

• Performance results

  Metric	Description
  Average Lead time	The number of days between received date and order date for each item on a purchase order. The average lead time for a given vendor is the sum of all lead times divided by the total number of items on purchase for the vendor.
  Average No. Shipments	The average number of shipments it took the vendor to complete a purchase order. The average number of shipments is the sum of all shipments divided by the total number of purchase orders. The system considers a purchase order complete when the entire order quantity for every line item is 100 percent received.
  Initial Fill Rate	Stock line items received complete on the first invoice as a percentage of total stock line items on the purchase order. A complete shipment is required. The fill rate is zero if you have not received everything on the order. Final vendor initial fill rate is determined by summing the total items filled on first invoice for each purchase order, and dividing by the total number of items on all purchase orders.
  Shipping Accuracy	The number of lines shipped and filled 100 percent correctly divided by the total number of line items ordered. If you find inaccuracies in shipping, you can record codes to indicate the shipping inaccuracies. For more information, see Recording Vendor Shipping Inaccuracies.

• Electronic communications

  You can view metrics for each vendor around purchase orders sent to suppliers using EDI 850 purchase orders or orders that were created in response to inbound 855s for vendor managed inventory. Use the information displayed in the Electronic Communication Usage section of the screen to compare the EDI purchase order totals against all purchase orders totals.

  Field	Description
  EDI P/Os, Dollars, Line Items	The total number of EDI 850 purchase orders sent or purchase orders created in response to inbound 855s for vendor managed inventory. The Dollars field indicates the total amount of dollars received from the vendor for EDI purchase orders. The Line Items field indicates line items received on EDI purchase orders. Compare these totals with those displayed for all purchase orders in the Total P/Os fields. The percentage at the end of each row indicates the percent of the total purchase orders that were sent using EDI.
  Total P/Os, Dollars, Line Items	The total number of purchase orders, EDI and non-EDI, sent to vendors. The Dollars field indicates the total amount of dollars received from vendors on all purchase orders. The Line Items field indicates the total number of line items received on all purchase orders. Compare these totals with those displayed for only EDI purchase orders in the EDI P/Os fields. The percentage at the end of each row indicates the percent of the total purchase orders that were sent using EDI.
  #Inbound 810s	The total number of EDI 810 invoice documents you received.

See Also:

Running the Vendor Scorecard File Report

Building the Vendor Scorecard File