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
