topic UOM conversion not big enough in Application Development and Automation Discussions

UOM conversion not big enough

Former Member — Thu, 07 Aug 2008 16:41:05 GMT

Hey All,

I have a strange requirement. The numerator field UMREZ for UOM conversion is of 5 digits, which means the max value can be 99999. We have a need to do a Alterante UOM conversion which is greater than 5 digits.

Example: 1 PAL = 200000 EA.

How do I acheive this?

We are looking into all possible options.

First is thru config to create an intermediate UOM so that we can do two UOM conversions and acheive our result, but this is also going to be a big change.

Is there any other option through code to increase the length of this field, or any other alternative.

I tried searching and looking for OSS notes, but no luck.

Any input is highly appreciated.

Re: UOM conversion not big enough

Former Member — Thu, 07 Aug 2008 16:46:14 GMT

Hi,

Try extending the table by adding your own new UOM field with more length.

Do you conversion and store it in that field.

You can extend the standard screens to display this newly added field. Through config, you can hide the standard UOM field on the screen and display only the new custom field.

Regards,

Subramanian

Re: UOM conversion not big enough

Former Member — Thu, 07 Aug 2008 16:52:42 GMT

I did think about that option, but I was worried about the impact since this is used in so many modules. I am not concerned about the display, but how do I make all applications use the new custom field instead the standard???? Uom conversion is done almost everywhere.

Re: UOM conversion not big enough

Former Member — Fri, 08 Aug 2008 13:47:12 GMT

what about using a pre conv factor of 0.0001 on numerator and then a post-conversion factor of 10000?

Re: UOM conversion not big enough

Former Member — Fri, 08 Aug 2008 13:57:22 GMT

I am not sure I understand what do you mean by Pre conversion and post conversion factor. Can you Please clarify?

Re: UOM conversion not big enough

Former Member — Fri, 08 Aug 2008 14:07:20 GMT

Divide 200000 by 1000 as a conv factor before UoM conv, and then after the UoM conv is done, multiply the result by the conv factor.

Re: UOM conversion not big enough

Former Member — Fri, 08 Aug 2008 14:18:31 GMT

Thank you for your replies. For a moment I thought this might be an option, but the problem here is not that the quantity is too large. but that the conversion factor is too large.

Let me explain again.

I have one unit which has the following conversion.


1 Pallet = 3000000 Eaches.
Numerator = 3000000  "here is the problem, numerator field is only 5 digits
Denominator = 1

which means if i get say even 100 pallets as input it have to convert


 100 X 3000000/1 = 300000000.          "the problem is UMREZ (3000000) is too big for that field

So here i cannot use any preconversion or post conversion.

BUT if i do think in the same line i can try to use a multiplication factor for that particlar unit of measure which i can just multiply at the end. I can maybe look to incorporate this in an enhancement when the UOM conversion is done. But I still have to figure out how to display it in the material master. Let me investigate more into this option.

Any other suggestion as welcome.

Edited by: Aparna Shekhar on Aug 8, 2008 9:23 AM