Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
2 Odpovědi
6732 Zobrazení

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?

Avatar
Zrušit
Nejlepší odpověď

yes

Avatar
Zrušit
Nejlepší odpověď

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.

Avatar
Zrušit