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')
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)
SELECT @Error = 1, @error_message = 'Cash account should not be negative!'
Edited by: ArulPrakasan P on Nov 21, 2008 1:42 PM