Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
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?
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.
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.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 12/1/14, 7:54 AM|
|Seen: 1165 times|
|Last updated: 3/16/15, 8:10 AM|