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 < [email protected]> 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:[email protected]] > Sent: Thursday, February 11, 2010 12:45 AM > To: [email protected] > 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
