Skip to main content
Bonsai Software
All field notes
Field Note7 September 20266 min read

Serial number registration in custom production software: three lessons learned

Serial number registration in custom production software tends to fail late in most companies: not during the build, but the moment a field technician opens a machine and finds an empty history. Traceability looks correct on paper, but in practice it lags behind reality. Three lessons we consistently encounter in the manufacturing industry.

By Yeslin Beljaars

Lesson 1: the serial number is recorded too late

In most production environments, a finished product only receives a serial number when it leaves the building: at final inspection, at shipment, or at invoicing. Until that point, the product exists as a production order, a WIP booking, or an internal code. That sounds reasonable, but it means that everything that happened during production, processing steps, material changes, inspections, is never linked to that serial number. When a warranty claim comes in or a recall is needed, someone has to trace back which order used which material on which date. That is sometimes possible, but it takes time you do not have. The solution is not additional reports after the fact, but a change in when the serial number is created: when the production order is opened, not when it is closed.

Lesson 2: the link between production WIP and the service module is missing

This is the pain point most directly felt by field service teams. A technician drives to a customer, opens the service ticket, and sees: serial number, warranty date, contract type. What he does not see is which operations were performed during production, which parts were installed, and whether any deviations were noted at final inspection. That information lives in the production system, but the service module speaks a different language. The two systems were never connected, or the connection was built via an export that runs every night and is therefore always a day old. The result: the technician calls the back office, who calls production, and in the meantime the machine is down. The link between WIP registration and service history is not a nice-to-have; it is the core of what traceability means in practice. As long as that link is missing, serial number registration is an administrative exercise, not an operational tool.

Lesson 3: manual entry pollutes the data model with duplicates

In many environments, serial numbers are entered in multiple places: in the production order, in the quality system, at shipment, and again in the ERP at invoicing. Every entry is an opportunity for a typing error. An extra hyphen, a capital letter that becomes lowercase, a zero that becomes an O: the system then creates a new object. After a year you have hundreds of serial numbers that are technically unique but are in reality duplicates of existing records. Searches return no results, links do not work, and reports are inaccurate. The data model is corrupted, and cleaning it up typically costs more time than the original system ever saved. The structural solution is to scan at the moment of registration, once, at the location where the product physically is. Not to re-enter it manually in a different system later.

When does serial number registration in production software run smoothly?

The difference lies in the position of the serial number within the data model. When the serial number is a first-class object, it means: the production order is created with the serial number as the primary key, not as an attribute filled in later. Every operation, every material entry, every inspection result is linked directly to that serial number. The service module reads from the same source; there is no export, no translation layer, and no delay. Scanning replaces manual entry, making duplicates structurally impossible. This requires a deliberate design decision, not an extra field in an existing package. Standard ERP packages often offer serial number management as a module, but the architecture is rarely built with the production order as the starting point. In custom production software, that choice can be made, provided it is made early enough. When we rebuild a system for a manufacturing company, this is one of the first questions we put on the table: do we treat the serial number as an attachment to the order, or as the order itself? The answer determines how traceability, field service, and data quality will behave for years to come.

Seeing this in your own operations?

Book a call

Frequently asked questions

What is serial number registration in production software?

Serial number registration in production software is the recording of a unique identification number for each individual product, linked to the production order, processing steps, materials, and inspections. This allows you to see exactly what happened to each product, from production through to service.

Why does traceability with serial numbers break down in the manufacturing industry?

Usually because the serial number is created too late in the process, only at shipment or invoicing, and is not included as a central key in the data model. Everything that happened before that point can no longer be linked to the serial number.

How do you prevent duplicates in serial number registration?

By scanning the serial number once on the shop floor, directly when the production order is opened, and using that value as the primary key in all connected systems. Manual re-entry across multiple systems is the primary cause of duplicates.

When is custom production software better than a standard package for serial number management?

When you want the serial number to be a first-class object in your data model, directly linked to WIP, field service, and quality registration. Standard packages often offer serial number management as a module, but the architecture is rarely built that way. In custom software, that choice can be built in from the start.