I have created an approval procedure for credit limit @ A/R Invocie with following query,
SELECT DISTINCT 'TRUE'
FROM OCRD T1
WHERE T1.CreditLine > 1 and T1.CreditLine < ($[$29.0.number] +T1.OrdersBal+T1.Balance) and T1.CardCode=$[$4.0.0]
it was working fine, but suddenly not prompting for approval.
General setting, approval template setting are set.
Can anyone help me figure this out?