Poor supplier performance spreads its cost across customer service, operations and finance, and it is rarely traced back to the supplier responsible. A late delivery becomes a delayed customer order. A short shipment becomes a split pick. An inaccurate invoice becomes an afternoon of accounts payable time.
Supplier scorecards make that performance visible, so you can manage suppliers as partners rather than chase them after the event. Dynamics 365 Business Central already holds most of the data you need. The work is in presenting it in a useful way.
What Supplier Performance Data Already Exists in Business Central
For every purchase order, Business Central records the promised delivery date, the actual receipt date and quantity, and the invoiced price. Returns are recorded too, and once return reason codes are set up, each return carries the reason it was sent back. All of this depends on consistent purchasing discipline: purchase orders raised in the system and receipts posted when goods arrive.
The gap is usually reporting rather than data. Without a clear view by supplier, performance problems stay anecdotal and never make it into a structured conversation with the vendor.
The Core Metrics for a Logistics Supplier Scorecard
On-time delivery rate
The share of order lines delivered on or before the promised delivery date. This is the most important metric operationally, because late stock directly delays customer orders. As a common rule of thumb, an on-time rate below 85 per cent is a material risk to your own service levels.
In-full delivery rate
The share of order lines received in the full quantity ordered. Short deliveries cause stock gaps, partial picks and extra admin chasing outstanding quantities.
Invoice accuracy rate
The share of supplier invoices that match the purchase order without manual correction. Mismatches eat accounts payable time and hold up payment runs. A supplier that regularly invoices inaccurately carries a hidden admin cost.
Return rate
The value of goods returned as a share of total receipts over a period. A rising trend is often the first sign of a quality or packaging problem, well before it turns into a formal complaint.
Lead time reliability
The gap between the lead time a supplier quotes and the lead time it actually achieves. A supplier that quotes five days and delivers in seven forces you to hold more safety stock than the quoted figure suggests.
Building the Scorecard View
A Power BI report connected to Business Central's purchasing data can calculate each metric by supplier, rank suppliers against each other and flag any that fall below your thresholds.
The scorecard can sit in Microsoft Teams or SharePoint for everyday use by the buying team, be shared with category managers and form the basis of quarterly supplier reviews.
Using Scorecards in Supplier Conversations
Sharing scorecards with suppliers changes the relationship. A supplier that knows its performance is measured behaves differently from one that only hears from you when something has gone wrong.
Hold quarterly reviews with your most important suppliers and use the scorecard as the agenda. Recognise good performance, discuss weak areas with specific figures and agree what will change. In our experience, this improves supplier performance more reliably than reactive complaints.
Talk to Our Logistics Team
If supplier performance is causing problems and you have no consistent way of measuring it, we can show you what Dynamics 365 Business Central and Power BI can give you.
Contact Advantage today or call 020 3004 4600 to speak to our team.
Related Resources
- Power BI Reporting and Dashboards
- Supply Chain, Stock and Procurement Control
- Dynamics 365 Business Central
- Power BI for Logistics: The 6 Dashboards That Replace Your Spreadsheets
- Automating Purchase Orders in Business Central
Frequently Asked Questions
What data does Business Central hold for supplier performance?
Business Central records purchase orders, receipts, invoices and returns for each supplier, including promised and actual dates, quantities and prices. That data can be combined into performance metrics for any period. In most cases it only needs presenting in a structured report.
Which metrics should a distribution supplier scorecard include?
Start with five: on-time delivery rate against the promised date, in-full delivery rate, invoice accuracy rate, return rate by value and lead time reliability. Together they cover timing, completeness, admin cost, quality and planning risk.
Can Power BI build supplier dashboards from Business Central data?
Yes. Power BI connects to Business Central and can produce supplier rankings, trend lines and alerts when a supplier drops below a threshold. Reports can refresh on a schedule and be shared automatically with the buying team.
How do scorecards help with supplier negotiations?
They give you documented evidence of performance over a defined period. You can recognise strong suppliers with facts, and challenge weak ones with specific figures rather than impressions.
