Question Status

Verified
Josephine Tang asked a question on 2 Oct 2012 11:06 AM

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

Reply
Verified Answer
Josephine Tang responded on 3 Oct 2012 9:37 AM

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

Reply
Suggested Answer
Frank Hamelly responded on 2 Oct 2012 11:59 AM

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.

** Please, if this answers your question, mark it as 'Answered' so others experiencing the same will know it resolved your issue. **

Frank E. Hamelly, MCP-GP, MCP-AX, MCITP, MCT, MVP

http://gp2themax.blogspot.com/

Reply
Suggested Answer
Susan Conrod responded on 2 Oct 2012 2:26 PM

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.

Sue Conrod

Reply
Suggested Answer
Frank Hamelly responded on 2 Oct 2012 6:57 PM

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

** Please, if this answers your question, mark it as 'Answered' so others experiencing the same will know it resolved your issue. **

Frank E. Hamelly, MCP-GP, MCP-AX, MCITP, MCT, MVP

http://gp2themax.blogspot.com/

Reply
Suggested Answer
Frank Hamelly responded on 2 Oct 2012 11:59 AM

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.

** Please, if this answers your question, mark it as 'Answered' so others experiencing the same will know it resolved your issue. **

Frank E. Hamelly, MCP-GP, MCP-AX, MCITP, MCT, MVP

http://gp2themax.blogspot.com/

Reply
Josephine Tang responded on 2 Oct 2012 1:13 PM

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

Reply
Josephine Tang responded on 2 Oct 2012 1:34 PM

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.

Reply
Suggested Answer
Susan Conrod responded on 2 Oct 2012 2:26 PM

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.

Sue Conrod

Reply
Josephine Tang responded on 2 Oct 2012 2:36 PM

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

Reply
Suggested Answer
Frank Hamelly responded on 2 Oct 2012 6:57 PM

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

** Please, if this answers your question, mark it as 'Answered' so others experiencing the same will know it resolved your issue. **

Frank E. Hamelly, MCP-GP, MCP-AX, MCITP, MCT, MVP

http://gp2themax.blogspot.com/

Reply
Verified Answer
Josephine Tang responded on 3 Oct 2012 9:37 AM

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

Reply
Frank Hamelly responded on 3 Oct 2012 10:17 AM

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

** Please, if this answers your question, mark it as 'Answered' so others experiencing the same will know it resolved your issue. **

Frank E. Hamelly, MCP-GP, MCP-AX, MCITP, MCT, MVP

http://gp2themax.blogspot.com/

Reply
Josephine Tang responded on 3 Oct 2012 10:28 AM

Thanks, Frank.  Appreciated.  Have a good day.

Reply
Josephine Tang responded on 3 Oct 2012 1:32 PM

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

Reply