I need query for approval procedure to block sale order if a UDF field in BP master is null.
Thanks and regards,
Unnikrishnan Balan replied
Please try below query.
I made small change in MG S's query and its working fine in my system.
SELECT distinct 'TRUE'
FROM OCRD T0
INNER JOIN ORDR T1 ON T0.CardCode = T1.CardCode
WHERE T0.CardCode= $[$4.0.0] and Len(isnull(T0.U_CL,''))=0