Than you David.
I've tested to create a product called "Sand Bag".
1) The product has quantityIncluded=50 and quantityUomId=WT_kg.
2) Then I created a PO (productId="SanBag" and quantity=1 ) and I saw that
its OrderLine shows 50 Kg only as a info.
3) I received the PO and Ofbiz created a InventoyItem with qoh=1 and atp=1.
I hope Ofbiz created a InventoryItem with qoh=50 and atp=50. This means that
Is this only for informative purposes? (step 2). Doesn't Ofbiz really to
convert uom in inventory item? (step 3).
Thank you again.
On Thu, Feb 11, 2010 at 3:10 PM, David E Jones <d...@me.com> wrote:
>
> A sand bag really should have a unit of "each" since that basically means
> there is no unit of measure.
>
> For example if the sand bad contains 50 kg of sand then your product should
> have quantityIncluded=50 and quantityUomId=WT_kg.
>
> With those settings you'll know how much sand is in the bag.
>
> As for whether or not you'll have to customize OFBiz, that depends on the
> business process and how you want things to work (ie a lot more detail would
> be needed, plus testing/analysis time, in order to say).
>
> -David
>
>
> On Feb 11, 2010, at 2:03 PM, Juan Pablo wrote:
>
> > Hi.
> >
> > As David said I've created an articucle per unit of measure to work with
> > different product presentations but I would like work with two kinds of
> uom.
> > As I said uom of purchase and uom of inventory per product. Is it posible
> > with ofbiz 9.04 ? or is it necessary a customization to work with uom
> > conversions?
> >
> > A case: My supplier sales a product called "sand bag", its purchase uom
> is
> > "each" (units, I think so). Then I should store it in "kg" in my
> warehouse
> > because my company manage it in kg to production process or sales process
> or
> > physicall inventory process.
> > My supplier only sales it in units ("each" in ofbiz) so I need "the
> system"
> > converts uom of purchase to uom of inventory.
> >
> > I can to configure it in Ofbiz or I have to customize Ofbiz??
> >
> > Please, helpme.
> >
> > PD: I'm sorry to my bad english. I'm studying in a English Class
> recently. I
> > promise to improve my English soon.
> >
> > On Thu, Feb 11, 2010 at 12:57 PM, Juan Pablo <juanpablo.ma...@gmail.com
> >wrote:
> >
> >> Trank you guys.
> >>
> >> David, So, this means that Ofbiz 9.04 doesn't support uom conversions
> and
> >> that all inventory transactions are make in units. Am I right?.
> >>
> >> Abhai, I tested the functionality that you say but It doesn't work.
> >>
> >> I point to configure uom conversion from PO to Receipts with different
> unit
> >> of measure. In other word to configure uom of purchase and uom of
> inventory
> >> and their conversions.
> >>
> >> Thak you again.
> >>
> >>
> >>
> >>
> >> On Thu, Feb 11, 2010 at 4:13 AM, Abhai Chaudhary <
> >> abhai_chaudh...@mindtree.com> wrote:
> >>
> >>> what you are seeing here is expected behavior.
> >>>
> >>> You have defined "supplier.quantityUomId = Wt_kg" this means your
> supplier
> >>> does not supply this product less than defined "quantityUomId"
> >>> When you created a PO for this supplier, you agreed to this UOM and
> >>> quantity 1 (in KG) supplied by your supplier.
> >>> When you received this PO supplier UOM is converted into you warehouse
> UOM
> >>> which is WT_gm and hence Ofbiz correctly converted the APT and QOH
> according
> >>> to yr settings which is 1000.
> >>>
> >>>
> >>>
> >>> -----Original Message-----
> >>> From: David E Jones [mailto:d...@me.com]
> >>> Sent: Thursday, February 11, 2010 12:45 AM
> >>> To: user@ofbiz.apache.org
> >>> Subject: Re: How to manage uom conversion
> >>>
> >>>
> >>> It sounds like you're not going in the right direction with inventory
> >>> units. To be honest, I'm not sure where the uomId on the InventoryItem
> came
> >>> from or what it's meant for (would have to look at the code to see if
> it is
> >>> used anywhere or if it is just something someone added before thinking
> >>> things through and then never removed it... of course it is a bad idea
> to
> >>> name a field "uomId" because it doesn't say which other field the Uom
> is
> >>> supposed to be describing, and therefore requires research to figure
> out
> >>> what the heck it is).
> >>>
> >>> In any case, the unit for an InventoryItem is based on the
> >>> Product.quantityIncluded and Product.quantityUomId for the Product
> pointed
> >>> to by the InventoryItem.productId value. In other words, if you have a
> >>> product that represents 10 pounds using those two fields then every
> quantity
> >>> in the InventoryItem would be in terms of 10 pound units (ie a quantity
> of
> >>> .5 would mean 5 pounds of the thing).
> >>>
> >>> If you want to treat things differently you have two options:
> >>>
> >>> 1. convert units on the fly in the UI only (and use the configured
> units
> >>> for the Product in the DB)
> >>> 2. have multiple product records that represent different units of the
> >>> same thing
> >>>
> >>> -David
> >>>
> >>>
> >>> On Feb 10, 2010, at 3:07 PM, Juan Pablo wrote:
> >>>
> >>>> Hi guys.
> >>>>
> >>>> I've been testing oum conversion funcionality.
> >>>>
> >>>> 1) I created a product P with quantityUomId = WT_g
> >>>> 2) I asociated P to a supplier S with quantityUomId = WT_kg
> >>>> 3) I created a purchase order
> >>>> Supplier = S
> >>>> Product = P
> >>>> Quantity = 1
> >>>> 4) I approved and receipted the PO.
> >>>>
> >>>> So, the item inventory generated has:
> >>>> QOH = 1
> >>>> ATP = 1
> >>>>
> >>>> But, I thought that OFbiz convert 1 to 1000 when I receipted it.
> (table
> >>>> CONVERSION_UOM)
> >>>> QOH = 1000
> >>>> ATP = 1000
> >>>>
> >>>> I've seen that the table INVENTORY_ITEM not save the uom value in the
> >>> field
> >>>> UOM_ID but I not have seen where ofbiz save the oum in purchase order.
> >>>>
> >>>> Finally,
> >>>>
> >>>> Somebody knows how to manage uom conversions?.
> >>>> Do I have to configure something?
> >>>>
> >>>> Help me please?
> >>>>
> >>>> Than you.
> >>>>
> >>>>
> >>>> --
> >>>> Juan Pablo
> >>>> Cell 997204299
> >>>
> >>>
> >>> http://www.mindtree.com/email/disclaimer.html
> >>>
> >>
> >>
> >>
> >> --
> >> Juan Pablo
> >> Cell 997204299
> >>
> >
> >
> >
> > --
> > Juan Pablo
> > Cell 997204299
>
>
--
Juan Pablo
Cell 997204299
