Lot tracking software records which batch (lot) or serial number a product arrived with, where it sits in the warehouse, which finished product it went into and which customer received it. Its purpose is to answer one question within minutes: "This batch has a problem, where did it go and what was it made of?"
Who needs lot tracking?
In food, cosmetics, chemicals, medical products, spare parts and electronics, customers, auditors or suppliers ask for traceability. A stock program often keeps only a quantity: "400 boxes in stock". Lot tracking knows which three batches those 400 boxes came from, which one expires first and which one is in quarantine.
- Lot at receipt: supplier lot number, production and expiry date, certificate of analysis.
- Lot level stock: different batches of the same item are kept on separate lines.
- Consumption in production: which raw material lot, and how much, went into a work order.
- Lot on shipment: which batch every delivery note line came from.
- Quarantine and hold: a suspicious lot is closed to sales and production.
Lot or serial number?
A lot is a group of products made under the same conditions: one tank of paint, one day of production. A serial number belongs to a single item: one device, one engine. The software can carry both with the same movement logic. The difference is that a serialized item always has a quantity of 1 and the same number cannot be in two places at once.
Lot data cannot be completed later. A batch that was not scanned or typed at receipt is the missing link on recall day. That is why lot controlled items cannot be received or shipped with an empty lot field.
How do forward and backward tracing work?
Backward tracing starts from a finished product lot and finds which raw material lots it was made from. Forward tracing starts from a raw material lot and finds every product made from it and the customers who received them. Both rely on the same data: every movement line carries a lot and every work order links "consumed lots" to the "produced lot". The example below shows forward tracing.
type Movement = { lot: string; from: string; to: string; qty: number };
// from/to: supplier, warehouse, work order or customer code
// Forward trace: where did this lot (and everything made from it) go?
function traceForward(lot: string, moves: Movement[], made: Map<string, string[]>): string[] {
const customers = new Set<string>();
const queue = [lot];
const seen = new Set<string>();
while (queue.length > 0) {
const current = queue.shift()!;
if (seen.has(current)) continue;
seen.add(current);
for (const m of moves) {
if (m.lot === current && m.to.startsWith('CUST-')) customers.add(m.to);
}
// lots produced by consuming this lot are followed too
for (const child of made.get(current) ?? []) queue.push(child);
}
return [...customers];
}Which lot should go out first?
For items with an expiry date the rule is usually "first expired, first out" (FEFO), for others "first in, first out" (FIFO). The software suggests the pick list by that rule. If the picker scans a different lot it is not blocked, but the deviation is recorded with a reason. This way an old batch does not silently stay on the shelf. For the picking side see our warehouse management system (WMS) article.
What happens on recall day?
- The suspicious lot is put into quarantine with one click, sales and production stop in all warehouses.
- Forward tracing lists the affected finished lots and customers with quantities.
- Quantity still in stock and quantity already shipped are reported separately.
- The event is linked to a corrective action record where root cause and closure are tracked.
Our corrective action and nonconformity tracking article covers the corrective action process, and our production tracking software (MRP) article covers work orders and consumption. Recall deadlines and reporting duties depend on the sector and regulations. This article is not legal advice.
Off the shelf stock software or custom?
If writing a lot at receipt and shipment is enough, many off the shelf programs will do. If you need lot transformation in production, quarantine across several warehouses, mandatory barcode scanning and customer level traceability reports, you usually need custom software or a custom module for your current system. To decide, read stock tracking software or custom development.
Good lot tracking software makes the lot mandatory at receipt, records every movement with its lot, links consumed and produced lots in the work order and delivers the affected customer list within minutes during a recall. We can design your traceability needs together within our corporate solutions service. For a short brief, request a quote.