How to Track Supplier OTIF When Your ERP Data Is Incomplete
🎧 Listen to this article (7 min)
How to Track Supplier OTIF When Your ERP Data Is Incomplete
When your ERP system only tells part of the story, tracking On-Time In-Full (OTIF) delivery performance can feel impossible. Yet, OTIF remains one of the most actionable metrics for managing supplier reliability. The good news is, even with incomplete ERP data, you can still build dependable dashboards that surface the right insights for performance improvement. By enriching limited ERP feeds with external confirmations, defining clear measurement rules, and automating dashboards, supply chain teams can maintain visibility and accountability across suppliers without waiting for a full integration project.
Align OTIF Definitions and Segmentation
Before calculating or comparing OTIF across suppliers, ensure everyone is speaking the same language. OTIF measures the percentage of orders delivered both on time and in full, calculated as:
(Orders delivered On-Time AND In-Full divided by Total Orders) x 100.
Ambiguity about what counts as "on time" or "in full" can distort results. Some teams define "on time" as the exact requested date; others use a tolerance window (such as plus or minus 2 days). Likewise, "in full" may be defined at order, line, or SKU level. Setting and documenting these thresholds makes your scorecards fair and repeatable.
Segmentation also matters. OTIF should be analyzed by supplier, SKU, region, customer, or carrier to reveal where performance issues truly originate.
Definition Example | Impact on OTIF Comparability |
|---|---|
"On time" = exact date | Strict standard, lower OTIF % |
"On time" = delivery window | More forgiving, higher OTIF % |
"In full" by line-item | Highlights partial-fill issues |
"In full" by shipment | Masks item-level shortages |
Agreed definitions turn OTIF from a debate into a reliable management tool.
Build a Minimal Data Set Outside the ERP
When ERP data is missing shipment or confirmation details, constructing a lean external dataset enables continued tracking. The essential fields include:
Supplier
SKU or Item Code
Order Quantity
Shipped Quantity
Requested Date
Ship Date
Delivery Window
Delivery Confirm Source
Where ERP data is thin, draw from alternative systems: EDI acknowledgements for ship notices, carrier and TMS feeds for actual delivery events, WMS picks for fulfillment confirmations, and even email or manual logs for priority orders.
Field | Typical Value | Source Example |
|---|---|---|
Supplier | Alpha Plastics Ltd. | ERP Vendor Master |
SKU | 100245 | ERP / WMS |
Requested Date | 2024-06-05 | ERP Order Header |
Delivery Confirm Source | FedEx POD Event | TMS |
This lightweight dataset can live in Excel, Google Sheets, or a data lake while larger integrations are developed. Platforms like Leverage AI can simplify this step by automatically connecting these data sources and flagging incomplete records for review.
Define Clear OTIF Rules and Measurement Criteria
Establish unambiguous rules for when an order counts as on time, in full, and therefore OTIF-compliant. For example:
OnTimeFlag: TRUE if actual delivery date falls within a plus or minus 2-day window of the requested date.
InFullFlag: TRUE if shipped quantity is greater than or equal to ordered quantity minus defined tolerance (e.g., 2%).
OTIF_Flag: TRUE when both flags are TRUE.
Document exceptions such as early shipments or partial deliveries and clarify penalties linked to each scenario. Turning these definitions into code or logic reduces disputes and ensures supplier scorecards remain consistent across reporting periods.
Transform Data and Flag OTIF Status
Once your primary dataset exists, transform it into actionable metrics. Tools like Power Query, Python Pandas, or AI-assisted logic generation from Leverage AI can assign OTIF flags automatically.
A simple sequence might look like this:
Import raw order and shipment data.
Apply OnTimeFlag and InFullFlag logic.
Generate OTIF_Flag column.
Load the transformed file into Power BI or another dashboard tool.
Automate data refreshes weekly or daily.
Automation at this stage ensures that as new shipment data arrives, dashboards stay current without manual intervention.
Create Automated Supplier Performance Dashboards
Effective dashboards bring OTIF data to life. Your supplier performance dashboard should display:
Overall OTIF % and trend over time
Supplier- or region-level scorecards
Missed order and exception lists
Visualization of root causes (e.g., late dispatch vs partial fill)
Automation enhances value. Set up weekly exception alerts, scheduled refreshes, and predictive analytics to anticipate future misses. Many modern platforms, including Leverage AI, Power BI, Tableau, and specialized supply-chain visibility tools, provide these capabilities out of the box.
Dashboard Feature | Value |
|---|---|
OTIF % Trend | Tracks reliability over time |
Exception List | Pinpoints improvement opportunities |
Predictive OTIF | Anticipates future misses |
Automated Alerts | Accelerates response and accountability |
Leverage AI excels here by connecting disparate sources and applying predictive insights without requiring heavy integration work.
Close the Feedback Loop with Suppliers
Tracking performance means little without closing the loop. Share standardized scorecards with suppliers regularly, showing both achievements and failures. Transparency builds trust, while data-backed discussions identify root causes faster.
For recurring misses, conduct joint analyses to uncover systemic issues, such as capacity constraints, transportation delays, or inaccurate order forecasts. Align on corrective actions, adjust purchase agreements if needed, and recognize consistent top performers. Sharing clear OTIF metrics transforms supplier relationships from transactional to collaborative.
Practical Shortcuts for Incomplete ERP Data
Even without full ERP integration, several practical tactics can keep visibility strong:
Shortcut | When to Use | Tradeoff |
|---|---|---|
EDI shipment confirmations | When EDI feeds exist | May miss small suppliers |
TMS/carrier data | For delivery confirmation | Lacks SKU detail |
WMS picks | For fulfillment confirmation | Pre-shipment only |
Manual PO update | For strategic suppliers | Labor-intensive |
Power BI + Excel pipeline | Interim visibility | Requires maintenance |
Over time, plan to automate the highest-value sources, especially EDI and carrier event feeds, for scalable OTIF accuracy. Leverage AI can help prioritize and automate these high-value data sources while maintaining continuity in reporting.
Operational Best Practices for OTIF Tracking
To sustain high-quality OTIF visibility, embed these operational routines:
Conduct routine data audits and cleanse master data monthly.
Treat OTIF as a daily operational KPI, not just an end-of-quarter review.
Automate alerts for missed or at-risk deliveries.
Enrich dashboards with predictive data such as carrier ETAs or weather signals.
Review and update OTIF measurement rules yearly.
Quick OTIF Maturity Checklist
Consistent definitions applied across all suppliers
External data sources supplement ERP
Automated flag logic and refresh cycles
Supplier feedback process established
Predictive signals actively monitored
Frequently asked questions
What is the formula for calculating OTIF?
The OTIF formula is (orders delivered On-Time and In-Full divided by total orders) x 100, counting only deliveries that meet both conditions.
How can I track OTIF when ERP data is missing or delayed?
Tools like Leverage AI help combine partial ERP data with external confirmations for consistent OTIF tracking, even when feeds are delayed.
What alternative data sources can supplement ERP for OTIF tracking?
Carrier events, warehouse picks, EDI transaction sets, and manual confirmations can supplement missing ERP details in Leverage AI workflows.
Which KPIs complement OTIF to improve supplier performance visibility?
Lead time adherence, fill rate, defect rate, and price variance provide a fuller picture of supplier reliability.
How do automated dashboards improve OTIF management?
They consolidate data in real time, flag exceptions automatically, and give teams a single source of truth for proactive supplier management.
About Michael Ciavarella
Michael Vincent Ciavarella is a Director of Operations focused on modernizing old-school industries like logistics and manufacturing. He writes about simplifying messy workflows, introducing practical technology, and making change actually stick with the teams who use it every day.
