[go: nahoru, domu]
Skip to Content
This question has been flagged
manufacturingbomkitproducts17.0+e
3 Replies
184 Views
Avatar
Joe H

Howdy All,

I have been banging my head against the wall to figure out how to add an alternate part directly to a Bill of Material in the Odoo 17 SaaS system.

My use case: I sell fasteners. One can be made by Mfg A under their number & another can be made by Mfg B under their different number. They are different SKUs that I have setup as Product Variants under an industry standard. There will be cases where a customer can only accept manufacturer A & others where they can only accept B.

For my BOM, I can use either SKU--but, I don't need 2 of the same part on this BOM... I can't add the product template to the BOM (which would be ideal).. I tried to create a "roll-up" product that had attributes from both variants with no luck..

If it was a one-off, I'd consider just working around it, but I have 300 items that can accept 2-3 alternate parts across 7 BOMs--I'm not going to create 6300 BOMs to work around what should be 7 BOMs with part equivalents, as that will make things a nightmare to revision control.

I'd prefer to setup these as Kits, since that's what they are, but if I absolutely have to I can consider setting them up as Manufactured & just train my team to sub out the alternates on the production screen with flexible consumption on...

Anyone got any ideas (that don't entail installing a mod or migrating off SaaS)? Thank you!

PS: I think Odoo is great... But it has it's flaws & equivalent product cross-referencing is one of them in my use case.


TLDR: How do I add alternate/substitute/equivalent products to a BOM for a Kit?

Avatar
Discard
Avatar
Simon Wydooghe
Best Answer

Hey Joe

We seem to be in the same boat and are also missing the ability to easily specify substitute products in a BOM. Variants doesn't solve a thing here, because that's just an abstraction that creates more products and also forces me to choose one of those products that I want to manufacture. That's great for when you want to actually differentiate during manufacturing, but it doesn't help you when you want to "not care" about a certain component. The "kit" concept also doesn't help as far as I can tell, because that's just a way to explode a BOM into another BOM.

What is missing is really on the BOM line level as far as I can tell: there is always a link to a single product for every BOM line in Odoo's model. There is simply no way to say that multiple products are allowed or that all child products under a product template are allowed (and I have use cases for both those possible 'solutions' to be honest, not just one or the other). One way to go about it is to change the BOM lines ad-hoc when you create the manufacturing order, but even in this case, you are still force to make a choice for a component when you simply want to, again, "not care".

Anyway, besides doing custom development on this, I have not found a suitable workaround for this so far. I'm also hesitant to do custom development on this, because I'm afraid that's gonna be a maintenance nightmare with every upgrade. I've flagged this upstream last year at Odoo Experience to the Odoo manufacturing team that it's a shortcoming for us at least, no clue if they're inclined to improve this at some point. I sure hope so. I know they confirmed we weren't the only ones struggling with this.

Kind regards
Simon

Avatar
Discard
Avatar
Ray Carnes (ray)
Best Answer

Rivet is a product with a Manufacturer attribute and two Variants - Standard and Boeing



You end up with two products, with two SKU's, that can have two separate Vendors



They are tracked independently in Inventory



Create a SINGLE kit Bill of Materials for Widget that has two components

  • the first one, Rivet from Boeing, is consumed when the "Boeing" variant of the Widget is required
  • the second, Rivet from Aviation Supplier, is consumed when the "Standard" variant of the Widget is required

Depending on which Variant of Widget is needed Odoo will consume ONLY the appropriate raw material

Widget can also be a raw material in other Bill of Materials, as long as the parent products also have the same variant setup

Avatar
Discard
Joe H
Author

Thanks Ray!
In my scenario for BOMs, I usually don't care which Variant is used--they are functionally equivalent, but need to be tracked separately. It would be much simpler if I could add the product template to the BOM vs creating a separate SKU to track.

I'm still struggling to figure out how to get this to work properly, but I will keep plugging away at it.

Ray Carnes (ray)

You don't care but your Customers do, so why not record their choice right on the Sales Order? You are struggling and you don't even want to try this solution??

Joe H
Author

Ray, I did try it out -- I got some errors I need to go through and troubleshoot. We have the variants in place on the original products for when our customers do care.

Along with scouring the internet for days looking for a solution before posting, I've asked several others in my industry that I know have used Odoo in the past & it seems like this isn't a unique pain point. I'll shoot you an email directly so you can take a look at my usecase closer.

Avatar
Lars Aam
Best Answer

This should be possible to manage with Variants in Odoo.  

In sales configuration, activate Variants.  Then create the Attribute, and the possible attributes values. 

Variant might be Fasteners type. Values like Type A and Type B.  My testcase looks like this:

In the product you enter the variant and the attributes:

If you go to menu Products, you find product variants:

You create one BOM for the base product. In that BOM you specify which component is to be used by which variant. If you don't specify a variant for a component, it will be used for all variants.

You Manufacture variants.   And after manufacturing each variant got their own SKU:

Read more about variants:

https://www.odoo.com/documentation/saas-17.2/applications/sales/sales/products_prices/products/variants.html


Avatar
Discard
Joe H
Author

Thank you for the thorough reply -- I had variants turned on.. I just created an empty BOM under the base product -- I don't see an option to add it to the kit..

Are you advising how to create variants of a BOM (like if I have a tshirt that can be blue or black)? Or how to allow substitution of the variant products into a BOM (like if I want to sell a kit of pants+shirt & only want to know how many kits we have available--i just want 1 kit that would tell me how many Pants+shirt(blue or black both are ok))?

Lars Aam

You raise three questions:
1. To define variants on KIT is the same as for Manufacture products. If you do not se the field, click on the little symbol on the right side of the list. On symbol you can show / hide fields in list.
2. Yes. Create one BOM on the product template. Just as the example of T-shirts. That way you only maintain one BOM that specify all variants. Be aware of the settings on the Attribute on whether to create variants Instantly, Dynamically or Never. Big impact on how much master data you have.
3. Check availability for complete kits: Stock list will not help. Open the Bill of Material and click on Overview. It will show you details of what is available to sell as complete kits.

Related Posts Replies Views Activity
Manufacturing order for Kit BOM
manufacturing bom kit
Avatar
Avatar
1
Nov 23
768
BOM Manufacturing process for Variable Products Item calculation changes everytime
manufacturing custom bom products
Avatar
Avatar
1
Mar 21
1649
Manufacturing Validation Error - Quantity or Reserved Quantity should be set Solved
manufacturing bom
Avatar
Avatar
Avatar
2
Aug 24
989
Two products in one MO
manufacturing bom
Avatar
Avatar
1
Mar 24
257
How to record production failed quantity?
manufacturing bom
Avatar
Avatar
Avatar
2
Jun 21
1497