Skip to content
Incoming Inspection and Traceability | Part 6 of 6

Lots, Serial Numbers and a Trace in Four Hours

How the chain from a supplier lot to a serial number is built stage by stage, how deep it needs to go, and how a timed drill shows where it breaks.

Traceability is not a database. It is an unbroken series of links, each one made by a person or a scanner at a moment when making it was still possible. Buy a system before the links exist and you get an expensive record of the stages that already worked.

Stage What is recorded How the link is made
Goods receipt Supplier lot, quantity, receipt number Label read at the counter
Storage Lot per stock location, first in first out Pallet label, location record
Issue to production Lot issued to the production order Scan at the issue
Production stage Order, station, date, lot consumed Booking at the stage
Final assembly Serial number with the lots inside it Serial plate, record against the order
Shipment Serial numbers per delivery, customer, date Delivery note, shipping record

The chain is only as good as its weakest stage. Before buying anything, walk it and find where the lot identity is lost. It is almost always a bin at a workstation that is topped up from two boxes, so that nobody can say afterward which lot the part in the product came from.

How deep is deep enough

Full genealogy of every part at every stage is rarely worth it outside regulated products. Decide the depth part by part, with the same three factors as the inspection scope.

Lot to lot is enough for standard parts in large quantities. Lot to order costs one scan at the issue and covers most purchased parts. Lot to serial number is for critical parts, safety parts and long warranties.

In the valve block plant, 11 of the 34 purchased parts in a block are traced to the serial number and the other 23 lot to order, written next to the risk class.

The drill

You will be asked for a trace on a bad day, by someone who needs the answer in hours. Practice on a good day.

The plant picked supplier lot S-7742 of a sealing kit: 2,400 pieces, three goods receipts, 14 production orders, 1,180 valve blocks, 23 customers over nine weeks. The agreed target was four hours.

Step What is asked Before After
Find the lot Which goods receipts carried it? 2.5 h 15 min
Find the use Which production orders consumed it? 9 h 40 min
Find the product Which serial numbers contain it? 11 h 50 min
Find the customer Who received them, and when? 6 h 30 min
Write the answer One signed list, with the gaps named 2.5 h 15 min
Total 31 h 2.5 h

The first drill took 31 hours over four days and left two of the eleven traced parts open. The second, nine months later, took two and a half hours and was complete.

How to run one

Pick a real lot the day before and do not prepare it. Give the team only what a caller would give: a part number, a supplier lot, a date. Start a clock and write the time at every step, waiting for a report or a key included. Stop at the target time whether the answer is complete or not, because the gap is the result.

Then write one signed page: the affected serial numbers, the customers, the dates, the quantity still in your own stock, and the parts you cannot account for. That last line is what makes the page credible. Give every gap an owner and a date.

One field makes all of it possible, and it has to be there from the start: the supplier lot number, recorded at every goods receipt, class C included. It costs four seconds, and it cannot be added backward.

Newsletter

One Lean idea.
Every two weeks.