fms problem

[Former Member]

hi kings

SELECT distinct T0.GrosProfit FROM ORDR T0 INNER JOIN RDR3 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.DocNum =150119

the above query is working...when i put the $[ordr.docnum] that time its not working what is the problem

SELECT distinct T0.GrosProfit FROM ORDR T0 INNER JOIN RDR3 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.DocNum =$[ordr.docnum]

Thanks & bet Regards

B.lakshmi Narayanan

[vijay_kumar1 · Accepted solution]

Hi Narayanan,

If you want to display the current gross profit value in the sales order header udf, the value

will be shown only when the document is added and press shift+ f 2 in the udf.

SELECT T0.[GrosProfit] FROM ORDR T0 WHERE T0.[DocNum] =$ ORDR.DocNum

Regards,

Vijay kumar

SAP Business One Forums Team