Fiscal Year Variant - Monthly to Weekly

[Former Member]

Hi All,

We have week definition Monday to Sunday. We have defined fiscal year variant in monthly buckets and for Fiscal year 2010 our January month starts with date 11/28/2009 and ends at 1/24/2010 and according to subsequent months.

Hence I have defined fiscaly year variant like....

FYV 2009

Month Day Period Year Shift

12 27 12 0

12 31 1 +1

FYV 2010

1 24 1 0

and so on.

With this setting, when I create planning bucket profile in monthly bucket (with posting period) I can see correct period in interactive planning with month starting with 12/28/2009 and ending with 1/24/2010.

But when I create planning bucket profile for weekly view it givesfirst week to previous year.

W53 - 12/28/2009 - 1/3/2009 (7 days) - this week goes t previous year instead of current year. which is incorrect

W1 - 1/4/2010 - 1/10/2010

Why this should happen? how can I get rid of wk 53 and bring that week in current year? any thoughts?

Regards,

Harshil Desai

Edited by: Harshil K Desai on Sep 3, 2010 9:02 AM

[Former Member · Accepted solution]

Hi Harshil,

Can you try by removing 12 31 +1 from FVY 2009. As per your FY the last day of 2009 would be 27th 12 2009. isn't it?

and also the posting period then wil not match as calendar year's posting period.It comes earlier so for 12 27, the value might be -1.

Can you try with above changes (may be one by one & later both at a time).

Best Regards,

Deepthi

[Former Member · Accepted solution]

Does not work...question...how can you cpomplete FY without date 12/31? without menioning last day of the calendar year system does not allow to save.

[Former Member · Accepted solution]

Hi Harshil,

Yes we cannot save FYV w/o year ending. So that option is ruled out.

How are you creating planning bucket profile for weeks? I tried with 'P' posting period and then displaying 12 periods of P of FYV in weeks...but not able to craete a profile like that...ending with error....5.

If you are creating normal weeks w/o reference to 'FYV' then it will display the usual calendar weeks.

As a final option, we need to create FYV for 53 weeks and then create a seperate TB profile attach to a planning book.

Hope this helps.

Deepthi