Skip to Content
Menu
This question has been flagged
3 Replies
2320 Views

We use a lot of multilevel BOMs for our products.
So let's say we have a product called "Car A".

I would like to have a filter, which lists all products/parts used to build "Car A".
With an additional filter "screw" I would be able to list all screw types which are used to build "Car A".

Because all our BOM-names start with an acronym for the corresponding final product (in this case "Car A") we wouldn't necessarily need to list BOM-parts recursively.

I wasn't able to achieve this with custom filters or even the "Manage Filters" view, because there is no field "used by" or "parent" in the database.

Currently I use the PDF-Report of "Structure & Cost" and search through the list manually...

Am I missing something or do you have any suggestions?

Thank you!


Avatar
Discard
Author

An other example:
If I have a "Table A" with the components "metal leg", "table top" and "screw".
And I have a "Table B" with the components "wooden leg", "table top" and "screw".
I would like to have a filter where if I use the keyword "table", I would get:
metal leg
wooden leg
table top
screw

Best Answer

Above answer uses a link to an image that no longer works. 

My answer, search for BoM Components>Parent BoM>Product>is in>[name of BoM you want to search]. You can use the drop down menu to select the BoM that you want to search. 

This will pull up all of the components/products in the selected BoM. You can also select all of or some of the components, click the "Action" smart button at the top of the screen, and export. During export, you can select fields to include in your export (e.g. vendor, vendor PN, etc.) that may not be displayed on the list of products pulled up by the search. 

Avatar
Discard
Best Answer

Hello there!

I have a simmilar question, but currently i did not found any answer, including this post too.

We also produce products that have multilevel BOMs, but these products are with variants. We use lots of components like screws, cables etc that are common for many BOMs. The list goes in hundreds of parts, but when u include variants, its more like thousands. I'd like to have a way to filter all the components, that are used in top final product, all the way down to the most basic components in the lowest BOM.
Is there any way to do it?

To give u an exaple, like Frederik did above:
We produce, lets say, "Flashlight A" and "Flashlight B". Both in black or white finish.
"Flashlight A" is made out of "painted body A" and "light engine 1"
"Flashlight B" is made out of "painted body B" and the same "light engine 1" as above.
Given the fact that "Flashlight ..." can be black or white " painted body ..." also can be black or white.
Before beeing painted, lets call that body "raw body ...".
Before beeing "raw body ..." its a "metal tubing" - common for both "raw bodys"

Now:
I'd like to type in the filter field word "Flashlight" and the list should go as follow:
-Flashlight A black
-Flashlight A white
-Flashlight B black
-Flashlight B white
-Light engine 1
-Body A black
-Body A white
-Body B black
-Body B white
-Raw Body A
-Raw Body B
-Metal tubing

So, as you see above, it should show all the components that find application in the final product.
Do you know any way to do it? Stock Odoo 15 doesnt look like it has any filter/mechanism that does that.

Thanks in advance.

Avatar
Discard
Best Answer

Hi Frederik,


You can filter out for component or BOM's Set from product/Inventory list via below filter of the "Advanced Filter".

1 => Bill Of Materials
2 => BOM Components

Reference Screenshot :- BOM - Components Filter - ODOO

Thanks & Regards.
Sunny Sheth

Avatar
Discard
Author

Hello Sunny, thank you for your reply.
If I use your filters with the keyword "car"
1. will show me all products that have a BOM with "car" in the name.
2. will show all products that use a component in there bom with "car" in it (like the smartbutton "used by")
But I would like to list all components, which are part of a BOM where "car" is in the BOM-Name.
An other example:
If I have a "Table A" with the components "metal leg", "table top" and "screw".
And I have a "Table B" with the components "wooden leg", "table top" and "screw".
I would like to have a filter where if I use the keyword "table", I would get:
metal leg
wooden leg
table top
screw

I hope this example makes it clear.
Thank you!

Related Posts Replies Views Activity
0
Jul 24
209
0
Sep 23
1026
0
Aug 23
491
2
Jun 23
2472
1
Aug 22
10780