Bill of Materials Explosion
What you need to build the whole plan
Pick what you are going to manufacture and how much, and get every component with its exact quantity, walking nested recipes four levels down. It replaces the spreadsheet where that tree is worked out by hand today.
How you get it
Every development works in all three Odoo environments. The only thing that changes is how we deliver it.
Odoo Online (SaaS)
You do not need the ability to install modules. A Millora consultant comes in with temporary access that you authorize and implements it with Odoo Studio. When they are done, you revoke the access.
Odoo.sh or your own server
You receive the module and the installation guide by email as soon as payment clears. Install it yourself, or we install it with you.
Installation · shell
# 1 · copia el módulo a tu addons_path
cp -r millora_explosion_de_materiales /mnt/extra-addons/
# 2 · reinicia y actualiza la lista de apps
odoo-bin -u all -d tu_base --stop-after-init
# 3 · instala desde Apps
# busca "Bill of Materials Explosion"What it solves
The problem
Odoo stores every product's bill of materials, but shows them to you one at a time.
And when your recipes use other recipes — a dough that goes into a product that goes into another — working out how much flour the week's plan needs stops being a multiplication and becomes a tree. For Odoo to compute it on its own you first have to create the manufacturing orders, which is exactly what you don't want to do while you are still deciding whether the plan is viable.
So it gets done in a separate spreadsheet. And every time a quantity changes, it gets redone.
How it works
You build a report: add the products you are going to manufacture, choose which recipe and what quantity for each. A product with several bills of materials is not left to interpretation — you say which one.
On generate, it walks each recipe and goes four levels down: your product's components, those components' components, and so on. Each level is scaled by what its own bill of materials yields, not per unit: if a recipe makes 20 kilos, asking for 100 multiplies by five, not by a hundred.
The result comes in two views. A consolidated total, with every component summed across all levels — that is what goes to purchasing. And a level-by-level breakdown, to trace where each quantity came from when a number looks wrong.
Every row carries the component, the required quantity, its group and its internal reference. And components split into two tables — raw materials and work in progress — based on a product tag, so what you buy never gets confused with what you make.
Each report is stored with its reference and date, and stays listed so you can reopen it exactly as generated.
What it doesn't do
Worth saying, because it defines who this is for. It is a consultation tool: it tells you how much you need, not how much you are short. It does not read stock, does not reserve or move inventory, does not create purchase or manufacturing orders, and sends no alerts.
It goes four levels down: if your recipe chain runs deeper, the last stretch stays unexploded. And accuracy comes from the bills of materials — a badly captured one produces a confidently wrong report.
What changes
Planning stops living in a parallel spreadsheet only its author understands. Purchasing orders against a document with a reference and a date instead of against an email. And testing a scenario — "what if we take this one up to 200?" — costs one new report instead of an afternoon.
What's included
- Explodes several recipes at once, each with its own quantity to manufacture
- Goes four levels down through nested recipes
- Scales each level by what its bill of materials yields, not per unit
- Returns a consolidated total and, separately, the level-by-level breakdown
- Splits raw materials from work in progress using a product tag
- Shows each component's group and internal reference
- Lets you pick the recipe when a product has more than one bill of materials
- Stores every report with reference and date so you can pull it up unchanged
Requirements
- Manufacturing module active, with bills of materials already captured
- A product tag that tells raw materials apart from work in progress
- A group field on the product, for the report's grouping column
You might also need
Operations Portal
The shop floor reports production to Odoo without opening Odoo
Manufacturing
MTO / MTS Analysis
How much to make this month, with the order and the average side by side
Manufacturing
Multi-production
One board in, six pieces out, each with its own cost
Manufacturing