Skip to Content
Меню
Вам необхідно зареєструватися, щоб взаємодіяти зі спільнотою.
Це запитання позначене
1 Відповісти
144 Переглядів

Hello,

Could you please help me create a "BOM Overview" list that includes the Parent Part Number, Component Part Number, and Consumption? I need to export this list to Excel in order to verify that no mistakes were made during the implementation.

The report I currently get from Odoo only shows the Parent Part Numbers.

Thank you!

Аватар
Відмінити
Найкраща відповідь

Hi,

In Odoo, the standard Bill of Materials (BoM) report typically lists only the parent product or main assembly, without detailing the individual components and their quantities. To generate a “BOM Overview” that includes the Parent Part Number, Component Part Number, and Consumption, you can create a custom report or use a simple data export from the BoM and BoM Line models.

Here’s the solution approach:

You can go to Manufacturing → Products → Bills of Materials, then switch to List View, and use the Export option. From there, select fields from both the BoM (mrp.bom) and BoM Line (mrp.bom.line) models. Include:

Parent Product (Product → Internal Reference) – for the parent part number

Component (Product → Internal Reference) – for the component part number

Product Quantity – for consumption

If you don’t see the related fields, activate Developer Mode so you can access relational fields during export. This will produce a detailed Excel sheet showing each parent product, its corresponding components, and the quantity consumed, effectively giving you a complete BoM overview to cross-check the implementation.


Hope it helps.

Аватар
Відмінити