FMS Correction into SAP B1

[nikunjmehta2290]

Dear team,

SELECT $[RDR1.U_PriceAfter] - (SELECT SUM(T0.VatSum) FROM RDR1 T0 WHERE T0.DocEntry = $[RDR1.DocEntry])

I need to minus VATSUM from the row level UDF named : U_PriceAfter

Please advice on it.

Regards,

Nikunj Mehta

[williamwachholz]

Hello,

It seems to me that this is Formmated Search syntax, so you can get all the information directly from the matrix, like this:

SELECT $[$38.U_PriceAfter.0] - $[$38.82.0] FROM DUMMY

Best regards