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
    avatar image
    Former Member
    Jan 12 at 01:18 PM

    SDK.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11 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

    • Hi,

      thanks for your answer but it works for saved document. I need before the add document. Do you think is it possible ?

      Regards,

      Tenay

  • Jan 11 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