Siirry sisältöön
Menu
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Tämä kysymys on merkitty
1 Vastaa
149 Näkymät

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!

Avatar
Hylkää
Paras vastaus

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.

Avatar
Hylkää