Skip to main content
Orion Five Engineering

10 Jalan Kilang #04-05, Singapore 159410
+65 6100 5505

← All insights

Systems integration

Why your WMS and your ERP probably disagree

A warehouse management system (WMS) rarely closes the gap it was bought to close. The gap usually sits at the handoff into the enterprise resource planning (ERP) system, where someone still reconciles the two systems by hand. Most of the real cost of a warehouse project lies in that reconciliation step.

Veronica Loh · 2026-06-11 · 4 min read

Two machined gears interlocking, one anodised red, joined at their meshing point by a single steel pin.

Executive summary

82%

of warehouse associates say better inventory tools are needed, per Zebra's 2023 Warehousing Vision Study

69%

of decision-makers had automated workflows or planned to by 2024, same study

Key conclusions

  • Most warehouse automation projects are scoped as a WMS purchase. The real cost sits at the handoff into the ERP, where someone still reconciles the two systems by hand.
  • The handoff causes three problems: a stock figure that is only as current as the last manual sync, a duplicate entry point and an audit trail that differs between the two systems.
  • The fix is one shared record at the boundary between the two systems, updated by each scan and checked at the interface rather than at month end.

Most warehouse automation projects are scoped as a WMS purchase, and most deliver less than that scope promised. The cause is rarely the software. It is the handoff between the WMS and the ERP beside it. Someone still enters the same stock movement twice, because nobody configured the two systems to agree.

The handoff does not appear in a sales demo, but it is expensive in production. One system shows a correct stock count while the other shows an out-of-date one. Staff raise purchase orders against a number nobody has checked since the morning shift. Over time, maintaining the reconciliation spreadsheet becomes one person's full-time job.

Manual reconciliation creates four costs

  • A duplicate entry point. Every movement is entered once for operations and once for finance, and the two records drift apart as soon as either one lags.
  • A stock figure that is only as current as the last manual sync. In most warehouses, that sync happens once a shift at best.
  • An audit trail held in two places that do not match each other. A stocktake discrepancy exposes this first.
  • A headcount cost that rises with transaction volume, whatever the reconciliation is protecting.

Industry data shows the same problem from both sides of the warehouse

Grey storage bins on white shelving, one red bin pulled half out of its slot.

Zebra's 2023 Warehousing Vision Study interviewed more than 1,400 warehouse decision-makers and associates. Azure Knowledge Corporation ran the interviews in March and April that year. The study found that 82 percent of associates and 76 percent of decision-makers say their facility needs better inventory management tools to get accuracy and availability right. Sixty-nine percent of decision-makers said they had already automated workflows or planned to do so by 2024.

None of these figures describes the WMS on its own. They describe the same problem from two sides of the same building. The record of what is in the warehouse and the record the business runs on do not update at the same time. The inaccuracy develops in the interval between the two updates.

Zebra's 2023 Warehousing Vision Study

Associates: need better inventory tools
82%
Decision-makers: need better inventory tools
76%
Decision-makers: automated, or planning to by 2024
69%
Interviews with more than 1,400 warehouse decision-makers and associates, March to April 2023.

A single live record removes the reconciliation step

A white handheld scanner beside plain grey boxes, its scan window glowing red.

One of our own logistics deployments replaced exactly this manual step. A government client's asset and inventory system tags stock as soon as it enters, whether at manufacturing, distribution or receipt. Staff identify items by scanning them. A real-time dashboard shows managers what is currently on loan, replacing a periodic physical count.

In that deployment, the reconciliation step was removed entirely, because there was one live record instead of two records that took turns being current. The same approach works in general: set one boundary where the two systems share a record, and check it at the interface rather than at month end.

Four questions to answer before buying either system

  1. Whether the WMS and the ERP will share one identifier for each SKU and each location, or whether mapping between two sets of codes is left to whoever configures the integration later.
  2. Whether a stock movement updates both systems in the same transaction, or whether one is authoritative and the other is a nightly copy of it.
  3. Who reconciles today, how many hours a week it takes them, and whether that time was costed into the last automation business case.
  4. Whether the integration is tested before go-live against a real stocktake discrepancy as well as a clean demo dataset.

Related insights


All insights

Related service


Book a scoping call