Skip to Content
0
Former Member
Nov 21, 2008 at 12:41 PM

SP_Transaction notification for Cash account non negative value

23 Views

Hi I wrote the following SP_Transaction notification when cash account is going negative in outgoing payment.its working fine in 2005B.

But it is not working in 2007B.pl any one help me.

IF @transaction_type IN (N'A', N'U') AND (@Object_type = N'46')

BEGIN

if Exists ( select t0.currtotal from oact t0 inner join ovpm t1 on t0.AcctCode=t1.CashAcct

where t0.currtotal <=0 and t1.docentry=@list_of_cols_val_tab_del)

BEGIN

SELECT @Error = 1, @error_message = 'Cash account should not be negative!'

END

END

Edited by: ArulPrakasan P on Nov 21, 2008 1:42 PM