OdooWiki OCA HUB

MRP BOM Structure XLSX

mrp_bom_structure_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 allow you to export the BoM structure to MS Excel .XLSX format.

auto_awesome What this module does

AI-generated from the code · Odoo 19.0

Adds an Excel export of a Bill of Materials structure. From a BoM, users can download an .XLSX file listing the finished product and all its components level by level.

This module adds a new Excel report for Bills of Materials, so you can share or archive the full structure of a BoM outside Odoo.

Where it appears: it is available on the Bill of Materials screen (the mrp.bom model) as a report action named "Export BoM Structure to Excel". It is a print/export action, not a new menu.

What the file contains: the report builds a spreadsheet sheet called "BOM Structure". The first row shows the BoM name, level, product reference, product name, quantity, unit of measure and reference. Then, for each selected BoM, it writes the finished product line in bold, followed by every component line, indented with ">" marks to show the level of depth. Each component line shows its reference, name, quantity converted to the product's own unit of measure, that unit of measure, and the reference of the sub-BoM it comes from when applicable. The report follows sub-assemblies recursively, so multi-level BoMs are fully expanded.

Formatting: the sheet is set to landscape, fits one page wide, uses a frozen header row and fixed column widths, and includes a title style with a light yellow background.

Business rules: no checks, restrictions, emails or scheduled jobs are added. The module only reads existing BoM data and produces the Excel file.

Depends on

Required by other modules

Models and fields (1)
  • report.mrp_bom_structure_xlsx.bom_structure_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

To install this module, you need to:

  • Go to apps
  • Look for mrp_bom_structure_xlsx module
  • Click install

To use this module, you need to:

Go to the Bill of Materials form or list views, press 'Print \> Export BoM Structure to Excel'.

No verified information in OCA: 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.