cancel
Showing results for 
Search instead for 
Did you mean: 

how do you stop outgoing payment of 5000 cash type transaction

former_member418241
Active Participant
0 Kudos

hi all,

if a cash payment is more than 5000 to a vendor in a single day it should be stopped? how do you achieve this?

thanks

SV Reddy

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Paste below code in SBO_SP_TransactionNotification Procedure

DO ON TEST DATABASE.


IF (@object_type = '46' AND @transaction_type in (N'A', N'U') )
BEGIN
IF EXISTS (SELECT T0.[DocTotal] FROM OVPM T0  INNER JOIN VPM4 T1 ON T0.DocEntry = T1.DocNum
WHERE ( T0.[DocTotal]  >  5000) AND T0.DocEntry = @list_of_cols_val_tab_del) 
BEGIN
Set @error =1
set @error_message = 'Pay More'
SELECT @error , @error_message 
END
END

Thanks

Kevin

former_member196081
Active Contributor
0 Kudos

you have to write a stored procedure for this.

former_member418241
Active Participant
0 Kudos

hi Thyagi

how do you write and what conditions you need to consider for it?

former_member196081
Active Contributor
0 Kudos

condition are following...

1,choosed account should be checked as cash account.

2, amount should be greater 5000.

for stored procedure contact ur technical consultant