How one barcode mistake caused 14 products to be sent instead of 1
Quick answer
This article gives UK SMEs a practical way to understand the operational issue, spot where data or process risk is building, and decide what to fix first before investing more time or budget.
Barcode and unit-of-measure mistakes can make ERP stock look correct while the warehouse picks the wrong quantity. In one Infor LN example, the same barcode on outer and inner packaging meant an order for 1 could become a pick of 14.
Some master data problems look small until they reach the warehouse floor.
In this case, products were being handled across different units: pallets, boxes and eaches. The supplier had created the same barcode for the outer packaging and the inner product.
That meant one scan could represent different physical quantities depending on where it happened. The result was orders for 1 turning into 14 products being picked and sent.
The ERP was only as good as the barcode rules behind it
The issue was in Infor LN, but the ERP was not the root cause. The real problem was supplier packaging and barcode control.
The business ordered wrong quantities, picked wrong quantities and created stock errors. Customers complained. The company lost thousands of pounds by sending far more product than had been purchased.
A barcode is master data. If it is wrong, every scan can confidently create the wrong transaction.
The fix was practical, not theoretical
The fix required separate barcodes for outer and inner packaging, plus supplier packaging changes so the warehouse could not confuse a box with an each.
That kind of issue belongs in a master data ownership process. Someone has to own unit of measure, barcode rules, packaging logic and the relationship between supplier labels and ERP item setup.
The takeaway
Unit-of-measure and barcode fields look like operational detail, but they control stock accuracy, picking accuracy, purchasing decisions, customer delivery and finance trust.
Before ERP migration or warehouse process changes, these fields need to be tested in the real operational flow, not only reviewed in a spreadsheet.
Worried about master data before ERP change?
Digital Adaption helps SMEs find barcode, unit-of-measure and item-master risks before they damage stock accuracy or cutover confidence.
Download the ownership matrixMatty Hatton is the founder of Digital Adaption, an ERP and data consultancy based on the Wirral. He has spent 15 years delivering ERP transformations for manufacturers, including leading the data migration on a GBP 4.5m consolidation of four legacy systems onto a single Infor LN cloud instance for a 220-user group. He holds an MSc in Digital Transformation and IT Strategy from Manchester Metropolitan University and is Microsoft PL-200 certified.
Start with a 30-minute data risk call