Hi,

Please refer to the module: 

https://apps.odoo.com/apps/modules/18.0/mrp_bom_structure_xlsx

This module helps you export the entire BoM structure (all levels) into an Excel file. 

Hope it helps.

Create a Menu for Bill of Material Lines and export those instead.

In Developer Mode, nagivate to Settings --> Technical --> Database Structure --> Models

Find and open the Bill of Material Line (mrp.bom.line) model

Scroll to the bottom, click Create a Menu and choose the Parent Menu - maybe Manufacturing --> Products

Refresh your browser until you see the new Menu and use it to export all lines including which parent or child BoM they are attached to.

Hi,

You're right, it seems like 3 levels is the maximum for the export. I believe this part of the code is responsible for it:

// File: addons/web/static/src/views/view_dialogs/export_data_dialog.js
// Line: 224

isFieldExpandable(id) {
  return this.knownFields[id].children && id.split("/").length < 3;
}

https://github.com/odoo/odoo/blob/67a5213238ca95ea6cdab2c40943cc593b2308e5/addons/web/static/src/views/view_dialogs/export_data_dialog.js#L224

You could try to override the limit.

Alternatively, you could do the following:

• Export all BoMs and write a script that lists all nested components of a BoM
• Extend the mrp.bom model with your own export function