v 10.0 v 11.0 v 12.0 Third Party 583
Download for v 10.0 Deploy on Odoo.sh
Odoo Online
On Premise
Odoo Apps Dependencies Manufacturing (mrp)
Inventory Management (stock)
Discuss (mail)
Community Apps Dependencies
Technical Name mrp_flattened_bom_xlsx
Versions 14.0 10.0 11.0 15.0 16.0 13.0 12.0
You bought this module and need support? Click here!

MRP Flattened BOM Report XLSX

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.


To use this module, you need to:

  1. Go to 'Manufacturing / Products / Bill of Materials'

  2. Select a BOM or more

    (Could be interesting to modify quantities of these BOMs)

  3. Go to 'Action / Export Flattened BOM to Excel'.

Try me on Runbot

Bug Tracker

Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us smash it by providing detailed and welcomed feedback.



  • Odoo Community Association: Icon.



Odoo Community Association

This module is maintained by the OCA.

OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.

To contribute to this module, please visit https://odoo-community.org.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.
There are no ratings yet!
Incorrect quantities
on 2/19/18, 10:18 AM

I have just installed this module. When exporting the flattened BOM, the quantities generated when summing up the components of each level of the BOMs are incorrect. Could you please check this ? Thank you