N24 Vendor Rating

Vendor evaluation based on hard data from Business Central — with AI summaries that highlight priorities and recommend actions.

⭐⭐⭐⭐⭐

N24 Vendor Rating turns scattered observations about vendors into a single, measurable quality score. The system collects data from purchasing documents (receipts, invoices, credit memos, return shipments), calculates five rating criteria with weights, and produces a percentage score plus a letter classification (A–E) for each vendor. With AI integration — alongside data tables you get a ready-made summary with action recommendations.

🔎 What problems does it solve

Lack of systematic vendor evaluation

Many companies work with vendors for years without a tool for objective quality assessment. Decisions about continuing or changing a vendor are based on gut feelings rather than data. N24 Vendor Rating introduces a repeatable, documented process that can be run quarterly, monthly, or on any cycle.

Manual data collection is time-consuming

Analyzing delivery timeliness, quantity accuracy, or delivery quality requires manually reviewing purchasing documents. This is work that nobody wants to do regularly — and when done, is often based on incomplete data. The system collects data automatically with one click.

Subjectivity of evaluations

Evaluations based solely on employee opinions can be unfair or incomplete. The system is based on hard transactional data, which eliminates bias and produces comparable results over time.

👥 Who is it for

  • Procurement — for regular vendor evaluation and benchmarking.
  • Management — for decisions about continuing partnerships, negotiating terms, or changing vendors.
  • Quality department — for monitoring delivery quality and identifying issues.
  • Internal audit — for documenting the evaluation process with full history and approval trail.

The solution is designed for companies that regularly purchase goods or services from multiple vendors and want control over supply chain quality.

✨ AI at the core of the evaluation process

Vendor evaluation is not just tables with percentages. N24 Vendor Rating uses AI at two key moments:

  1. Automatic feedback scoring — after entering a comment about a vendor, AI assigns a rating of 1–5 and flags entries requiring management attention. Zero subjective scoring.
  2. AI Summary — with one click, a report is generated: who requires immediate action, who has improved, what patterns repeat across the entire vendor base. With a class distribution chart and specific recommendations.

This is not a report for analysis — it is a report that analyzes itself.

👌 Full feature list

  • Vendor rating sheets with automatic calculation of five criteria: on-time delivery, quantity reliability, price efficiency, complaint-free deliveries, manual rating.
  • Three price comparison methods: purchase price list, cross-vendor average, historical trend.
  • Configurable weights (1–5) and tolerances — tailored to company policy.
  • Manual vendor rating from FactBox — directly on the vendor card or purchasing document, with comment and 1–5 rating.
  • ✨ AI: automatic feedback scoring with flagging of entries requiring management attention.
  • ✨ AI: sheet summary with priorities, trends, and class distribution chart.
  • Vendor classification (A–E) with status: Approved, Conditional, Warning, Blocked.
  • Warning on purchasing documents when selecting a vendor with low classification status.
  • Sheet approval with full audit trail (who approved and when).
  • Color-coded results with drilldown to source documents — configurable colors for each vendor class.
  • Skipping blocked vendors — the generator automatically excludes vendors with a filled Blocked field on the vendor card.

Typical workflow

  1. You create a rating sheet for a chosen period (the system suggests dates from a formula, e.g. -3M).
  2. With one click on Generate Rating — the system calculates results for all vendors.
  3. You review results (with drilldown to source documents) and approve the sheet.
  4. Upon approval, the system assigns an A–E classification and saves it on the vendor card.
  5. (Optional) You generate an AI Summary — a ready-made report with recommendations.

Five quality indicators

Criterion What it measures Example
On-Time Delivery Compares planned delivery date with actual receipt date. Delay tolerance is configurable (default ±2 days). 18 out of 20 deliveries on time → 90%
Qty Reliability Compares ordered quantity with delivered quantity. Both shortages and surpluses reduce the score. Ordered 1000 pcs, received 950 → ~95%
Price Efficiency Compares invoice prices with a reference price (price list, cross-vendor average, or historical trend). Invoice price 105, price list 100 → 95%
Complaint-Free Percentage of deliveries without credit memos or returns. 500 pcs received, 25 returned → 95%
Manual Rating Employee rates vendor 1–5 with a comment. Rating normalized to 0–100%. Rating 4 → 75%

Each criterion has a weight (1–5). The final score = weighted average of active criteria. Missing data does not penalize the vendor — the criterion is simply excluded.

💥 Benefits

Benefit Description
Objectivity Evaluation based on transactional data, not subjective opinions.
Time savings Automatic calculation eliminates manual data collection from documents.
Repeatability A standard process that can be run monthly, quarterly, or on any cycle.
Transparency Every result can be verified — drilldown to source data.
Flexibility Configurable weights, tolerances, and criteria tailored to company specifics.
Auditability Sheet history with information on who approved and when.
Classification Automatic assignment of A–E classes with statuses on the vendor card.
AI takes over analysis Alongside tables — ready-made recommendations and class distribution chart.

🌱 Getting started

  • Getting Started — how to set up the module and prepare the first rating sheet.
  • Permissions — roles and access to extension pages.