Skip to Content

Odoo 18 lot traceability pilot

English · Slovenščina

The pilot covers one company and one warehouse. It uses a single quarantine location for purchased steel bars and one manufacturing order per source heat. Record the actual lot, quantity, and package at each stock operation when material is packed, from supplier receipt through shipment and returns. Start the pilot products with empty stock and new lot identifiers. Set aside legacy stock until it has an agreed opening-balance and provenance procedure.

Addon set

Source Technical names Purpose
OCB 18.0 stock, purchase_stock Lots, package contents, inventory moves, and PO-backed receipts
OCB 18.0 mrp, sale_management, sale_stock, sale_mrp Manufacturing genealogy and sales deliveries
OCA manufacture 18.0 quality_control_oca, quality_control_stock_oca, quality_control_mrp_oca Receipt inspections per lot and optional inspections after manufacturing
OCA stock-logistics-workflow 18.0 stock_restrict_lot, stock_picking_return_lot Lot-aware returns linked to the original transfer
PMIVerse operations 18.0 pmis_mrp Work-center navigation
PMIVerse pmis-beta 18.0 pmis_lot_traceability Receipt evidence, quarantine and release checks, one heat per controlled component product per batch, and posted lot and package history

Put these OCB, OCA, and PMIVerse repositories on the instance's addons path. Install pmis_lot_traceability in the pilot database. Odoo resolves its direct and transitive manifest dependencies. Select one copy of each technical addon on the addons path.

Optional OCA additions depend on the customer workflow. Use purchase_lot when purchasing a specific lot in advance, sale_order_lot_selection when sales promises a specific lot, and account_invoice_production_lot when the invoice needs lot details per line. Keep the stock delivery as the record of the lot and package actually shipped.

Configure the warehouse

  1. Enable Lots & Serial Numbers, Storage Locations, Packages, and Display Lots & Serial Numbers on Delivery Slips in Inventory settings.
  2. Create a company-specific internal location WH/Quarantine directly under the warehouse view location, alongside WH/Stock. Mark it Supplier Lot Quarantine. Use one actual holding location with no child locations. Keep it outside the source hierarchy used to reserve components and deliveries.
  3. Create a dedicated Pilot Supplier Receipts operation of type Receipt with quarantine as its destination. Select it in Deliver To on pilot POs. Point its return operation to Delivery Orders for supplier returns. Keep the warehouse's usual receipts operation as the return type for customer deliveries, with the intended customer-return location as its destination. Allow creating lots on supplier receipts and using existing lots for partial receipts of a verified matching heat. For internal transfers and deliveries, use existing lots. Create an Internal Transfer operation from quarantine to stock and reserve manually. Use internal transfers with identical source and destination locations for in-place packaging. Leave automatic push rules off the holding location.
  4. Create steel bars as a stock-tracked purchased good with tracking By Lots. Enable Controlled Supplier Material. Create the shaft as a stock-tracked sold good, also By Lots, and create its BoM with the steel component. Use metres (m) for steel bars in purchasing, inventory, and the BoM. Count finished shafts in pieces. Define a material-specific conversion before buying by weight and consuming by length. Use manual MOs for the pilot.
  5. In Quality Control, create a nonempty receipt test for certificate matching and the agreed material checks. Use the trigger for the selected receipt operation, enable Inspection Per Lot, and assign the test on the pilot product with timing After and a responsible quality user. Use the standard manufacturing inspection trigger if an output inspection record is required. Outbound quality blocking needs its own release rule.
  6. Assign Inventory User to operators. Assign Quality Control Manager and Inventory User to the person authorizing release. Keep inventory adjustment, product configuration, and location configuration with the inventory lead. Enable Restrict lot on picking return line if returns must use the lot from the original delivery. Configure the sales invoicing policy to delivered quantities and enable Display Lots & Serial Numbers on Invoices if required for the pilot's printed invoice.

Run the pilot

  • Confirm the PO. Enter the Supplier Delivery Note for the physical receipt. Record each heat and actual received quantity in detailed operations and set the Destination Package for packed goods, and validate into quarantine. Use the lot reference or an agreed qualified lot name when supplier heat codes could collide. Record a distinct slip reference on a backorder for the next physical shipment. Receive steel bars
  • Open the received lots, attach a mill certificate to each, and complete the generated inspections. The quality manager validates a transfer containing only released lots. A hold is released physically by moving its stock to WH/Stock. For the same heat received more than once into quarantine, all recorded receipt inspections for that heat must pass. Keep suspect physical material segregated and use a linked supplier return or scrap for rejected material. The manager authorizes either disposition. To pack or repack held material, keep both ends of the transfer at the same quarantine location. On the editable transfer, select stock from the existing package under Pick From and set Destination Package for repacking. Use Unpack for a whole package or leave Destination Package empty on a partial unpacking transfer. The lot remains on hold. When releasing packed stock, use Pick From to select stock from its package and set Destination Package if it stays packed. Inspect and release each heat
  • Record the actual input lots and amounts on the MO. Split the MO when a controlled heat changes and use a new finished lot on each MO or backorder. Generate the lot on the MO, or select a newly created lot in the MO's company. Record remnants and scrap as traceable stock movements using the original input lot. Define how the shop records usable bar length before using remnants in production. For packed components, use Pick From to select stock from the actual package on each consumption line. Manufacture and assign a finished lot
  • If you pack finished goods before shipment, post an internal transfer at the same stock location. On delivery, use Pick From to select stock from the existing package and set the actual Destination Package. Use Put in Pack for a new shipping package. Check the lot and quantity before validating. Use one finished lot per package as a pilot operating rule. Pack, deliver, and invoice
  • Correct a posted shipment with a linked return and a new delivery. Record the actual Destination Package on the return. When repacking returned stock, use Pick From for the existing package and set the new Destination Package before posting. Post returns, scrap, and repacking
  • Open Package History and compare Source Package and Destination Package on posted rows, even after a package is emptied. Use the finished lot's Traceability to reach the supplier heat and the input lot's Customer Deliveries to find affected shipments. Trace a package back to its supplier · Trace a heat forward to customers

Customer-specific product identifiers, VDA 4994 labels and SSCC assignment, scanners, automatic finished-goods quality release, alternate material substitutions, and traceability of individual pieces from mixed heats need separate configuration or implementation if required. The addon treats inventory adjustments and configuration changes as administrator-controlled operations. It applies the supplier release check when material leaves quarantine. Recalls of material already released require moving affected stock back into quarantine and following the recall procedure.

Acceptance tests

Use a single PO for 20 m of steel bars. Receive 10 m each of HEAT-A and HEAT-B into separate inbound packages. Make two shafts per finished lot (FG-A and FG-B), consuming 4 m of the corresponding heat per lot. Ship one shaft from each finished lot on one sales order in PACK-A and PACK-B.

Scenario Pass condition
Backward recall Read Destination Package on the validated delivery, then open Package History for PACK-A and match the posted shipment to FG-A. Open the finished lot's Traceability and follow production and the release transfer to the PO, supplier slip, and certificate for HEAT-A. HEAT-B is absent from that production's consumed lines.
Forward recall From HEAT-B, follow where-used production to FG-B or open the input lot's Customer Deliveries. Find the validated delivery to the correct customer and use detailed operations to identify PACK-B, excluding PACK-A from the affected contents. 6 m of HEAT-B remain. Repeat after shipping the second shaft from FG-B to another customer.
Supplier receipt and release Try a missing slip, an ordinary stock destination, a missing certificate, an incomplete or failed result, and release by a warehouse operator. Each action is blocked. A manager can release the passing lot and leave the other on hold. An attempt to consume the held lot from usable stock fails.
Quarantine packaging Repack 4 m of one heat into a new package and unpack the remaining 6 m in place. Both quantities remain in quarantine. The emptied inbound package still shows the 10 m receipt, 4 m repack, and 6 m unpack in Package History. Attempting to release either quantity before approval is blocked.
Packaged production and shipment After approved release, consume 4 m from the package for the matching heat. Pack the resulting finished lot into stock, then ship part of it in a new package. In Package History, match Source Package, Destination Package, lot, and quantity to the physical goods. Find both the packing transfer and shipment in the stock package's history.
Partial operations Receive a single PO in two slips and validate their backorders with separate slip references. For a heat used twice, confirm release is denied while either receipt is unchecked. Complete a partial MO with a second lot on the backorder and ship in two deliveries. Trace both.
Manufacturing integrity Attempt to consume both heats on one MO and attempt to reuse an existing finished lot on another MO. Both are blocked. Post separate orders and check the links in both directions.
Corrections Return a delivered lot from its original delivery, record the actual return package, and repack through a posted transfer. Confirm that the return and repacking histories preserve the lot, quantities, and package trail, and that the original delivery still shows its shipped package. Also check scrap or a linked supplier return for rejected input and verify the corrected balance.
Company and roles Run receipts, inspections, and release as their operational users. With two companies enabled, a passing inspection in another company does not release the lot. Verify unauthorized users cannot validate a release.
Sale and documents Print the lot-bearing delivery slip. If invoicing is in the pilot, invoice only the delivered quantity and verify the lot on a partial invoice and on a reprint after a return.

The addon tests use synthetic records and exercise the guarded stock posting and the OCB traceability links. Run the PMIVerse single-addon runner against a verified unused local test_ database with the addon tests directory as the scope. From the pmis-beta repository root, with $pilot_test_db set to that verified name:

/srv/pmiverse/_pmiconfig/scripts/test/run_pytest_addon.sh \
  -a "$PWD/pmis_lot_traceability/tests" -d "$pilot_test_db" -- -q

Use the table above for operational acceptance with the pilot users and warehouse configuration.