Sales order availability

Dear all,

I am developing a report which is a day-wise report, where

I need to display the opening stock as on date that is the closing stock for yesterday if he is running the report today morning u2013 MMBE can help?

And second is the production stock as on date

The report will display the closing stock & production stock for yesterday when the user runs the report today.

Please can anyone guide me on this?