UOM conversion of Material Quantity is coming wrong

[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

[Loed · Accepted solution]

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

[Former Member · Accepted solution]

Thanks Loed for your response ..

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

Thanks ,

Swati

[Loed · Accepted solution]

You are very welcome Swati.

Regards,

Loed