Skip to Content
0
Former Member
Jun 01, 2015 at 01:52 PM

Query for Credit limit approval

366 Views

Hello,

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?

Thankfully

Hari