cancel
Showing results for 
Search instead for 
Did you mean: 

Query for Credit limit approval

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please check this thread,

Thanks

Former Member
0 Kudos

hi,

can i have ur email id, need to share some screenshots!! got few queries

Former Member
0 Kudos

Hello Nagarajan,

Thank you  for your reponse.

I tried your query, since my requirement is only for AR Invoice, I changed ORDR to OINV & tested it. It dint activate the approval procedure.

Additionally, I tried using your query as it is in SO/AR Invoice. system is showing the regular warning message & continues to save the document.

Please note, I tried with manager & logistics license

Former Member
0 Kudos

hi hari,

how can see the records in a table in sap business one,,, any table for that matter

Former Member
0 Kudos

Hi Hari,

Do you have any new updates to the database such as a new SP_TN to block something?

Thanks,

Gordon