on 02-02-2015 11:17 AM
Hello Experts,
I am using fiscal year variant (FW) in which 4 periods exist for any month. Whenever I open the planning book, I will have to see only these 4 periods of the current month and Initial bucket.
I have a macro, that should be executed for all these 4 periods of the current month at any time during the month.
(aggregated sum of forecast of period 1 and 2 will be shown in bucket 2. aggregated sum of period 1,2 and 3 are shown in bucket 3, etc)
So, I have designed the time bucket profile with past as 1 month of Fiscal year variant FW and future of 1 month of Fiscal year variant.
My time bucket profile is 1 month - split into 4 periods of fiscal year FW.
1) The macro runs fine if the current system date lies in the second period through fourth period. But during the beginning of the month, when it is in the first fiscal period of month, it displays past 4 periods as 4 periods of previous month and 4 future periods of current month. I just want to display all buckets or periods of current month only. How can I achieve this?
2) So, during first week of the month, my macro runs only for past 4 periods and not for future 4 periods. But I want to run only from 1st period of current month till last period of current month. How to achieve this? Is there any macro function to overcome this? Or is there any standard configuration to avoid this problem?
Thanks,
Suresh
Hello,
For the benefits of the others consultants, please indicate the good or the helpful answer!
Thanks, Marius
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Surech,
In the planning book design, select check box "Visible" and choose the date from when you want to be visible the data in your planning book.
Thanks.
Regards, Marius
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Marius,
Thanks again. But, the macro code that I write, should be executed from the first period of current month to the last period of current month, even though, if the current system date is in the third period of the current month.
Also the interactive planning grid should show all the periods of current month as visible, even though I'm not in the first period of current month.
Thanks and Best Regards,
Suresh
User | Count |
---|---|
7 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.