Hi,

In order to manage the bill of materials, please take a look at the following,

* https://www.youtube.com/watch?v=7VDSUOB8wWs

* https://www.cybrosys.com/blog/what-are-the-different-types-of-bills-of-materials-in-odoo-18

* https://www.cybrosys.com/blog/how-to-manage-bills-of-materials-bom-in-odoo-17-manufacturing-app

Hope it helps

Hello Paul, that's an interesting challenge for a paint shop setup!

  Unfortunately, Odoo's standard BOM structure isn't designed for dynamically adjustable component percentages or weights directly within the BOM itself. A standard BOM assumes fixed quantities of components.

  However, here are a couple of approaches you could consider:

  1. Using Product Variants and Optional Products:
    Create a main "Paint" product. Then, set up each base color as a product variant (e.g., Paint - Red, Paint - Blue).
    On the sales order, add the "Paint" product and then use optional products to add the specific base colors needed for that order. The sales team would manually adjust the quantities of each optional color based on the required percentage/weight.

  2. Customization:
    The most flexible solution would involve custom development. You could create a custom module that adds fields to the sales order line to specify the percentage or weight of each base color.
    This module would then calculate the required quantities of each base color and automatically create a manufacturing order with the correct component quantities.

  The customization route would provide a more seamless and accurate workflow but requires technical expertise.

For personalized assistance:
https://www.pragtech.co.in/contact-us-mql.html