Approval procedure on outgoing payment for Cash and bank transfer

[Former Member]

Dear Expert

I want to know about outgoing payment approval

Is it possible to set approval on payment means base ?

Like I need to set approval for my user

case 1 is : - If my user make payment by cash more then 5000 then approval it should be approved by manager

And if my user make a outgoing payment by cash more then 100000 then it should be approved by MD

Case 2 is If my user create outgoing payment by Bank transfer then more then 25000 then it should be approved by manager

And if it is by bank transfer more then 500000 then it should be approved by MD

IS it possible ????? Please guide me

Thanks

Riny

[kothandaraman_nagarajan · Accepted solution]

Hi,

Yes possible by means of query.

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Hello Sir

Thanks for reply , Well I created query and executed but its giving false value but when i attached this query on approval , Its not working ..

Please help me and also please comment on my another thread which is about No matching record found error

Thanks

[kothandaraman_nagarajan · Accepted solution]

Please post your query here to check.

[Former Member · Accepted solution]

Dear Nagarajan K,

I have the same issue. A client wants an approval procedure for payments done via cheque with limits.

case 1: cheque payment upto 50000

case 2: cheque payment above 50000

i tried using this query but it is approving all payment means."

CASE 1:SELECT DISTINCT 'TRUE' FROM OVPM T0 WHERE T0.[CheckSum] <=50000

CASE 2: SELECT DISTINCT 'TRUE' FROM OVPM T0 WHERE T0.[CheckSum] >50000

Regards,

Joel K.