Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.