FI Fiscal Year Variant Scenario- (5-4-4)

[Former Member]

Hi All,

Actually i have a requirement for fiscal year.

How would you set this up in SAP? I have tried every possibility that i can think of but i am unable to do it, so i need a help from u all.

For 2011,

Period 1: June 27, 2010 to July 31, 2010

Period 2: Aug 01, 2010 to Aug 28, 2010

Period 3: Aug 29, 2010 to Sept 25, 2010

Period 4: Sept 26, 2010 to Oct 30, 2010

Period 5: Oct 31, 2010 to Nov 27, 2010

Period 6: Nov 28, 2010 to Jan 01, 2011

Period 7: Jan 02, 2011 to Feb 05, 2011

Period 8: Feb 06, 2011 to Mar 05, 2011

Period 9: Mar 06, 2011 to Apr 02, 2011

Period 10: Apr 03, 2011 to May 07, 2011

Period 11: May 08, 2011 to June 04, 2011

Period 12: June 05, 2011 to July 02, 2011

Important Notes:

1- I have to setup 15 fiscal years like these, but i can get the logic for just one, i can do the rest.

2- I have already tried every possible combinations based on V6, V9, etc but i am stuck at a point where i get the usual message that my periods are not in order. If i skip the itemized entry for 12/31/2010, then the error i am getting is that the key date of 12/31 is missing. Anyways, these are just foods for thought, i would like you to go about it in your own way and see if you can resolve it.

3- we have 12 regular periods as shown above and 4 special periods.

4- every year is a standard 5-4-4 schedule.

5- every period for every year starts on sunday and ends on saturday.

[Former Member]

Hi,

This is quite interesting. There are a few points that may be helpful to you:

• You have to assign a entire calendar year to fiscal periods. System always assumes you start with January 1st. But, for the end date December 31st you have to specify explicitly, otherwise you get that missing entry error
• For each entry, you specify the last day of the date range.

I will define FV for calander year 2011 as

Month     Day     Period          YShift

1               1          6               0

2               5          7               0

3               5          8               0

4               2          9               0

5               7          10             0

6               4          11             0

7               2          12             0

8               6          1             +1

9               3          2             +1

10             1          3             +1

11             5          4             +1

12             3          5             +1

12             31        6             +1

For 2012

1               7          6               0

2               5          7               0

So on and so forth.

Regards,

Ming

[Former Member]

Period   Interval       Shift

Period 1:  31 - 07      -1

Period 2:  28 - 08      -1

Period 3:  25 - 09      -1

Period 4:  30 - 10      -1

Period 5:  27 - 11      -1

Period 6:  01 - 01

Period 7:  05 - 02

Period 8:  05 - 03

Period 9:  02 - 04

Period 10: 07 - 05

Period 11: 04 - 06

Period 12: 02 - 07

Make it like this for FY 2011.

[Former Member]

Hi Yaduveer,

Can you explain why you have given year shift from the month of july? actually it should be from the month of january which comes in the next year right?

[Former Member]

Hi Yaduveer Singh,

I have seen your logic which you have shown above, but i am unable to understand why you have shown year shift from the month of July...? Can you explain your logic in detail from the starting to end so that i can have proper idea on it.

[Former Member]

Shift will come from july because when calender year is 2010 it should 2010 +1 = 2011.

thus ,

For date July 27, 2010 (calender date)

Posting info will be

period 01 as interval one is falling

year (calender year + shift) 2010 + 1 = 2011

Thus for this date = period 01 and FY 2011.

PS: "-" is not minus i put it to separate year shift from interval actual year shift is +1