How can I create many-to-many relation between product and BOM?
Locked
 
|
My business is plastic. So Bill Of Material was something about plastic compound that is mixing various type of chemical raw material in one batch. One product may come from many BOMs and one BOM may produce many product.
My purpose is: 1. Store list of BOM (and not dependent to each product) so that any product can refer to it in the future. 2. In one production run for order it can change BOM between run. From this scenario I go to look into the schema between ProductAssoc, ProductAssocType and Product entities. In ProductAssoc, It show the "lock" style relation between product and its raw material such as Product_a from material_a, Product_a from material_b and the point is, it has no primary key that point to BOM Identification key such as BOM_ID attribute so this schema is not answer my purpose. I don't know in OFBiz Schema, are there other relationships that can use for my scenario. Best Regards Tanakorn Numrubporn |
Re: How can I create many-to-many relation between product and BOM?
|
|
What in the current data model prevents you to define more than one
BOM for the same product? And what prevents you to share the same BOM with several products? Jacopo On Jun 27, 2008, at 8:30 AM, him_aeng wrote: > > My business is plastic. So Bill Of Material was something about > plastic > compound that is mixing various type of chemical raw material in one > batch. > One product may come from many BOMs and one BOM may produce many > product. > > My purpose is: > 1. Store list of BOM (and not dependent to each product) so that any > product > can refer to it in the future. > 2. In one production run for order it can change BOM between run. > > From this scenario I go to look into the schema between ProductAssoc, > ProductAssocType and Product entities. In ProductAssoc, It show the > "lock" > style relation between product and its raw material such as > Product_a from > material_a, Product_a from material_b and the point is there primary > key > that point to BOM Identification key such as BOM_ID attribute so > this schema > is not answer my purpose. > > I don't know in OFBiz Schema, are there other relationships that can > use for > my scenario. > > Best Regards > Tanakorn Numrubporn > -- > View this message in context: http://www.nabble.com/How-can-I-create-many-to-many-relation-between-product-and-BOM--tp18148900p18148900.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
|
|
My understand is, The raw material BOM was created from associated the product which was produce with the raw material which use to produce the product record by record.
Such as Product_a product by two material mat_a and mat_b. If I want to create BOM for Product_a I have to associated the Product_a with mat_a and mat_b and store in ProductAssoc entity. The problem is: I want to create only BOM that not lock to the product that will be produce. And I want to refer to the BOM identify key but the ProductAssoc give only FromDate key, which I can't refer to it with the product. May I create a new entity such ProductBOM and ProductBOMAssoc so ProductBOM will use store BOM and ProductBOMAssoc will use to be an associate entity between ProductBOM and Product entity.
|
Re: How can I create many-to-many relation between product and BOM?
|
|
What about something like:
product_common |____________________> mat_a |____________________> mat_b product_a |____________________> product_common product_b |____________________> product_common etc... And about the ability of defining more than one BOM for each product, I'd suggest to define new records for the ProductAssocType entity: "alternate bom", "special bom" etc... Jacopo On Jun 27, 2008, at 10:08 AM, him_aeng wrote: > > My understand is, The raw material BOM was created from associated the > product which was produce with the raw material which use to produce > the > product record by record. > > Such as Product_a product by two material mat_a and mat_b. If I want > to > create BOM for Product_a I have to associated the Product_a with > mat_a and > mat_b and store in ProductAssoc entity. > > The problem is: I want to create only BOM that not lock to the > product that > will be produce. And I want to refer to the BOM identify key but the > ProductAssoc give only FromDate key, which I can't refer to it with > the > product. > > May I create a new entity such ProductBOM and ProductBOMAssoc so > ProductBOM > will use store BOM and ProductBOMAssoc will use to be an associate > entity > between ProductBOM and Product entity. > > > Jacopo Cappellato-3 wrote: >> >> What in the current data model prevents you to define more than one >> BOM for the same product? And what prevents you to share the same BOM >> with several products? >> >> Jacopo >> >> >> On Jun 27, 2008, at 8:30 AM, him_aeng wrote: >> >>> >>> My business is plastic. So Bill Of Material was something about >>> plastic >>> compound that is mixing various type of chemical raw material in one >>> batch. >>> One product may come from many BOMs and one BOM may produce many >>> product. >>> >>> My purpose is: >>> 1. Store list of BOM (and not dependent to each product) so that any >>> product >>> can refer to it in the future. >>> 2. In one production run for order it can change BOM between run. >>> >>> From this scenario I go to look into the schema between >>> ProductAssoc, >>> ProductAssocType and Product entities. In ProductAssoc, It show the >>> "lock" >>> style relation between product and its raw material such as >>> Product_a from >>> material_a, Product_a from material_b and the point is there primary >>> key >>> that point to BOM Identification key such as BOM_ID attribute so >>> this schema >>> is not answer my purpose. >>> >>> I don't know in OFBiz Schema, are there other relationships that can >>> use for >>> my scenario. >>> >>> Best Regards >>> Tanakorn Numrubporn >>> -- >>> View this message in context: >>> http://www.nabble.com/How-can-I-create-many-to-many-relation-between-product-and-BOM--tp18148900p18148900.html >>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>> >> >> >> > > -- > View this message in context: http://www.nabble.com/How-can-I-create-many-to-many-relation-between-product-and-BOM--tp18148900p18150198.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
|
|
Oh! Thank for excellent reply. Your solution is simple but best.
Thank a lot Tanakorn Numrubporn
|
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |