Skip to content

Trace a Durian Lot Back to Its Orchards in Odoo 19

Record receipts, packing, and delivery, then use the Traceability report to find the sources of a packed lot
November 15, 2026 by
Tomz

The export team gets two references from the border: EXP-042 from the shipping paperwork and PK-204 from a carton label. Can the team find the receiving records for both orchards in Odoo? The previous article looked at this question from the packhouse’s perspective. This time, we’ll enter the transactions in Odoo 19 and see where those two references lead.

Use a test database with Inventory and Manufacturing installed. The exercise uses a single warehouse with one-step receipts, manufacturing, and deliveries. The screenshots come from an Odoo 19 Community test database. Select any image to open it at full size. The orchards, recipient, and documents are fictional.

1. Turn on lot tracking and create the products

Go to Inventory › Configuration › Settings. Under Traceability, enable Lots & Serial Numbers. Under Products, enable Units of Measure & Packagings, then click Save. Then go to Inventory › Products › Products and create the two products below. For each, set Product Type to Goods, select Track Inventory, and choose By Lots. Set each product’s inventory unit to kg using the unit field next to its Sales Price or Cost. Odoo lot tracking documentation · Odoo units of measure documentation

Two products used in the exercise
Product in Odoo Used for Exercise lots
Fresh Monthong Durian Fruit before sorting and packing IN-071, IN-072
Packed Monthong Durian Fruit after sorting and packing PK-204, PK-205
Inventory Settings with Lots & Serial Numbers enabled
Enable lot tracking under Traceability.
Fresh Monthong Durian product with tracking By Lots and stock unit kg
Set both products to track inventory by lots and use kilograms.

With two products, the manufacturing order records the incoming lots of one product it consumed and the packed lot of the other product it made. Go to Manufacturing › Products › Bills of Materials and create a bill of materials (BoM) for Packed Monthong Durian. Choose Manufacture this Product and set the bill of materials to use 1 kg of Fresh Monthong Durian per 1 kg of packed fruit. This ratio makes the exercise easy to reconcile. In a real packing run, record what you weigh and what you discard. Odoo 19 documentation on bills of materials

The Packed Monthong Durian bill of materials uses 1 kg of fresh fruit per 1 kg packed
The bill of materials uses a one-to-one ratio for this exercise.

2. Create a separate receipt for each orchard

Go to Inventory › Operations › Transfers › Receipts and create two receipts. If Orchard A and Orchard B are missing, create each contact when choosing the receiving partner. Select the orchard in Receive From, add Fresh Monthong Durian in the Operations tab, and set Demand to the quantity you expect to receive. Enter the reference for the underlying paperwork in Source Document.

Durian receipts by orchard
Receive From Source Document Incoming lot Actual receipt (kg)
Orchard A ORCHARD-A-071 IN-071 1,000
Orchard B ORCHARD-B-072 IN-072 400

On the product line, click Details to open Detailed Operations. Add a line and enter the lot number and quantity, then save and click Validate. Repeat for the second receipt. Reopen each completed receipt and check the orchard, document reference, lot number, and weight against the paperwork. Odoo 19 documentation on assigning lots on receipts

Receipt WH/IN/00001 from Orchard A with Source Document ORCHARD-A-071
The Orchard A receipt refers to the underlying paperwork, ORCHARD-A-071.
Receipt details for WH/IN/00001 with 1,000 kg from lot IN-071
The same receipt’s Details view shows the lot and the quantity received.

For Orchard B, open receipt WH/IN/00002 and the IN-072 line details.

If you buy through an aggregator, use the receiving paperwork to identify the partner in Receive From and record the orchard or plot identifier on evidence linked to that lot. In the exercise, both orchards deliver directly.

3. Pack PK-204 from two incoming lots

Go to Manufacturing › Operations › Manufacturing Orders. Create an order for 1,000 kg of Packed Monthong Durian, select the BoM, and click Confirm. Before completing the order, enter the finished lot and the incoming lots actually used.

  1. In Lot/Serial Number for the output, type PK-204 and select the option to create a lot with that number.
  2. In Components, open Details on the Fresh Monthong Durian line. In Pick From, record two lines for the fruit used: 600 kg from IN-071 and 400 kg from IN-072. If Odoo reserved everything from one lot, edit those lines to match what the team actually used. Save the details.

Check that the two lines add up to 1,000 kg, the packed weight in this run, and click Produce All. Once the manufacturing order is Done, reopen the component details and confirm that both lot numbers and their actual quantities were recorded. Odoo 19 documentation on manufacturing with lots

Manufacturing order WH/MO/00001 shows 1,000 kg produced in PK-204
Manufacturing order WH/MO/00001 produced packed lot PK-204.
Component details show 600 kg from IN-071 and 400 kg from IN-072
Check the quantities actually consumed in the component details.

4. Deliver PK-204 under reference EXP-042

Go to Inventory › Operations › Transfers › Deliveries and create a delivery. Create the Overseas Buyer contact if needed, then select Overseas Buyer in Delivery Address and enter EXP-042 in Source Document. Add 1,000 kg of Packed Monthong Durian and save. If Check Availability appears, use it to check stock for the delivery.

Open Details on the product line and check that the delivery uses 1,000 kg from PK-204. Correct the lot or quantity if it differs from what went into the container. Click Validate and check that the transfer is Done. Keep both references. Odoo assigns its own delivery number for warehouse records, and the team uses EXP-042 to match those records to the export paperwork. Odoo 19 documentation on choosing lots for delivery

Completed delivery WH/OUT/00001 to Overseas Buyer with Source Document EXP-042
Source Document links warehouse delivery WH/OUT/00001 to export reference EXP-042.
Delivery details show 1,000 kg of packed lot PK-204
Details shows that the team shipped 1,000 kg from PK-204.

5. Trace the delivery back to both orchards

Have someone who didn’t enter the transactions start with EXP-042 in Deliveries. Type EXP-042 in the search bar and choose Search Source Document for: EXP-042. Open the Done delivery and check Details for the quantity shipped from PK-204.

Then go to Inventory › Products › Lots / Serial Numbers. Find PK-204 for Packed Monthong Durian, open it, and click Traceability. Expand the WH/MO/00001 row for PK-204, then expand each component row for IN-071 and IN-072. The report shows receipt WH/IN/00001 from Orchard A and WH/IN/00002 from Orchard B. The WH/OUT/00001 row is the delivery for this lot. Open that delivery to see the export reference EXP-042. Open each receipt and check Receive From and Source Document. If the orchard name alone can’t identify the plot, use the reference to look up the source paperwork. Odoo 19 documentation on the Traceability report

PK-204 report branches from WH/MO/00001 to receipts WH/IN/00001 from Orchard A and WH/IN/00002 from Orchard B
Expand the production row and both component rows to see the two source receipts.

The delivery should show 1,000 kg of PK-204. The manufacturing order should show 600 kg of IN-071 from Orchard A and 400 kg of IN-072 from Orchard B. The receipt for IN-071 shows 1,000 kg because that’s what the orchard delivered. The 600 kg on the manufacturing order is what this packing run used.

6. Find where the rest of IN-071 went

Start with the 400 kg of IN-071 still in stock. Create a second manufacturing order for 350 kg of PK-205, use 350 kg from IN-071, and complete the order. Then go to Inventory › Operations › Adjustments › Scrap. Record 50 kg of Fresh Monthong Durian from lot IN-071 as scrap, select WH/Stock as the source location for the exercise, and click Validate. Create a delivery order for 350 kg of packed durian to Overseas Buyer. Enter EXP-043 in Source Document and leave the order in Draft to represent the planned shipment of PK-205. Odoo 19 documentation on scrapping inventory

Open Traceability for IN-071 and look for the two manufacturing orders and scrap order SP/00001. Open WH/MO/00002 to see that it produced PK-205, or click the small bent arrow to the left of the order reference to see the packed lot in a related traceability report. The movement quantities 600 + 350 + 50 add up to the 1,000 kg received. Open lot PK-205 and check its on-hand quantity and location. Check that EXP-043 is still in Draft. A completed delivery is the warehouse record that shows goods have shipped.

IN-071 report shows 1,000 kg received, 600 and 350 kg consumed, and 50 kg scrapped
The IN-071 report shows consumption by WH/MO/00001 and WH/MO/00002, and scrap on SP/00001.

What the records let you tell the border team

The records show that Orchard A and Orchard B supplied fruit for PK-204. To identify which orchard supplied a particular carton, keep records at carton level. Decide where to record or link the container number, plot identifiers, phytosanitary documents, and hold or release approvals in your own workflow. For example, link the container loading record to EXP-042 and have the person responsible for release record the decision against the supporting evidence. The lot report shows movements recorded in Odoo. Checking whether a shipment meets the requirements for export takes a review of the shipment’s underlying evidence.

Give another person just EXP-042 and PK-204. Ask them to find both receipts, give the weight used from each orchard in PK-204, and check whether PK-205 has shipped. If they hit a reference they can’t look up, write down the screen and the missing information so you can fix the record before the next drill.

Share this article

FacebookX
Thai Durian Held at the Border? How to Trace the Lot Back to the Orchard
Use ERP records to connect export shipments to packing runs and orchards, then see where else the fruit went