Reconcile ingredient quantities by product, lot, location and disposition, then validate the associated dates against source evidence. Preserve supplier lot references separately where needed. Do not replace missing dates with a convenient default; identify the records requiring review and agree how they may be used before opening production in the new system.
Understand the decision
A food producer’s spreadsheet contains several deliveries of the same ingredient, each with different lot and date information. Some bags are held and others are partly consumed. The migration must retain these differences even when the total quantity for the ingredient matches the warehouse count.
Work through the requirements
- Count each lot and disposition separately.
- Compare dates with supplier and receiving records.
- Resolve missing or conflicting date evidence.
| Record or decision | Why it matters |
|---|---|
| Lot opening file | Separate quantities by identity. |
| Date evidence | Support recorded shelf-life information. |
| Hold reconciliation | Preserve restricted stock status. |
What would a passing test show?
Use these hypothetical cases in a demonstration. Mark the evidence you have reviewed, then download the checklist. Selections stay in this tab.
Watch for this failure
A total-by-product import can erase the distinctions needed for material selection and investigation. Reconcile at the lot level, and let the responsible business owner resolve missing dates rather than manufacturing a clean-looking opening file.
Continue the evaluation
This example defines what to verify, rather than promising a particular Odoo feature. Keep a record of the demonstrated result, configuration, unresolved gaps and person who accepts it.
Read the wider implementation guideBring your workflow to the conversation.
Discuss requirements for Food manufacturing in a business needs review. Start with your current systems, the handoff that fails and the result you need to prove.
Sources & scope
The linked product documentation is a starting point for validating your chosen version, edition, apps and hosting. The scenarios and acceptance criteria are editorial planning guidance, not customer case studies or a guarantee of built-in functionality. See how this library is prepared.
Odoo 19: manufacturing product configuration ↗Odoo 19: lot numbers ↗Odoo 19: expiration dates ↗Odoo 19: quality control points ↗