Calculate the weight of product from its components
Locked
 
|
Hi,
I have a product Manufactured from many products or raw materials Example: Product "A" has a weight 1Kg Product "B" has a weight 0.5Kg Product "C" is a result of assembling 1 unit of Product "A" & 2 units of Product "B" Product "C" has a weight = 1Kg X 1 + 0.5Kg X 2 = 2 Kg My Question is: Is there a way to let ofbiz Calculates the weight of Product "C" Using weights of products "A" & "B" as inputs ? Appreciating your help and Advice. Regards, Medhat |
Re: Calculate the weight of product from its components
|
|
Medhat,
Currenty there isn't in ProdCat nor in MFG a function that aggregates weights or prices of components/sub assemblies in the end product. It would definitely be a valuable addition to the usability of both application. However, you can add the total to the end products manually. Regards, Pierre 2012/7/1 Medhat <[hidden email]> > Hi, > > I have a product Manufactured from many products or raw materials > > Example: > Product "A" has a weight 1Kg > Product "B" has a weight 0.5Kg > > Product "C" is a result of assembling 1 unit of Product "A" & 2 units of > Product "B" > Product "C" has a weight = 1Kg X 1 + 0.5Kg X 2 = 2 Kg > > My Question is: > Is there a way to let ofbiz Calculates the weight of Product "C" Using > weights of products "A" & "B" as inputs ? > > Appreciating your help and Advice. > > Regards, > Medhat > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/Calculate-the-weight-of-product-from-its-components-tp4634261.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
|
|
Pierre,
Thank you for your valuable response. I will work on finding a way to achieve that, and will back to you and for the community for feedback and discussion.
Regards, Medhat On Sun, Jul 1, 2012 at 12:58 PM, Pierre Smits-3 [via OFBiz] <[hidden email]> wrote:
|
|
|
Hi,
Another Question, I have a product stored in the Inventory with UOM "Kg" and sold with different UOM "gm". Dose ofbiz make this conversion by it self ? Appreciating your help and Advice. Regards, Medhat On Mon, Jul 2, 2012 at 7:05 PM, Medhat <[hidden email]> wrote: > Pierre, > > Thank you for your valuable response. > > I will work on finding a way to achieve that, and will back to you and for > the community for feedback and discussion. > > Regards, > Medhat > > On Sun, Jul 1, 2012 at 12:58 PM, Pierre Smits-3 [via OFBiz] < > [hidden email]> wrote: > > > Medhat, > > > > Currenty there isn't in ProdCat nor in MFG a function that aggregates > > weights or prices of components/sub assemblies in the end product. > > > > It would definitely be a valuable addition to the usability of both > > application. However, you can add the total to the end products manually. > > > > Regards, > > > > Pierre > > > > 2012/7/1 Medhat <[hidden email]< > http://user/SendEmail.jtp?type=node&node=4634281&i=0>> > > > > > > > Hi, > > > > > > I have a product Manufactured from many products or raw materials > > > > > > Example: > > > Product "A" has a weight 1Kg > > > Product "B" has a weight 0.5Kg > > > > > > Product "C" is a result of assembling 1 unit of Product "A" & 2 units > of > > > Product "B" > > > Product "C" has a weight = 1Kg X 1 + 0.5Kg X 2 = 2 Kg > > > > > > My Question is: > > > Is there a way to let ofbiz Calculates the weight of Product "C" Using > > > weights of products "A" & "B" as inputs ? > > > > > > Appreciating your help and Advice. > > > > > > Regards, > > > Medhat > > > > > > -- > > > View this message in context: > > > > > > http://ofbiz.135035.n4.nabble.com/Calculate-the-weight-of-product-from-its-components-tp4634261.html > > > Sent from the OFBiz - User mailing list archive at Nabble.com. > > > > > > > > > ------------------------------ > > If you reply to this email, your message will be added to the discussion > > below: > > > > > http://ofbiz.135035.n4.nabble.com/Calculate-the-weight-of-product-from-its-components-tp4634261p4634281.html > > To unsubscribe from Calculate the weight of product from its > components, click > > here< > > > > . > > NAML< > http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml > > > > > > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/Calculate-the-weight-of-product-from-its-components-tp4634261p4634345.html > Sent from the OFBiz - User mailing list archive at Nabble.com. > |
Re: Calculate the weight of product from its components
Administrator
|
Yes, as long as a UomConversion record like
<UomConversion uomId="WT_kg" uomIdTo="WT_g" conversionFactor="1000"/> is provided. See UnitData.xml file Jacques Medhat Abdel Badie wrote: > Hi, > > Another Question, > > I have a product stored in the Inventory with UOM "Kg" and sold with > different UOM "gm". > Dose ofbiz make this conversion by it self ? > > Appreciating your help and Advice. > > Regards, > Medhat > > On Mon, Jul 2, 2012 at 7:05 PM, Medhat <[hidden email]> wrote: > >> Pierre, >> >> Thank you for your valuable response. >> >> I will work on finding a way to achieve that, and will back to you and for >> the community for feedback and discussion. >> >> Regards, >> Medhat >> >> On Sun, Jul 1, 2012 at 12:58 PM, Pierre Smits-3 [via OFBiz] < >> [hidden email]> wrote: >> >>> Medhat, >>> >>> Currenty there isn't in ProdCat nor in MFG a function that aggregates >>> weights or prices of components/sub assemblies in the end product. >>> >>> It would definitely be a valuable addition to the usability of both >>> application. However, you can add the total to the end products manually. >>> >>> Regards, >>> >>> Pierre >>> >>> 2012/7/1 Medhat <[hidden email]< >> http://user/SendEmail.jtp?type=node&node=4634281&i=0>> >>> >>> >>>> Hi, >>>> >>>> I have a product Manufactured from many products or raw materials >>>> >>>> Example: >>>> Product "A" has a weight 1Kg >>>> Product "B" has a weight 0.5Kg >>>> >>>> Product "C" is a result of assembling 1 unit of Product "A" & 2 units of >>>> Product "B" >>>> Product "C" has a weight = 1Kg X 1 + 0.5Kg X 2 = 2 Kg >>>> >>>> My Question is: >>>> Is there a way to let ofbiz Calculates the weight of Product "C" Using >>>> weights of products "A" & "B" as inputs ? >>>> >>>> Appreciating your help and Advice. >>>> >>>> Regards, >>>> Medhat >>>> >>>> -- >>>> View this message in context: >>>> >>> >> http://ofbiz.135035.n4.nabble.com/Calculate-the-weight-of-product-from-its-components-tp4634261.html >>>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>>> >>> >>> >>> ------------------------------ >>> If you reply to this email, your message will be added to the discussion >>> below: >>> >>> >> http://ofbiz.135035.n4.nabble.com/Calculate-the-weight-of-product-from-its-components-tp4634261p4634281.html >>> To unsubscribe from Calculate the weight of product from its components, click >>> here< >> >>> . >>> NAML< >> http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml >>> >>> >> >> >> -- >> View this message in context: >> http://ofbiz.135035.n4.nabble.com/Calculate-the-weight-of-product-from-its-components-tp4634261p4634345.html >> Sent from the OFBiz - User mailing list archive at Nabble.com. Yes, as long as a UomConversion record like <UomConversion uomId="WT_kg" uomIdTo="WT_g" conversionFactor="1000"/> is provided. See UnitData.xml file Jacques |
Re: Calculate the weight of product from its components
|
|
Thanks Jacques,
I also was asking myself that question. Do you know whether the conversion also works in Manufacturing? Regards, Pierre Verstuurd vanaf mijn iPad Op 3 jul. 2012 om 10:35 heeft "Jacques Le Roux" <[hidden email]> het volgende geschreven: > Yes, as long as a UomConversion record like > <UomConversion uomId="WT_kg" uomIdTo="WT_g" conversionFactor="1000"/> > is provided. > > See UnitData.xml file > > Jacques > > > Medhat Abdel Badie wrote: >> Hi, >> >> Another Question, >> >> I have a product stored in the Inventory with UOM "Kg" and sold with >> different UOM "gm". >> Dose ofbiz make this conversion by it self ? >> >> Appreciating your help and Advice. >> >> Regards, >> Medhat >> >> On Mon, Jul 2, 2012 at 7:05 PM, Medhat <[hidden email]> wrote: >> >>> Pierre, >>> >>> Thank you for your valuable response. >>> >>> I will work on finding a way to achieve that, and will back to you and for >>> the community for feedback and discussion. >>> >>> Regards, >>> Medhat >>> >>> On Sun, Jul 1, 2012 at 12:58 PM, Pierre Smits-3 [via OFBiz] < >>> [hidden email]> wrote: >>> >>>> Medhat, >>>> >>>> Currenty there isn't in ProdCat nor in MFG a function that aggregates >>>> weights or prices of components/sub assemblies in the end product. >>>> >>>> It would definitely be a valuable addition to the usability of both >>>> application. However, you can add the total to the end products manually. >>>> >>>> Regards, >>>> >>>> Pierre >>>> >>>> 2012/7/1 Medhat <[hidden email]< >>> http://user/SendEmail.jtp?type=node&node=4634281&i=0>> >>>> >>>> >>>>> Hi, >>>>> >>>>> I have a product Manufactured from many products or raw materials >>>>> >>>>> Example: >>>>> Product "A" has a weight 1Kg >>>>> Product "B" has a weight 0.5Kg >>>>> >>>>> Product "C" is a result of assembling 1 unit of Product "A" & 2 units of >>>>> Product "B" >>>>> Product "C" has a weight = 1Kg X 1 + 0.5Kg X 2 = 2 Kg >>>>> >>>>> My Question is: >>>>> Is there a way to let ofbiz Calculates the weight of Product "C" Using >>>>> weights of products "A" & "B" as inputs ? >>>>> >>>>> Appreciating your help and Advice. >>>>> >>>>> Regards, >>>>> Medhat >>>>> >>>>> -- >>>>> View this message in context: >>>>> >>>> >>> http://ofbiz.135035.n4.nabble.com/Calculate-the-weight-of-product-from-its-components-tp4634261.html >>>>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>>>> >>>> >>>> >>>> ------------------------------ >>>> If you reply to this email, your message will be added to the discussion >>>> below: >>>> >>>> >>> http://ofbiz.135035.n4.nabble.com/Calculate-the-weight-of-product-from-its-components-tp4634261p4634281.html >>>> To unsubscribe from Calculate the weight of product from its components, click >>>> here< >>> >>>> . >>>> NAML< >>> http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml >>>> >>>> >>> >>> >>> -- >>> View this message in context: >>> http://ofbiz.135035.n4.nabble.com/Calculate-the-weight-of-product-from-its-components-tp4634261p4634345.html >>> Sent from the OFBiz - User mailing list archive at Nabble.com. > > Yes, as long as a UomConversion > record like > <UomConversion uomId="WT_kg" uomIdTo="WT_g" conversionFactor="1000"/> > is provided. See UnitData.xml file > Jacques |
Re: Calculate the weight of product from its components
|
Administrator
|
It works where it's used. I guess Manufacturing is using it yes, but not sure, please check
Jacques From: "Pierre Smits" <[hidden email]> > Thanks Jacques, > > I also was asking myself that question. Do you know whether the conversion also works in Manufacturing? > > Regards, > > Pierre > > Verstuurd vanaf mijn iPad > > Op 3 jul. 2012 om 10:35 heeft "Jacques Le Roux" <[hidden email]> het volgende geschreven: > >> Yes, as long as a UomConversion record like >> <UomConversion uomId="WT_kg" uomIdTo="WT_g" conversionFactor="1000"/> >> is provided. >> >> See UnitData.xml file >> >> Jacques >> >> >> Medhat Abdel Badie wrote: >>> Hi, >>> >>> Another Question, >>> >>> I have a product stored in the Inventory with UOM "Kg" and sold with >>> different UOM "gm". >>> Dose ofbiz make this conversion by it self ? >>> >>> Appreciating your help and Advice. >>> >>> Regards, >>> Medhat >>> >>> On Mon, Jul 2, 2012 at 7:05 PM, Medhat <[hidden email]> wrote: >>> >>>> Pierre, >>>> >>>> Thank you for your valuable response. >>>> >>>> I will work on finding a way to achieve that, and will back to you and for >>>> the community for feedback and discussion. >>>> >>>> Regards, >>>> Medhat >>>> >>>> On Sun, Jul 1, 2012 at 12:58 PM, Pierre Smits-3 [via OFBiz] < >>>> [hidden email]> wrote: >>>> >>>>> Medhat, >>>>> >>>>> Currenty there isn't in ProdCat nor in MFG a function that aggregates >>>>> weights or prices of components/sub assemblies in the end product. >>>>> >>>>> It would definitely be a valuable addition to the usability of both >>>>> application. However, you can add the total to the end products manually. >>>>> >>>>> Regards, >>>>> >>>>> Pierre >>>>> >>>>> 2012/7/1 Medhat <[hidden email]< >>>> http://user/SendEmail.jtp?type=node&node=4634281&i=0>> >>>>> >>>>> >>>>>> Hi, >>>>>> >>>>>> I have a product Manufactured from many products or raw materials >>>>>> >>>>>> Example: >>>>>> Product "A" has a weight 1Kg >>>>>> Product "B" has a weight 0.5Kg >>>>>> >>>>>> Product "C" is a result of assembling 1 unit of Product "A" & 2 units of >>>>>> Product "B" >>>>>> Product "C" has a weight = 1Kg X 1 + 0.5Kg X 2 = 2 Kg >>>>>> >>>>>> My Question is: >>>>>> Is there a way to let ofbiz Calculates the weight of Product "C" Using >>>>>> weights of products "A" & "B" as inputs ? >>>>>> >>>>>> Appreciating your help and Advice. >>>>>> >>>>>> Regards, >>>>>> Medhat >>>>>> >>>>>> -- >>>>>> View this message in context: >>>>>> >>>>> >>>> http://ofbiz.135035.n4.nabble.com/Calculate-the-weight-of-product-from-its-components-tp4634261.html >>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com. >>>>>> >>>>> >>>>> >>>>> ------------------------------ >>>>> If you reply to this email, your message will be added to the discussion >>>>> below: >>>>> >>>>> >>>> http://ofbiz.135035.n4.nabble.com/Calculate-the-weight-of-product-from-its-components-tp4634261p4634281.html >>>>> To unsubscribe from Calculate the weight of product from its components, click >>>>> here< >>>> >>>>> . >>>>> NAML< >>>> http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml >>>>> >>>>> >>>> >>>> >>>> -- >>>> View this message in context: >>>> http://ofbiz.135035.n4.nabble.com/Calculate-the-weight-of-product-from-its-components-tp4634261p4634345.html >>>> Sent from the OFBiz - User mailing list archive at Nabble.com. >> >> Yes, as long as a UomConversion >> record like >> <UomConversion uomId="WT_kg" uomIdTo="WT_g" conversionFactor="1000"/> >> is provided. See UnitData.xml file >> Jacques > |
|
|
Hi Jacques,
Thank you for your valuable response, Regarding to the
product stored in the Inventory with UOM "Kg" and sold/ordered in different UOM "gm". Reference to your reply, kindly find my feedback. The record <UomConversion uomId="WT_kg" uomIdTo="WT_g" conversionFactor="1000"/>
Exists in the "UnitData.xml" file && Exists in the "UomConversion" Entity ==> (I checked Entity using Web Tools --> Entity Data Maintenance)
The service "convertUomProduct" Exists in the file "/applications/product/script/org/ofbiz/product/product/ProductUomFormulas.xml"
But .. UOM Conversion does not look take place, and this service does not look get called !! Usage Scenario -- Fail one--: In "Edit Product" page ('Product' tab) -> "Measures" section , I set the following fields as flows:
Product Weight = 1 , Weight Uom Id = Gram [g] Quantity Included = 1 , Quantity UomId = Gram - g && In "Edit Product Prices" Page ('Prices' tab) , I added the following Entry:
Price Type : Default Price Price : 1 termUomId : weight: Gram (g) && In "Inventory Summary For" Page ('Inventory' tab) -> "Inventory Summary" section -> press "Receive Inventory" button
I did receive Inventory with Quantity Accepted : 5 && In "Facility manager" app -> "Facilities" -> "Inventory Items" , after selecting the received inventory Item just received above,
which has the : Accounting Quantity Total = 5 I updated the record with: Uom Id : WT_kg After that, When I order the product using : "Order Manager" -> "Order Entry"
When set Quantity = 6 --> which i thought it is 6 Grams, I found the "Order Items" as follows: Quantity : 6 Inventory: ATP = 5 , QOH = 5 [1 Backordered] Which means, the 6 in the Quantity was used as 6 Kg, and not 6 Grams !!!!!! I am sorry for this long post, but i liked to be sufficient and descriptive. Any suggestions, comments, guide line, descriptions, .. to what happened here ?
Appreciating your help and Advice.
Regards, Medhat On Wed, Jul 4, 2012 at 9:58 PM, Jacques Le Roux [via OFBiz] <[hidden email]> wrote:
|
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |