Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Change fiscal periods
Microsoft Dynamics GP (Archived)

Change fiscal periods

(0) ShareShare
ReportReport
Posted on by Richard Wheeler 75,730
What is the best way to handle this change of fiscal periods? Current year is 10/1 - 09/30. So 2014 is defined as 10/01/2013 - 09/30/2014. The CFO has decided now to go with a calendar year but does not want 2014 to have 15 periods. So the question is to what to label the stub year of 10/01/2014-12/31/2014. 01/01/2015 - 12/31/2015 will be year 2015. We already have a year of 2014. So when I go to the Fiscal Period Setup screen what should I enter as the year?

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Change fiscal periods

    Thanks for this reminder. We will take this into consideration. This change has to happen so let's see how it goes.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Change fiscal periods

    We went through this a few years ago.  In our case we were changing from a 7/31 year end to 12/31 so we were going to use 1211 to end 12/31/11.  If I remember right everything in GP worked fine but we ran into an issue in FRx when trying to use the BASE function in columns to compare years.  BASE-1 from 1211 becomes 1210.  Unless it actually looks at the dates of the years this could also be an in issue in Management Reporter.  Now it might not matter since having a stub year causes problems when making comparisons anyway.  We had to set the columns in FRx manually when making comparisons to those years.

  • Verified answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: Change fiscal periods

    Has to be 4 numeric characters.  9914?

  • John Olley Profile Picture
    John Olley 365 on at
    RE: Change fiscal periods

    Well, that foils that plan! I didn't try it on my end. I should have before I suggested that. That makes sense though. Maybe 3014? 2114? I'm sure someone out there has a batter suggestion than I do.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Change fiscal periods

    I think it will need to be 214B. It will not let me enter more than 4 characters.

  • John Olley Profile Picture
    John Olley 365 on at
    RE: Change fiscal periods

    Do you have a test server? Try 2014B. I'm pretty sure that would work but test it first. Run GL, RM, SOP, POP, PM, ect transactions with that year and see how it looks in the GL. Run some reports too. Just remember that your reporting would have to look at year "2014B". I wouldn't use any special characters as SQL doesn't like them much. No dashes or things like that. 2014 and 2014B would remain "open" years until you did year end closing on them.

    Thanks,

    John Olley

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans