Skip to main content

Supplier Scorecard

The supplier scorecard rolls on-time delivery, GRN variance, quality, and price into a single 0 to 100 score, so you can compare vendors at a glance. Viewing needs View inventory reports; settings and recalculation need Manage inventory.

How the score works​

PartWhat it measuresDefault weight
On-time deliveryAgainst the earlier of your expected date and the supplier's promised date40
GRN varianceQuantity and price differences on receipt25
QualityGoods returned to the supplier plus goods rejected at receipt QC20
PricePrice stability, averaged with how often bills stayed at or under the order price15

Use the scorecard​

  1. Make sure purchase orders have Expected delivery dates and GRNs are linked to them.
  2. Post GRNs and returns as usual. The scorecard reads them; it creates nothing.
  3. Open Inventory Reports → Supplier scorecard after the monthly update, or choose Recalculate for last month.
  4. Review the ranking (trend arrow, At risk filter), open a supplier for the breakdown and 12-month chart, and Export to Excel.
  5. Under Settings, adjust the weights (they must total 100) and the at-risk threshold (default 60).

A score badge shows next to the supplier on purchase orders, with a warning when it is below the threshold. The warning doesn't block the order. On the Health Dashboard, open Suppliers below threshold whenever that card is above zero.

:::info Where the threshold lives The supplier score threshold is on Supplier scorecard → Settings, not in Inventory setup. :::

Next step​