Tis should at least send me a mail regardless of if statement.

Use ABCTRAINING

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

alter TRIGGER TAXPERCENT

ON [dbo].[AP101_VOUCHER_DISTR] AFTER insert AS

declare @VAT numeric(15,2),

@Total...

Hi,

Thanks for that. I changed it to this as vouchers contain many lines. The following works perfectly in man studio. I added it to my trigger, but nothing still...