Lot traceability: how to rehearse a product withdrawal

What actually identifies a lot?

An isolated number can repeat across products or suppliers. Define the combination identifying a lot and retain the supplier’s external reference alongside the internal one. Include receipts, production consumption, repacking, returns and shipments. If a required lot field accepts “various,” it will not produce useful traceability. Check that product and unit accompany the identifier in every exported report, including records shared between departments.

Odoo distinguishes a lot grouping multiple units from a serial identifying one unit, and documents origin, storage and recipient reports. It is a product reference rather than evidence that your catalog is complete. Read the tracking documentation. A report can reconstruct only the links actually recorded.

Why trace backward and forward?

Backward tracing answers which inputs formed a finished lot. Forward tracing answers where an input was consumed, which products resulted and who received them. GestionAPPCC describes links between supplier, material, lot, production and finished product. Published traceability features. Turn that chain into a demonstration question: request concrete documents and identify missing links rather than assuming one screen proves the entire journey.

Worked example: one input feeds two finished lots

Flagging M01 as suspect in this exercise identifies F01 and F02: 90 kg consumed equals 180 packs of 0.5 kg. Forty packs remain at site and 140 were delivered. Retain the remaining 10 kg of M01 as well. An M02 lot with no documented link should not automatically be included, even if it is the same product. If F02’s consumption link is missing, show uncertainty instead of claiming a complete list.

What counts as recovery and what remains outstanding?

Simulate A returning 15 F01 packs through R15. There are now 55 packs at site, held for review, and 125 outside: A has 55, B has 30 and C has 40. Repeating R15 must not change these quantities. Separately record an identified destination, prepared notice, received response and confirmed physical return. No notices are sent here; the drill uses fictional records. A verbal promise to “check” is not proof of locating or recovering goods.

What must the drill demonstrate?

• Normal: starting from M01 finds F01/F02, three shipments and the original 40 packs at site, with documents and reconciled units.
• Exception: removing a consumption link creates an identified warning or review; the report must not claim unsupported complete coverage.
• Retry: R15 retains lot, original shipment and quantity; the same return produces one receipt of 15.
• Separation: a similar lot code from a different origin remains excluded until evidence establishes a relationship.
• Closure: each outstanding quantity retains a responsible person and next action; release or disposal requires a recorded decision rather than a dashboard color change.

How do you test your own business records?

Download the traceability drill worksheet and replace the example with a receipt, two production orders and their shipments, hiding personal details. First verify that purchasing, production and distribution share matching identifiers. Also review barcode receiving and expiry and FEFO. For agricultural or food operations, the scope of agribusiness software should specify these links and exceptions; this guide proves neither regulatory compliance nor actual recovery.