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).
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.
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?
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.
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.
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
yes Josephine, you will find the .glx file in the SysData folder.
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.
Looks good Josephine. Good luck and let us know if you run into any issues.
Thanks, Frank. Appreciated. Have a good day.
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.
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