How to SUM row fields for FMS?

[former_member461731]

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

[former_member514423 · Accepted solution]

SDK.

[kothandaraman_nagarajan]

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

[kothandaraman_nagarajan]

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

[former_member461731]

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