Skip to Content
0
Former Member
May 04, 2009 at 02:25 PM

Formatted Search syntax in UDF

32 Views

Good day

I have created siple formatted search to link a Sales Order number to the Incomming Payment header

SELECT T0.[DocNum] FROM ORDR T0 WHERE T0.[CardCode] = $[$5.0.0] and T0.[DocStatus] = 'O'

When I run the Formatted Search to the Reference field it works perfectly, but if i run it in a UDF on the header I get no result. Can you please tel me how the syntax must change to work in a UDF?

Erika Boshoff