ALTER trigger [dbo].[tr_ledgerdelete] on [dbo].[BCDet]
after delete
as
begin
declare @dlcode int;
declare @ddc nvarchar(2);
declare @dAmt float;
SET NOCOUNT ON;
set @ddc=(select dc from deleted)
set @damt=(select amt from deleted)
if (@ddc='C')
begin
begin
update accmast set totcr=totcr-@damt where Lcode in (select Lcode from deleted)
end
begin
update accmast set clbal=totcr-totdr+opbal where Lcode in (select Lcode from deleted)
end
end
else
begin
begin
update accmast set totdr=totdr-@damt where Lcode in (select Lcode from deleted)
end
begin
update accmast set clbal=totcr-totdr+opbal where Lcode in (select Lcode from deleted)
end
end