Community: Inventory and MRP mailing list archives


Dynamic BoMs or Variants for Production

- 31.08.2017 14:08:02
Hi Community, 

I have a production requirement, which I though could be handle some way by the MRP module in Odoo, though through trial and error I've came to the conclusion that it can't be handle, as far as my knowledge goes.

Right now I have two different production industries with this need: Furniture Fabrics & Food and Beverages.

For example, if I produce Custom Furniture, each day there's a new unique furniture that has to bee created, I've kind of managed this with Pledra module on the Sales Order, but on the MRP side we have a huge issue as each furniture could have more than 400 combinations based on just two variables: fabric and color. There are more than 100 different fabrics and more than 20 different colors.

Based on this scenario, I was hoping I could create a Base BoM, with all the products common materials, and two sub-BoMs, one for fabrics and the other one for colors, each with all it's variants. But once I set a variant in a BoM i can't use this as a sub-BoM for the Base BoM, which forces me to create a BoM for each possible combination, but for a company that relies on timing this can't be an option.

Side note: As this also happens in restaurants I'm wondering how this is being managed on running implementations, as some restaurants also need this dynamism on Meals that could use different variants of the same ingredient, based on availability (for example), Rice could be one tof those; which could come from different providers, but each is a different variant as the rice is not the same, is cooked differently and in real life is a different product, but if the primary is not available then the secondary has to be used.

I'll appreciate experiences on this, 

Gustavo A. Valverde
Managing Partner
Av. Bolívar 407, Gascue,
Santo Domingo, D.N.

 +1 (829) 686-8270
Skype: gvalverde02

Este mensaje y sus anexos pueden contener información confidencial y privilegiada con la intención de que sea utilizada por las personas u organizaciones a quienes esta dirigida, por lo que su uso es exclusivo para su destinatario. Si usted ha recibido este mensaje por error, favor de eliminarlo e informar al remitente del mensaje a través de un correo de respuesta. Si este es el caso, le notificamos que queda estrictamente prohibida la distribución o reproducción de este e-mail y/o sus anexos. iterativo no se hace responsable de las opiniones vertidas en esta comunicación que no estén acordes con su quehacer y fines, y que no se revistan de un carácter oficial. 

This message and its enclosures may contain confidential and privileged information intended for the use of people and organizations to which it is directed and its use is thus limited to its addressee. If you have received this message by mistake, please eliminate it and inform the sender through a reply message. Should this be the case, you are advised that the distribution or reproduction of this e-mail and/or any attachments contained herein is strictly forbidden. iterativo is not liable for opinions expressed in this message which may not coincide with its responsibilities and purpose and which may not express official matters.