Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Is it possible to filter products which are used in specific bom?

Subscribe

Get notified when there's activity on this post

This question has been flagged
searchrecursionmultilevelBOM
3 Replies
3971 Views
Avatar
Frederik Becker

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!


0
Avatar
Discard
Frederik Becker
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

Avatar
David Wright
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. 

0
Avatar
Discard
Avatar
Marcin
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.

0
Avatar
Discard
Avatar
Sunny Sheth
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

0
Avatar
Discard
Sunny Sheth

https://www.linkpicture.com/q/Odoo-Products-BOM-Filter.png

Frederik Becker
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!

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
Odoo 16 multilevel complicated BoM
kit multilevel BOM odoo16
Avatar
0
Jul 24
1634
How do I filter a spreadsheet pivot to the current/previous month
search
Avatar
Avatar
1
Jul 25
1613
Search a message Solved
search
Avatar
Avatar
1
Feb 25
1936
Disable Instant Search on /shop
search
Avatar
0
Sep 23
2825
constant (unchanging) quantity of by-products in the BOM
BOM
Avatar
0
Aug 23
2123
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now