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