Custom Approval Query
Does anyone have an idea of why this is not working?
SELECT 'TRUE' from ORDR a INNER JOIN OCRD b on a.CardCode = b.CardCode
where a.DocNum = $[$8.0.0] and ($[$29.0.number] + b.Balance) > b.CreditLine
I am testing this because there are other criteria I have to out in the where clause. But, I cannot B1 to trigger this approval.
If I run this after the Sales Order is added, the query appears to be working, I get TRUE as my result. Running 2007A PL38.