Skip to Content
avatar image
Former Member

UOM conversion of Material Quantity is coming wrong

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 09, 2017 at 01:30 AM

    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

    Add comment
    10|10000 characters needed characters exceeded