Stock balance analysis
I have a requirement regarding material stock analysis.
For example-I have two stores in a plant.I want to see the stocks as well value of stock on a particular date suppose 25/06/2008 for a particular store.
-If i will use MC.9,it will show the opening balance of the starting of the month & closing balance also,as there is no date option.It will not also show the Stock transfer accounting as no accounting is done for it.
-If i will use MB5B,in this also It will not also show the Stock transfer accounting as no accounting is done for it.
-In MB52,it will show only reciept stock.
So apart from these, is there any Transction in which we can check the detail.Pls guide me.