CREATE TRIGGER transactiontrigger ON ORDERINVOICE

AFTER INSERT

AS

BEGIN

UPDATE A_ACCOUNT

SET A_ACCOUNT.AC_RUNNING_BLC=

(A_ACCOUNT.AC_RUNNING_BLC - INSERTED.NETAMMOUNT + INSERTED.COMMISION - INSERTED.TDS)

FROM A_ACCOUNT INNER JOIN INSERTED ON A_ACCOUNT.A_ID = INSERTED.A_ID

END

GO