Odoo Help


How to display a list of boms for each product/bom?

on 12/1/14, 7:54 AM 1,248 views

In the mrp-module, each product can be related to a single bill-of-materials (bom) describing the sub-components of that product.

Now, I want to work in the opposite direction, so to speak: For each product (or alternatively for the bom related to the product) I want to display a list of all boms, in which this product/bom figures as a sub-component. In other words, given a product, I want to answer the question: In which (other) products does this product appear as a component? 

How is this best achieved?


Ludo - 21South

--Ludo - 21South--
| 2 2 5
Zwijndrecht, Netherlands
--Ludo - 21South--


Ludo - 21South
On 12/1/14, 11:12 AM

I don't know if Odoo offers an off-the-shelve report for this. I do know however that each line in a MRP BOM is in fact in the same table as the BOM itself (because you can have a multi-depth BOM). Also, all these lines have product_id values in there, so logically and query wise; if the line in the mrp_bom table contains both a parent_id (meaning it is part of a BOM) and has your product_id, then it needs to be displayed in the overview.

Perhaps something as simple as a view on mrp_bom using some filters could do the trick. Another one is to check under products if someone already created such a view. Good start would be on the BOM or the product itself, under the "More" button.

On 12/1/14, 11:35 AM


About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 12/1/14, 7:54 AM
Seen: 1248 times
Last updated: 3/16/15, 8:10 AM