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