Skip to Content

How to SUM row fields for FMS?

Dear Experts,

Is it possible to sum row fields before the add document?

SELECT SUM($[QUT1."U_BNS_OngMalT"]) FROM QUT1 T0 WHERE T0."DocEntry"=$[QUT1."DocEntry"] It doesnt work.

I also need smt like this for approval procedures

How it can be possible ?

Thanks,

Tenay

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 12, 2018 at 01:18 PM

    SDK.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11, 2018 at 02:05 PM

    Hi,

    Change field below query and then try

    SELECT SUM( T1."Quantity") FROM ORDR T0 INNER JOIN RDR1 T1 ON T0."DocEntry" = T1."DocEntry" WHERE T0."DocEntry" = $[ORDR."DocEntry"]

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11, 2018 at 03:02 PM

    I don't think we get before adding document. Because FMS is taking value from field which is displaying in the form.

    Add comment
    10|10000 characters needed characters exceeded