Skip to Content
0
Former Member
Mar 10, 2009 at 02:45 PM

How to display qty total with different UOM using BEx query?

94 Views

Dear all,

I am working on BEx query. I am using 0IC_CO3 to create a query to show 0TOTALSTCK for the qty stock balance. I have 2 questions:

(1) Since our materials have more than one UOM and I donu2019t want to convert to one UOM, I want to show the total under different UOM. Currently the total line will show * because it adds up the qty with different UOM. Is anyway I can show the total under different UOM, like EA, LB, L, CAS for 0TOTALSTCK?

(2) I donu2019t want to convert the UOM and is anyway I can ignore different UOM to add up all qty with different UOM to show one number in the total line without UOM? pretty much like the LIS inventory analysis (MC.1) report to add up all qty regardless of UOM but it wonu2019t show the UOM at the total.

Thanks