Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

How to change Calendar year fiscal period to 4-4-5 period in GP?

Posted on by 240

Hi,

How to change Calendar year fiscal period to 4-4-5 period in GP?

We are using Dynamics GP 2010 version.  Currently, our fiscal period setup is used Calendar year. First day from 1/1/2012 to Last Day of 12/31/2012.  Our plan is to change from Calendar year to 4-4-5 period in GP.  The 4-4-5 period will be ended as 12/29.  However, the current setup, the last day of 2012 year will be on 12/31.  How can we change our fiscal period setup to 4-4-5 period within the fiscal year of 2012 (We are still transact in fiscal year of 2012). 

Thanks,

Josephine

*This post is locked for comments

  • Josephine Tang Profile Picture
    Josephine Tang 240 on at
    Re: How to change Calendar year fiscal period to 4-4-5 period in GP?

    Hi Frank,

    Sorry for posting more question.

    I just got an update requirement.  Since our comapny is acquired by other comapny.  Our company is in Caleandar Year in 2012 (Jan to Dec).  The acquired company would like to ask us to change he Q4 period next week (Oct 12, 2012).  Their Q4 period is from Oct 12 to to Dec 20, 2012.  Since we are in Calendar year staritng January this year, how can we change the period in order to pull Q4 data from the date range of Oct 12 to Dec 29?  Please advise

    Below is the FY2012 and FY2012 schedule.  

    Thanks,

    Josephine

    ==================================================================

    Change First Day and Last Day for the Fiscal Year of 2012

    • The first date:  10/12/2012

    • The last date:  12/29/2012

    .

    Change First Day and Last Day for the Fiscal Year of 2013

    • The first date:  12/30/2012

    • The last date:  12/28/2013

  • Josephine Tang Profile Picture
    Josephine Tang 240 on at
    Re: How to change Calendar year fiscal period to 4-4-5 period in GP?

    Thanks, Frank.  Appreciated.  Have a good day.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: How to change Calendar year fiscal period to 4-4-5 period in GP?

    Looks good Josephine.  Good luck and let us know if you run into any issues.

  • Verified answer
    Josephine Tang Profile Picture
    Josephine Tang 240 on at
    Re: How to change Calendar year fiscal period to 4-4-5 period in GP?

    Thanks, Frank.   To wrap up my questions.  

    Step 1: We do need to change the fiscal period (from Calendar to 4-4-5) , we need to reset the first date and last day and change the beginning date in Fiscal Period (from Period 1 to Period 12)

    • The first date:  12/XX/2012

    • The last date:   12/XX/2013

    Step 2:  Need to run the Financial Reconcile

    Step 3:  remove the .glx file from SysData from FRx program folder

    Step 4:  We can do a year-end close for 2012

    Please confirm if the above steps are correct.

    Thanks,

    Josephine

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: How to change Calendar year fiscal period to 4-4-5 period in GP?

    yes Josephine, you will find the .glx file in the SysData folder.

  • Josephine Tang Profile Picture
    Josephine Tang 240 on at
    Re: How to change Calendar year fiscal period to 4-4-5 period in GP?

    Thanks, Susan,

    How can I find the .glx files in FRx, Is it in program file-->FRx-->SysDate folder? This .glx file needs to be removed after I have done the change and reconciled in GP.

    I'd appreciate if you can let me know where I can find the .glx file.

    Thanks a lot

    Regards,

    Josephine

  • Suggested answer
    sueconrod Profile Picture
    sueconrod 335 on at
    Re: How to change Calendar year fiscal period to 4-4-5 period in GP?

    FRx will reflect the same periods.  But do a drop on the .glx files after you have done the change and reconciled in Great Plains.  Then your preriods will be reflected in Frx.  Also, do this before year end or GP will not allow you to have an overlap 12/30 will be your first day in the 2013 year.  And you can't have it in two calendars at the same time.

  • Josephine Tang Profile Picture
    Josephine Tang 240 on at
    Re: How to change Calendar year fiscal period to 4-4-5 period in GP?

    Should we change the 4-4-5 period before performaning the 2012 year-end close in system?  Or we should change it prior to year-end close of 2012? Please advise  Thanks for your help.

  • Josephine Tang Profile Picture
    Josephine Tang 240 on at
    Re: How to change Calendar year fiscal period to 4-4-5 period in GP?

    Thanks, Frank.  Does the FRx report reflect the correct period as well once we change the fiscal period to 4-4-5 for fiscal year of 2012?

    Thanks,

    Josephine

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: How to change Calendar year fiscal period to 4-4-5 period in GP?

    Josephine, you'll need to change the beginning dates in Fiscal Period Setup for each of your fiscal periods for 2012 and then run the Reconcile routine on your new fiscal periods.  Running Reconcile ensures that transactions fall in the correct date ranges based on their transaction dates.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans