on 04-14-2010 8:59 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you have to write a stored procedure for this.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.