Most integration arguments in this domain are really disputes about which system
is the record for a given fact.
system system of record for does not own
------ ----------------------------------------- ----------------------------------
ERP financial inventory value, purchase and bin locations, pick tasks, routes,
sales orders, supplier and customer real-time stock movement
master data, costing
OMS the customer promise, order state, where stock physically sits,
allocation across nodes, sourcing rules how it is picked
WMS bin-level stock, tasks, labour, handling the customer relationship,
units, receipts, despatch confirmations freight rates, financial value
TMS loads, routes, carrier rates, tendering, bin-level stock, order promises,
freight audit and settlement inventory value
Read it as a set of boundaries and the common failures become obvious. The ERP
holds an inventory value and the WMS holds an inventory position, and they
will not agree at any given instant because one is updated on a financial event
and the other on a physical one. Trying to make them agree continuously is the
integration project that never finishes; agreeing a reconciliation cadence and a
tolerance is the answer.
The OMS boundary is the one most often missing altogether. Without it, promise
logic ends up split between the web front end and the ERP, and multi-node
sourcing — deciding which warehouse or store fulfils an order — has nowhere to
live. That decision needs stock positions from every node, carrier transit times
from the TMS and margin rules from the ERP, which is precisely why it deserves
its own system rather than a query in a checkout controller.
The TMS boundary matters for cost. Freight audit — checking that the carrier
invoiced what it quoted for the service it actually delivered — recovers a few
per cent of freight spend and requires the rate, the tender, the actual
execution and the invoice in one place. Scatter those and nobody ever checks.
The interview point is that "we will integrate the WMS and the ERP" is not a
design. Naming which facts flow in which direction, at what latency, and what
happens when they disagree is the design, and the disagreement case is the one
candidates skip.