Export Flattened BOM to Excel

mrp_flattened_bom_xlsx
REPOSITORY
REPOSITORYOCA/manufacture-reporting
GIT
GIThttps://github.com/OCA/manufacture-reporting.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/manufacture-reporting/tree/18.0/mrp_flattened_bom_xlsx
VERSION
VERSION 1.0.0
CATEGORY
CATEGORYManufacturing
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), ForgeFlow
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), ForgeFlow
COMMITTERS
COMMITTERSAaronHForgeFlow, Weblate, OCA-git-bot, oca-ci
WEBSITE
WEBSITEhttps://github.com/OCA/manufacture-reporting
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 19:30:20
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/reporting-engine:
    - report_xlsx
odoo/odoo:
    - base
    - web
    - mrp
    - product
    - mail
    - base_setup
    - bus
    - web_tour
    - html_editor
    - uom
    - stock
    - barcodes_gs1_nomenclature
    - barcodes
    - digest
    - portal
    - web_editor
    - http_routing
    - auth_signup
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION
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.

Code Analysis

Views touched (0)

No views found for this module.

Models touched (2)

New fields (0)

No new fields.

Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (2)
  • generate_xlsx_report(self, workbook, data, objects)
  • print_flattened_bom_lines(self, bom, requirements, sheet, row)
REPOSITORY
REPOSITORYOCA/manufacture-reporting
GIT
GIThttps://github.com/OCA/manufacture-reporting.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/manufacture-reporting/tree/17.0/mrp_flattened_bom_xlsx
VERSION
VERSION 1.0.0
CATEGORY
CATEGORYManufacturing
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), ForgeFlow
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), ForgeFlow
COMMITTERS
COMMITTERSOCA-git-bot, oca-ci, Andreu Orensanz
WEBSITE
WEBSITEhttps://github.com/OCA/manufacture-reporting
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 19:20:11
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/reporting-engine:
    - report_xlsx
odoo/odoo:
    - base
    - web
    - mrp
    - product
    - mail
    - base_setup
    - bus
    - web_tour
    - uom
    - stock
    - barcodes_gs1_nomenclature
    - barcodes
    - digest
    - portal
    - web_editor
    - http_routing
    - auth_signup
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES xlrd
xlsxwriter
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION
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.

Code Analysis

Views touched (0)

No views found for this module.

Models touched (2)

New fields (0)

No new fields.

Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (2)
  • generate_xlsx_report(self, workbook, data, objects)
  • print_flattened_bom_lines(self, bom, requirements, sheet, row)
REPOSITORY
REPOSITORYOCA/manufacture-reporting
GIT
GIThttps://github.com/OCA/manufacture-reporting.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/manufacture-reporting/tree/16.0/mrp_flattened_bom_xlsx
VERSION
VERSION 1.1.0
CATEGORY
CATEGORYManufacturing
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), ForgeFlow
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), ForgeFlow
COMMITTERS
COMMITTERSWeblate, OCA-git-bot, oca-ci, JasminSForgeFlow, Dhara Solanki
WEBSITE
WEBSITEhttps://github.com/OCA/manufacture-reporting
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:54:00
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/reporting-engine:
    - report_xlsx
odoo/odoo:
    - base
    - web
    - mrp
    - product
    - mail
    - base_setup
    - bus
    - web_tour
    - uom
    - stock
    - barcodes_gs1_nomenclature
    - barcodes
    - digest
    - portal
    - web_editor
    - http_routing
    - auth_signup
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (0)

No views found for this module.

Models touched (2)

New fields (0)

No new fields.

Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (2)
  • generate_xlsx_report(self, workbook, data, objects)
  • print_flattened_bom_lines(self, bom, requirements, sheet, row)
REPOSITORY
REPOSITORYOCA/manufacture-reporting
GIT
GIThttps://github.com/OCA/manufacture-reporting.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/manufacture-reporting/tree/15.0/mrp_flattened_bom_xlsx
VERSION
VERSION 1.0.0
CATEGORY
CATEGORYManufacturing
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), ForgeFlow
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), ForgeFlow
COMMITTERS
COMMITTERSWeblate, OCA-git-bot, oca-ci, Joan Mateu Jordi
WEBSITE
WEBSITEhttps://github.com/OCA/manufacture-reporting
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:46:44
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/reporting-engine:
    - report_xlsx
odoo/odoo:
    - base
    - web
    - mrp
    - product
    - mail
    - base_setup
    - bus
    - web_tour
    - uom
    - stock
    - barcodes
    - digest
    - portal
    - web_editor
    - http_routing
    - auth_signup
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES xlrd
xlsxwriter
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (0)

No views found for this module.

Models touched (2)

New fields (0)

No new fields.

Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (2)
  • generate_xlsx_report(self, workbook, data, objects)
  • print_flattened_bom_lines(self, bom, requirements, sheet, row)
REPOSITORY
REPOSITORYOCA/manufacture-reporting
GIT
GIThttps://github.com/OCA/manufacture-reporting.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/manufacture-reporting/tree/14.0/mrp_flattened_bom_xlsx
VERSION
VERSION 1.0.1
CATEGORY
CATEGORYManufacturing
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), ForgeFlow
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), ForgeFlow
COMMITTERS
COMMITTERSLois Rilo, Víctor Martínez, oca-travis, Weblate, OCA-git-bot, Bernat Puig Font, oca-git-bot
WEBSITE
WEBSITEhttps://github.com/OCA/manufacture-reporting
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:41:13
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/reporting-engine:
    - report_xlsx
odoo/odoo:
    - base
    - web
    - mrp
    - product
    - mail
    - base_setup
    - bus
    - web_tour
    - uom
    - stock
    - barcodes
    - digest
    - portal
    - web_editor
    - http_routing
    - auth_signup
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (0)

No views found for this module.

Models touched (2)

New fields (0)

No new fields.

Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (2)
  • generate_xlsx_report(self, workbook, data, objects)
  • print_flattened_bom_lines(self, bom, requirements, sheet, row)
REPOSITORY
REPOSITORYOCA/manufacture-reporting
GIT
GIThttps://github.com/OCA/manufacture-reporting.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/manufacture-reporting/tree/13.0/mrp_flattened_bom_xlsx
VERSION
VERSION 1.0.0
CATEGORY
CATEGORYManufacturing
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), ForgeFlow
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), ForgeFlow
COMMITTERS
COMMITTERSoca-travis, Weblate, OCA-git-bot, Adrià Gil Sorribes, Joan Sisquella
WEBSITE
WEBSITEhttps://github.com/OCA/manufacture-reporting
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:34:21
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/reporting-engine:
    - report_xlsx
odoo/odoo:
    - base
    - web
    - mrp
    - product
    - mail
    - base_setup
    - bus
    - web_tour
    - uom
    - stock
    - barcodes
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (0)

No views found for this module.

Models touched (2)

New fields (0)

No new fields.

Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (2)
  • generate_xlsx_report(self, workbook, data, objects)
  • print_flattened_bom_lines(self, bom, requirements, sheet, row)
REPOSITORY
REPOSITORYOCA/manufacture-reporting
GIT
GIThttps://github.com/OCA/manufacture-reporting.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/manufacture-reporting/tree/12.0/mrp_flattened_bom_xlsx
VERSION
VERSION 1.0.0
CATEGORY
CATEGORYManufacturing
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), Eficent
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), Eficent
COMMITTERS
COMMITTERSOCA Transbot, oca-travis, Weblate, OCA-git-bot, hveficent
WEBSITE
WEBSITEhttps://github.com/OCA/manufacture-reporting
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:29:26
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/reporting-engine:
    - report_xlsx
odoo/odoo:
    - base
    - web
    - mrp
    - product
    - decimal_precision
    - mail
    - base_setup
    - bus
    - web_tour
    - uom
    - stock
    - barcodes
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES xlrd
xlsxwriter
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (0)

No views found for this module.

Models touched (2)

New fields (0)

No new fields.

Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (2)
  • generate_xlsx_report(self, workbook, data, objects)
  • print_flattened_bom_lines(self, bom, requirements, sheet, row)
REPOSITORY
REPOSITORYOCA/manufacture-reporting
GIT
GIThttps://github.com/OCA/manufacture-reporting.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/manufacture-reporting/tree/11.0/mrp_flattened_bom_xlsx
VERSION
VERSION 1.0.0
CATEGORY
CATEGORYManufacturing
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), Eficent
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), Eficent
COMMITTERS
COMMITTERSGitHub, oca-travis, hveficent
WEBSITE
WEBSITEhttps://github.com/OCA/manufacture-reporting
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:24:03
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/reporting-engine:
    - report_xlsx
odoo/odoo:
    - base
    - web
    - mrp
    - product
    - decimal_precision
    - mail
    - base_setup
    - bus
    - web_tour
    - stock
    - barcodes
    - web_planner
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES xlrd
xlsxwriter
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (0)

No views found for this module.

Models touched (2)

New fields (0)

No new fields.

Public methods (0)

No public methods.

New fields (0)

No new fields.

Public methods (2)
  • generate_xlsx_report(self, workbook, data, objects)
  • print_flattened_bom_lines(self, bom, requirements, sheet, row)
REPOSITORY
REPOSITORYOCA/manufacture-reporting
GIT
GIThttps://github.com/OCA/manufacture-reporting.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/manufacture-reporting/tree/10.0/mrp_flattened_bom_xlsx
VERSION
VERSION 1.0.0
CATEGORY
CATEGORYManufacturing
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), Eficent
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), Eficent
COMMITTERS
COMMITTERSLois Rilo, Jordi Ballester Alomar, OCA Transbot, ahenriquez, oca-travis
WEBSITE
WEBSITEhttps://github.com/OCA/manufacture-reporting
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:20:03
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/reporting-engine:
    - report_xlsx
odoo/odoo:
    - base
    - report
    - web
    - base_setup
    - web_kanban
    - mrp
    - product
    - decimal_precision
    - mail
    - bus
    - web_tour
    - stock
    - procurement
    - barcodes
    - web_planner
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES xlsxwriter
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (0)

No views found for this module.

Models touched (1)

New fields (0)

No new fields.

Public methods (0)

No public methods.

STATUS
STATUSOpen migration PR - not merged yet for this version
REPOSITORY
REPOSITORYOCA/manufacture-reporting
PULL REQUEST
PULL REQUEST[19.0][MIG] mrp_flattened_bom_xlsx: Migration to 19.0 (#152)