Need to get last 13 months data in report + last day of every month
I have a requirement to show last 13 months data in the report and it should show last day of every month for the last 13 months from the system date. There is no user entry variable. I know that we can do I_STEP =1, but can anyone give me a psuodo code so that it can be really helpful. I also tried offsetting but it is not catering the requirement..I saw in the communities that we have to do 13 customer exits. But that is not advised as per client.
If user executes report today, the report should be as follows.
Stock in transit Blocked stock
jan 2014 1000 2000
feb 2014 4000 2000
mar 2014 30000 5000
Jan 2015 (today) 9000 7000