Is it? My scenario is that the suppliers deliver by the case and that the stores would sell by the bottle. Although by definition of 'finished good', your suggestion makes sense: you sell the finished good (ie, the bottle). However, ofbiz 'transforms' products with type 'marketing package' using the details in the entity ProductAssoc. To be more specific, ofbiz uses the entity ProductAssoc to specify that to create product in *productId*, you'll need x *quantity* from product *productToId*. Considering these, to transform the case to bottle, I need to declaire bottle as 'marketing package' since it is transformed from case. And for ProductAssoc, bottle (productId) is associated to case (productToId) and it takes 0.083 of case to make a bottle. Ive tested this with the current live demo of ofbiz, and this setup gives me the correct result (disregarding the decimal values).
Again, I am not completely sure of my findings. Please do correct me where I could be wrong. --- Ian Tabangay On Thu, Aug 6, 2009 at 3:07 AM, Vince Clark <vcl...@globalera.com> wrote: > Are you sure you don't have this backwards? Shouldn't the case be the > marketing package and the bottle the finished good? > > > Vince Clark > www.globalera.com > vcl...@globalera.com > (303) 493-6723 office > (303) 523-4843 cell > > > ----- Original Message ----- > From: "ian tabangay" <itaban...@gmail.com> > To: user@ofbiz.apache.org > Sent: Tuesday, August 4, 2009 2:02:52 AM GMT -07:00 US/Canada Mountain > Subject: Question on inventory for Products of Type Marketing Package: Auto > Manufactured > > Hi. > Is there a way to set the scale or round off value for products of type > Marketing Package: Auto Manufactured? > For example: > Given product *case* of type Finished Goods and product *bottle* of type > Marketing Package: Auto Manufactured, > and their association is *bottle *to *case *of type Manufacturing Bill of > Material with quantity 0.0833 (dozen bottles per case). > If I have 10 (QOH in Inventory) of product *case*, I got 120 (QOH from > Component) of product *bottle* (which is correct). > However if I removed one product *bottle*, then my QOH in Inventory of > product *case* is 9.92 (somewhat correct) and > QOH from Component of product *bottle* is 119.04 when it should be just > 119. > Resulting inventory came from the service > getMktgPackagesAvailable. > > > Ian Tabangay >
