Skip to Content
author's profile photo Former Member
Former Member

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

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 19, 2012 at 08:05 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • author's profile photo Former Member
    Former Member
    Posted on Apr 24, 2012 at 10:09 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.