InventoryItem QOH/ATP missing Unit of Measure

[Bob Morley]

Does anyone know of a good reason why the InventoryItem (and many other entities) that deal with quantities does not have a Uom?  I referenced the Data Model Resource Book volume 1 and even though it says that an Inventory Item could represent 100 reams of ... it only stores the 100 as the quantity not the reams.

This is important for us because we will model a raw material of "gold" which can be purchased/sold in ounces or pennyweight (I think that is what she said).  While a particular enterprise may select a standard unit of measure, they could certainly create POs from suppliers that use a different Uom.  One would think that Ofbiz would handle this and use the UomConversion entity to do the conversion when it creates the InventoryItemDetail records.

Anyone have any opinions?  This would be quite a large change so I don't want to bite this off at this moment, but I could capture any resolution into a JIRA for future considerations.

[Scott Gray-2]

The first thing I would suggest doing is searching for previous discussions in the mailing list archives, I can't help but feel that the uom topic has been discussed at least a million times (maybe more).

Regards
Scott

On 8/04/2010, at 12:11 PM, Bob Morley wrote:

>
> Does anyone know of a good reason why the InventoryItem (and many other
> entities) that deal with quantities does not have a Uom?  I referenced the
> Data Model Resource Book volume 1 and even though it says that an Inventory
> Item could represent 100 reams of ... it only stores the 100 as the quantity
> not the reams.
>
> This is important for us because we will model a raw material of "gold"
> which can be purchased/sold in ounces or pennyweight (I think that is what
> she said).  While a particular enterprise may select a standard unit of
> measure, they could certainly create POs from suppliers that use a different
> Uom.  One would think that Ofbiz would handle this and use the UomConversion
> entity to do the conversion when it creates the InventoryItemDetail records.
>
> Anyone have any opinions?  This would be quite a large change so I don't
> want to bite this off at this moment, but I could capture any resolution
> into a JIRA for future considerations.
> --
> View this message in context: http://n4.nabble.com/InventoryItem-QOH-ATP-missing-Unit-of-Measure-tp1777324p1777324.html
> Sent from the OFBiz - Dev mailing list archive at Nabble.com.

[Bob Morley]

Scott Gray-2 wrote

The first thing I would suggest doing is searching for previous discussions in the mailing list archives, I can't help but feel that the uom topic has been discussed at least a million times (maybe more).

Duh I violated the first principle!  I will refer myself to http://n4.nabble.com/New-field-to-specify-the-internal-uom-of-products-td171281.html#a171281.

Thanks ;)

[David E. Jones-2]

The inventory units come from the product, specifically the  
quantityIncluded and quantityUomId fields.

-David


On Apr 8, 2010, at 13:11, Bob Morley <[hidden email]> wrote:

>
> Does anyone know of a good reason why the InventoryItem (and many  
> other
> entities) that deal with quantities does not have a Uom?  I  
> referenced the
> Data Model Resource Book volume 1 and even though it says that an  
> Inventory
> Item could represent 100 reams of ... it only stores the 100 as the  
> quantity
> not the reams.
>
> This is important for us because we will model a raw material of  
> "gold"
> which can be purchased/sold in ounces or pennyweight (I think that  
> is what
> she said).  While a particular enterprise may select a standard unit  
> of
> measure, they could certainly create POs from suppliers that use a  
> different
> Uom.  One would think that Ofbiz would handle this and use the  
> UomConversion
> entity to do the conversion when it creates the InventoryItemDetail  
> records.
>
> Anyone have any opinions?  This would be quite a large change so I  
> don't
> want to bite this off at this moment, but I could capture any  
> resolution
> into a JIRA for future considerations.
> --
> View this message in context: http://n4.nabble.com/InventoryItem-QOH-ATP-missing-Unit-of-Measure-tp1777324p1777324.html
> Sent from the OFBiz - Dev mailing list archive at Nabble.com.

[Bob Morley]

David E Jones-4 wrote

The inventory units come from the product, specifically the  
quantityIncluded and quantityUomId fields.

Thanks David -- this was foolish on my part (twice); it should have occurred to me modeling the Uom on the inventory would give you lots of inconsistent Uom problems and second I should have done a quick search on the forum.  Bah!

My speculative guess would be when doing POs in Ofbiz you are currently forced to adhere to the Uom set on the product.  Thinking that without a Uom on the OrderItem it would have to either force you into that Uom or the ShoppingCart would have to invoke a conversion as part of makeOrderItems.  No response necessary, I can look into this when I get some time.