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?