I sell two metal boxes. I apply black or red paint based upon client selection. They can also choose to have a handle or not.
Say I have the following order for one client:
- 1 black box with no handle
- 1 red box with handle
This is of course a simplified example of what I need. The combination of finish products I sell is much greater.
I had the box, the colour and the accessory (handle) setup as three different products, which gives me the following sale order lines in my sale order:
- 2 Metal Box
- 1 Colour Red
- 1 Colour Black
- 1 Handle
When creating the sale order and also trying to create a reference code naming convention, I realized the client could end up with the handle on the wrong box.
I started looking at the BoM, but unsure that it could answer the need. Still I have a created a Bill of Materials, but haven't gone through the whole process and not clear how this would answer what I need.
What is the best way to set this up in OpenERP without having to create a product for every single combination?
I have the same problem, Till now for few products I created every possible combination, for others I am creating seperate sale orders.
I am starting to believe that a master product must be created that contains all the components it is made of. This master product will then be defined within the Bill of Materials as a hierarchy to make sure the appropriate product is manufactured. It will then be correctly reflected in the stock. Then to present the components into the sale order, I am thinking about creating dummy variants of the components, but these would have no stocks. Well that's the theory anyway and I need to test this!