Skip to Content
0
Former Member
Apr 10, 2014 at 01:52 PM

Help with SQL Query in Universal Function

746 Views

Hi - I have added a function button (Using Boyum) to BP Master Data. I want it to show me all AR DownPayment invoices for that particular BP. I saved the following SQL in a Universal Function:

SELECT T1.[DocNum], T0.[CardName], T0.[CardCode], T1.[DocDate], T1.[NumAtCard],

T1.[DocStatus]

FROM ODPI T0 INNER JOIN DPI1 T1 ON T0.CardCode = T1.CardCode

WHERE T0.[CardCode] = $[$5.0.0]

FOR BROWSE

But get this error:

Invalid query tree [300-33]. The SQL error is 8180: SQL: SELECT T1.[DocNum], T0.[CardName], T0.[CardCode], T1.[DocDate], T1.[NumAtCard],

T1.[DocStatus]

FROM ODPI T0 INNER JOIN DPI1 T1 ON T0.CardCode = T1.CardCode

WHERE T0.[CardCode] = 'test'


(Please note 'test' is the CardCode of the BP)


Advice is appreciated!


Thanks