Skip to Content
0
Former Member
Dec 05, 2008 at 06:42 AM

fms problem

15 Views

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