Skip to Content
0

UOM conversion of Material Quantity is coming wrong

Aug 08, 2017 at 02:03 PM

67

avatar image
Former Member

Hello Experts ,

I am trying to do material unit conversion to specifically to EA.

I have created unit conversion in RSUOM using reference as 0MATERIAL:

Infoobject level changes for 0MATERIAL are done as unit of measure = 0BASE_UOM and created DSO – UOM0MATE.

In Bex query, against KF properties, under conversion, I had selected conversion type and selected target unit as EACH.

Now in source, Quantity of material is 175.00 LB . This needs to converted to EA .

As per logic actual converted value should be 175 *(35/1)= 6125 . However actual quantity on report shown is 5 EA i.e. (175/35= 5 ).

Conversion factor as per UOM0MATE:

I am not sure why conversion performed is division instead of multiplication? Request you to help me on this urgently .

P.S : Unit of measure for Quantity KF to be converted is specified as 0OPER_UNIT. Will that make any difference ?

Thanks in advance!!

Swati

rsuom.png (15.6 kB)
bex-query.png (3.9 kB)
uom0mate.png (4.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Loed Despuig Aug 09, 2017 at 01:30 AM
0

Hi,

I can't validate this now but when I did the UOM conversion before, the actual formula is:

VALUE x (LB UOMZ1D / LB UOMN1D) x (EA UOMN1D / EA UOMZ1D)

So formula should be,

175 x (1 / 1) x (1 / 35) = 5 EA

You can also validate that formula using other values from your sample data.

Regards,

Loed

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks Loed for your response ..

For the material values conversion is happening with the same logic.

Thanks ,

Swati

1

You are very welcome Swati.

Regards,

Loed

0