Skip to main content
ERP and SAP live line count reconciliation
Engineering Field Note 03 • ERP & Sales InsightsIntegration: SAP Business One / S/4HANA & Custom Executive BI • Granular IT Kenya

Reconciling Live Conveyor Counts with SAP Invoicing & Route Sales

Most ERPs only know what clerks type in at the end of the day. Here is how we connected live factory sensor counts directly to SAP and delivery van route sales—closing a 1.6% dispatch variance and giving directors live margin visibility.

SAP / ERP Executive Reconciliation View

Physical Sensor Count vs. Billed ERP Invoices (Shift 02)

● Live Telemetry Synced
Line 1 • 500ml Beverage 24-Pack
28,450 Cases
SAP Billed: 28,448 • Variance: 0.01%
Line 2 • 1L Juice Cartons
12,840 Units
SAP Billed: 12,840 • Variance: 0.00%
Bay 3 • 5L Bulk Containers
-42 Unbilled Units
Alert Sent: Loaded on Van KDQ-412P without SAP DN
01 / The Blind Spot in Traditional ERPs

Why SAP & Dynamics Can't See Unrecorded Shrinkage

Even companies running world-class ERP systems like SAP Business One, SAP S/4HANA, or Microsoft Dynamics 365 suffer from a major blind spot: **the ERP only knows what human clerks type into it.**

If 30,000 units are actually produced on the line, but only 29,400 are keyed into the warehouse receipt or delivery note, those 600 units vanish from the books without triggering a single ERP warning. Meanwhile, executives wait until month-end stock-takes to discover margin leakage.

02 / How We Connected the Floor to the Boardroom

Automated Goods Receipt, Dispatch Verification & Sales BI

Direct SAP Goods Receipt

Verified conveyor counts push directly into SAP Service Layer / OData APIs at the end of every batch—eliminating manual data-entry delays.

Instant Dispatch Variance Alerts

If the loading bay camera counts more crates entering a truck than the SAP Delivery Note authorizes, security and finance receive an instant alert.

Route & Van Profitability

Directors see real-time sell-through, return rates, and net margin by distributor, delivery route, and salesperson on their phone.

True Cost-Per-Unit Tracking

Combines raw material input weights, line downtime, and solar/grid kWh power consumed per shift to compute exact unit manufacturing cost.

03 / Business Impact

Zero End-of-Month Surprises

  • Eliminated Unbilled Dispatch Leakage: Caught loading discrepancies at the gate before trucks left the yard.
  • Live Production-to-Demand Alignment: Sales managers see live finished-goods inventory by SKU before committing to distributor orders.
Integration Stack
Supported ERPs
SAP B1 / S/4HANA, Microsoft Dynamics 365, Odoo, Custom SQL
Telemetry Transport
MQTT over TLS → REST / OData Service Layer
Executive Reporting
Live Web Dashboard + Daily WhatsApp Executive Brief

Want to Connect Your Floor to SAP or Your ERP?

Talk to our Forward-Deployed Engineers about integrating live production counts and sales analytics with your existing ERP.

Discuss ERP Integration on WhatsAppNext: Field Note 04 (Smart Homes & Perimeter AI)