You’re facing a classic variable-weight packaging (catch weight) problem in Odoo, which is common in food industries like ice cream, meat, cheese, etc. The issue comes from mixing theoretical container quantity (4.8 kg) with real manufacturing weight (4.6 / 4.7 / 4.9) while invoicing and inventory are based on kg and barcode scanning is based on containers.

Here’s a clear and practical solution used in real Odoo food manufacturing implementations.

🎯 Root of the Problem

You currently have:

• Product UoM = kg (correct for invoicing)

• Container = 4.8 kg theoretical

• Manufacturing produces real weights

• Sales order = 3 containers

• Delivery scans 3 lots

• Real weight = 14.2 kg instead of 14.4

• Odoo shows:

Missing 0.2 kg
2.97 packages instead of 3

This happens because:

Odoo calculates based on theoretical UoM conversion instead of real lot weight.

So the system expects:

3 × 4.8 = 14.4 kg

But real production is:

4.6 + 4.7 + 4.9 = 14.2

✅ Correct Industry Approach

In food manufacturing, you should not use container as UoM.

Instead:

Product UoM = kg

and

Container = Packaging

not UoM.

🧩 Recommended Odoo Design

Step 1 — Product UoM

Product:

Ice Cream Vanilla
UoM = kg
Purchase UoM = kg
Inventory UoM = kg

This is correct already.

Step 2 — Use Packaging instead of UoM

Go to:

Product → Packaging

Create:

Container Small = 4.8 kg
Container Medium = 9.6 kg
Container Large = 12 kg

Now container is only:

Packaging

not UoM.

Step 3 — Manufacturing

When producing:

You create lots like:

Lot 001 → 4.6 kg
Lot 002 → 4.7 kg
Lot 003 → 4.9 kg

Each lot has real weight.

Stock becomes:

4.6
4.7
4.9

Correct.

Step 4 — Sales Order

Instead of:

3 containers

You sell:

Ice Cream = 14.4 kg (approx)

or

3 containers (informational only)

but system tracks kg.

Step 5 — Barcode Picking

During delivery:

Scan:

Lot 001 → 4.6
Lot 002 → 4.7
Lot 003 → 4.9

Odoo automatically calculates:

Total delivered = 14.2 kg

Delivery validated.

Invoice = 14.2 kg.

No missing quantity.

No 2.97 packages.

Problem solved.

📦 Container Still Visible on Sales

If client wants:

3 containers

you can add:

custom field

Number of Containers

or

Packaging on SO

This is informational only.

Invoice still based on kg.

🧠 Best Practice in Food Industry

Always:

Inventory = Weight

Sales = Weight

Invoice = Weight

Lots = Real Weight

Packaging = Container

⚙️ Better Advanced Solution

If they insist on:

sell 3 containers

but invoice real weight,

you need Catch Weight system.

This is usually done using:

OCA Catch Weight module

Odoo Community Association

Module:

stock_catch_weight
sale_catch_weight
mrp_catch_weight

This allows:

• Sell containers

• Deliver lots

• Invoice real weight

• Barcode scan correctly

• No quantity mismatch

This is the cleanest solution.

🧪 Example Workflow

Sales

3 containers

System calculates:

expected = 14.4

Delivery

Scan:

4.6
4.7
4.9

System:

delivered = 14.2

Invoice

14.2 kg

Customer pays real weight.

🚨 Important

Never use:

1 container = 4.8 kg

as UoM conversion.

Because Odoo expects exact math.

And food production never gives exact weight.

✅ Recommended Configuration

Product

UoM = kg

Tracking = Lots

Invoicing = Delivered Quantity

Packaging = Container

Manufacturing

Produce lots with real weight.

Sales

Sell kg or containers (info only)

Delivery

Scan lots

Invoice real weight.

📊 Final Recommendation

Best implementation in Odoo 19 on odoo.sh:

Option 1 (Simple and Fast)

Use:

• kg as UoM

• packaging for containers

• sell weight

• scan lots

✔ No mismatch

✔ No barcode issue

✔ No 2.97 containers

Option 2 (Professional Food Industry)

Install Catch Weight modules

✔ Sell containers

✔ Deliver weight

✔ Invoice real weight

✔ Full automation

❓ Quick Question

Does the company insist on selling 3 containers (not kg) on the Sales Order, or they are okay with selling kg and showing containers only for reference?