STOCK CLOSING SQL SCRIPT
select * from [LMC2014-15].dbo.stock_rep ORDER BY 1
select * from [LMC2015-16].dbo.item ORDER BY 1
UPDATE [LMC2015-16].dbo.item SET [LMC2015-16].dbo.item.OPEN_QTY=0
UPDATE A
SET A.open_qty = B.Qty_in_hand
FROM [LMC2015-16].dbo.item A, [LMC2014-15].dbo.stock_rep B
WHERE A.item_CODE = B.item_code
UPDATE [LMC2015-16].dbo.item SET [LMC2015-16].dbo.item.AMOUNT=[LMC2015-16].dbo.item.OPEN_QTY * [LMC2015-16].dbo.item.COST_RATE
Comments
Post a Comment