materials with stock in a month
I have to create a report plant wise and month wise for the no. of materials with stock without physical inventory, materials with phy. inventory.for each month in the selection screen.
Main problem i am facing is, user want to freeze the report values before the current month as every month stock gets changed. means if in june we have 100 materials with stock without phy.inventory in july we have 100 materials with stock without phy.inventory and in current month we have 120 materials with stock without phy.inventory, then report should display.
june2007 - 100
july2007 - 100
but how we can freeze a report in previous data, i am selection materials from MARD.
please help me for this, if any code relatet to this it will be helpful.