How to solve opening and closing balance in c#

Hai,

 

Opening and Closing balance calculation is working correctly, But here I don't know how to set the opening balance automatically fetch on next day.  

 

Thank you. 

So where you stucked? What have you tried?

Hai,

 

Thank you for your reply,

 

 

here I am using  opening and closing balance as running calculation. now I want to show last day closing balance as next day opening balance automatically(where I will put closing to opening balance calculation).

Pavithra I think you need to use either a service or a database trigger. That service or trigger will fire on every morning & just take data from previous day "closing balance" column & put into current date "opening balance" column.

 

Please once go through below  link. This may help you:

 

http://stackoverflow.com/questions/22670593/closing-result-is-not-correct-in-acounts-opening-and-closing-balance-in-sql-quer

 

https://social.msdn.microsoft.com/Forums/en-US/2f344e85-22a1-4532-803c-a7446e821a30/stockinventory-calculations-with-openingclosing-balance?forum=vbgeneral 

 

http://www.codeproject.com/Answers/545384/Howplustoplusgetplusapluspreviouspluscolumnplusout#answer3 

 

 

 

If this is helpful for you then please accept my Answer.