OFBiz › OFBiz - User

How to manage uom conversion

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

7 messages Options

Juan Pablo

How to manage uom conversion

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

David E. Jones-2

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

Abhai Chaudhary

RE: How to manage uom conversion

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

http://www.mindtree.com/email/disclaimer.html

Juan Pablo

Re: How to manage uom conversion

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

Re: How to manage uom conversion

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

David E. Jones-2

Re: How to manage uom conversion

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

Re: How to manage uom conversion

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