OdooWiki OCA HUB

Export Flattened BOM to Excel

mrp_flattened_bom_xlsx folder_open OCA/manufacture-reporting open_in_new
Manufacturing License: AGPL-3

This module extends the functionality of the MRP capabilities of Odoo, and allows you to export the flattened BOM to MS Excel .XLSX format.

A flattened bill of material removes the intermediate levels in the BOM and connect the lowest levels directly to the highest level.

A list of the sum of lowest levels will be shown for every BoM you export using this method.

It also maintains units correctly across all nested BOM's and take units that have been defined in product Unit of Measure field.

auto_awesome What this module does

AI-generated from the code · Odoo 19.0

Adds an Excel export of a bill of materials that flattens all sub-levels into one list of raw components with total quantities. You run it from the BOM screen and get an .xlsx file.

This module adds a new Excel report for bills of material (BOMs). Instead of showing the multi-level structure, it flattens it: every component buried inside sub-assemblies is brought up to the top level, and quantities are added together so you see the total amount of each raw material needed.

Where it appears: - On the Bill of Materials screen, in the print/action menu, a new entry "Export Flattened BOM Structure to Excel" is available on mrp.bom records. - The result is an .xlsx file with a sheet named "Flattened BOM", in landscape, fitted to one page wide.

What the file contains: - A header row with BOM Name, Product Reference, Product Name, Quantity, Unit of Measure and Reference. - One block per exported BOM: a first line describing the BOM itself (name, code, quantity and its unit), followed by one line per flattened component with its reference, name, total quantity and unit of measure.

Business rules and calculations: - Quantities are converted using the units of measure defined on the products, so nested BOMs keep consistent units. - The module walks through sub-BOMs recursively and sums quantities of the same component found at different levels. - If a BOM has no quantity set, no totals are produced for it.

The module extends mrp.bom with the flattening calculation and adds a new report model report.mrp_flattened_bom_xlsx.flattened_bom_xlsx.

Depends on

report_xlsxmrp

Required by other modules

mrp_flattened_bom_xlsx_direct_materials_cost
Models and fields (2)
  • mrp.bom · extends an existing model
  • report.mrp_flattened_bom_xlsx.flattened_bom_xlsx · new model

Text generated by AI (DeepSeek) from reading the Odoo 19.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub

Availability by version

Reviewed: 2026-11-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation status: 8 confirmed, 1 with no information of 9 versions.

Sources · Odoo 19.0

Confirmed on 2026-11-03 in branch 19.0 of OCA/manufacture-reporting.

terminal Installation and usage

OCA documentation · Odoo 19.0

Usage

Source · Odoo 19.0

To use this module, you need to:

  • Go to 'Manufacturing / Products / Bill of Materials'
  • Select a BOM or more BOMS (Could be interesting to modify quantities of these BOMs)
  • Go to 'Print / Export Flattened BOM to Excel'.

No verified information in OCA: Installation, Configuration.

info

Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.