Stock Movement using T-SQL and VB.net

Question

Dear Sirs,


I am developping  a stock management system which should give a stock movement report with Opening Stock,Purchases,Purchase Return,Sales Return,Closing Stock but I have a problem to take a closing stock for the last day and use it as the opening stock of today.


Please help, I will highly appreciate.