on 11-19-2008 7:52 PM
Dear experts,
In my company we are using DP forecasting weeks, starting on Saturday going through to Friday.
For 2008, I was able to set up my FY variant to deal with week 53 like this:
Month Day Week# Year shift
--> 2008: 12 31 53 0
--> 2009: 01 02 53 -1
--> 2009: 01 09 01 0
This gives me week 52/2008 - 20 dec til 26 dec
week 53/2008 - 27 dec til 02 jan
week 01/2009 - 03 jan til 09 jan
When continuing building 2009 and 2010... I'm geting stuck on week 52 of 2009
Month Day Week# Year shift
--> 2009: 12 31 52 0
--> 2010: 01 01 52 -1
--> 2010: 01 08 01 0
This should give me week 52/2009 - 26 dec til 01 jan
week 01/2010 - 02 jan til 08 jan
However, when trying to save FY variant for 2010, I get this error message:
Gaps in Fiscal Year Variant xx.
The period specification has gaps. The periods must be sequentially numbered without any gaps.
Does anyone have any ideas why?
FYI: here's my full 2010 definition:
2010
Month Day Week# Year Shift
1 1 52 -1
1 8 1 0
1 15 2 0
1 22 3 0
1 29 4 0
2 5 5 0
2 12 6 0
2 19 7 0
2 26 8 0
3 5 9 0
3 12 10 0
3 19 11 0
3 26 12 0
4 2 13 0
4 9 14 0
4 16 15 0
4 23 16 0
4 30 17 0
5 7 18 0
5 14 19 0
5 21 20 0
5 28 21 0
6 4 22 0
6 11 23 0
6 18 24 0
6 25 25 0
7 2 26 0
7 9 27 0
7 16 28 0
7 23 29 0
7 30 30 0
8 6 31 0
8 13 32 0
8 20 33 0
8 27 34 0
9 3 35 0
9 10 36 0
9 17 37 0
9 24 38 0
10 1 39 0
10 8 40 0
10 15 41 0
10 22 42 0
10 29 43 0
11 5 44 0
11 12 45 0
11 19 46 0
11 26 47 0
12 3 48 0
12 10 49 0
12 17 50 0
12 24 51 0
12 31 52 0
in 2008 week 53 should have 27th dec to 31st Dec...
It is fine if you donot have 7days a week.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
4 | |
3 | |
3 | |
2 | |
2 | |
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.