Skip to Content
0
Former Member
Apr 22, 2014 at 07:21 AM

Approval Query for Outgoing Payment

306 Views

Hi All Experts,

I have to Create Approval for Outgoing Payment where payment means is Cash,Cheque or Bank Transfer but not Credit Card.

In other words approval should be raised for all payment means other than Credit card payment means.

For which I have Created Query as follows

select Distinct 'true' FROM dbo.OVPM T0

Left join dbo.VPM3 T1 on T0.DocEntry=T1.Docnum

WHERE T0.CreditSum=0 And T1.CreditAcct is null

payments goes for approval but Credit Card payment also goes for Approval which is not required.

Please Help me to Correct the Query.

Regards,

Gayatri Shukla.