The packaging forecast report to show how many packs T-A should produce

Basically, how to forecast packaging needs in Odoo ?

In Odoo, Packaging (the UoM) is different from Packages

• In packaging, 
  • UoM is defined at the product level
  • We sell by Pack (pack of 6, pack of 12)
• But packages
  • are physical containers (boxes, pallets)
  • are used in warehouse operations via the feature “Put in Pack”

It’s important to know that Odoo forecasting is based on UoM

• 1 Unit →  1L bottle water
• 1 Pack of 12 → 12 x  1L bottle water
• 5 Pack of 12 → 60 bottles of water

👉 As a result, if inventory is tracked in Units, forecasting will show 60 units instead of 5 packs (that is the problem → we don’t have packaging forecast in that case)

The broken package problem

• If T-A uses glass bottles
• they have 100 glass bottles in stock
• and 3 bottles are broken,
• inventory will show 97 bottles
• Pack of 12 → 8.08 packs

👉  The pack will be fractional and that will be confusing  (another problem)

The solution is to use Units across the inventory

But forecast will not show the packs

We need a custom packaging forecast

• We track individual products by Unit 
• We forecast in packaging

How Odoo forecasting works

Explanation:

• On Hand: what we have physically in stock
• Outgoing: confirmed sales orders
• Incoming: confirmed purchase orders, confirmed manufacturing orders

If we have

• 6  bottles on Hand
• 12 bottles incoming
• 6 outgoing
• Forecasted Stock = 12 bottles (Units)

If we have

• Forecasted Stock = 12 bottles
• Pack Size = 6 
• Forecasted Packages = 2

👉  Watch the video -> https://youtu.be/otwtFKAYlzU