TSQL Calc Cost of goods Sold with the three method FIFO ,LIFO ,Avg

I Use Sql server 2012 I have ERP System and I need to calc FIFO,LIFO and Average cost in for the inventory Item I have 4 types of transaction 'IN' (Purchase) ,'OUT' Sale ,'INR' Returned Purchase , ''OUTR' for Sales return Database Structure - Items Table ( Has ItemID, And ItemID and Calculation Method ) -Transaction Table (has ItemID,Date,Qty,Price,TransactionCode) I need To calculate the Avg ,Fifo And Lifo after any Update or save in the Transaction table because all data depened on the Transaction Date , for example After Purchase ID ItemID Qty Price TransCode CurrentQty CurrentValue 1 1000 10 10 IN 10 100 2 1000 10 20 IN 20 300 If In FIFO 3 1000 6 0 Out 14 240 If In LIFO 3 1000 6 0 Out 14 180 If In Avg 3 1000 6 0 Out 14 210 the Problem Will happen If the Customer Need to Delete the Transaction With ID=1 then I must re Calc All Rows again depend to the change , and this need very fast TSQL Code