Special product often received customer orders, it is product bom parts and standard, excuse me this situation how to design the reasonable for the database table, I hear people say you can use json to define the markup bom, but specific don't know how to operate, it experienced a friend how to resolve the situation, thank you!
Illustrated three bom list, a standard bom, two special bom,

CodePudding user response:

I said my train of thought, you can refer to:

CodePudding user response:

This type of you I understand as a standard order BOM and BOM
1, in standard BOM list and set up key type (such as: 0, standard parts; 1, preparation);
2, create a new form for the order BOM configuration, record the configuration and the original parent a child parts corresponding relation;
3, in the order BOM (your special BOM) load standard BOM, modify child build type established for allocation of a child, and associated order relationship in BOM, can only choose a table 2, the configuration of sub keys;
4, sales order to select the order BOM;
5, MRP choose specify order calculation;

CodePudding user response:

refer to the second floor kaijie_wu1209 response:

this type of you I understand as a standard order BOM and BOM
1, in standard BOM list and set up key type (such as: 0, standard parts; 1, preparation);
2, create a new form for the order BOM configuration, record the configuration and the original parent a child parts corresponding relation;
3, in the order BOM (your special BOM) load standard BOM, modify child build type established for allocation of a child, and associated order relationship in BOM, can only choose a table 2, the configuration of sub keys;
4, sales order to select the order BOM;
5, MRP choose specify order calculation;

Thank you for your reply, just discussed, decided to add in bom table type field to distinguish between types of bom table, build a bom type table associated bom type field, and then establish a common special bom list in the bom list, you can think this plan?