Question Status

Suggested Answer
SarahB asked a question on 20 Feb 2015 3:23 PM

This question is being reposted as I am having the same problem that was asked about in the following 2012 thread. <http://community.dynamics.com/gp/f/32/t/72173.aspx>

Background to problem:

When trying to set up a new fiscal period through the Fiscal Periods Setup window, the year entered immediately populates first day and last day dates one year in the future. For example, 2015 populated a date range of 1/1/16 to 12/31/16. For our purposes, we need 1/1/15 to 12/31/15.

How does one run the SQL scripts and what SQL codes do I need to enter to get the needed date ranges for the fiscal year?

Reply
Suggested Answer
Mahmoud M. AlSaadi responded on 20 Feb 2015 3:28 PM

Don't consider SQL scripts for that, use the PSTL Fiscal Period modifier tool provided on the professional services tools library

Here is a references on how to use it Fiscal Year Modifier

Best Regards,

Mahmoud M. AlSaadi

Dynamics GP Essentials |   mahmoudsaadi.blogspot.com

Reply
Suggested Answer
Bill Campbell responded on 20 Feb 2015 4:04 PM

Mahmoud is absolutly correct, there is no good way to do this other than in the PSTL.

I know others have tried other solutions and I am pretty sure they all fail.

PSTL is the only, best answer.

Be sure as always, do a good solid backup first.


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

Bill Campbell
Director, Operations
M.I.S. Management Information Solutions Ltd.
Skype: billc.edmonton
Cell: +1 780 994 2455
Off : +1 780 481 5564

Reply
Suggested Answer
BABU BASKARAN responded on 20 Feb 2015 5:56 PM

Hi Sarah,

When you fix the fiscal period using PSTL it will remove all the fiscal periods, so please take a back up first.  After fiscal period removed re-create them again and run reconcile against financial from oldest year to current year and all should be just fine.

Best Regards,

Babu Baskaran

Financial Systems Manager

Please mark this as verified if it answers your question. Verifying the answer will help others who experience this same issue.

 

Reply
Suggested Answer
Somakarpagamoorthy Kanagasabapathy responded on 22 Feb 2015 12:37 AM

To re-create a fiscal period, please have a look on the below link.

support.microsoft.com/.../871789

Hope this helps!!!

Note: Please mark it as verified, if this answer your question. Because this will helps to some others who experience the same.

Best Regards,

Somakarpagamoorthy K | Microsoft Dynamics GP Consultant | Dynamics Thoughts

Reply
Suggested Answer
Somakarpagamoorthy Kanagasabapathy responded on 22 Feb 2015 12:58 AM

To change the Account Format with using PSTL, follow below link.

www.wipfli.com/BlogPost_GP_Blog_090514.aspx

Hope this helps!!!

Note: Please mark it as verified, if this answer your question. Because this will helps to some others who experience the same.

Best Regards,

Somakarpagamoorthy K | Microsoft Dynamics GP Consultant | Dynamics Thoughts

Reply
Bill Campbell responded on 25 Feb 2015 12:12 PM

SarahB, have you been able to resolve this matter to your satisfaction?

If so, you should either mark one of the answers as a solution, or provide the solution you used to get to your solution and close the case.


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

Bill Campbell
Director, Operations
M.I.S. Management Information Solutions Ltd.
Skype: billc.edmonton
Cell: +1 780 994 2455
Off : +1 780 481 5564

Reply
Suggested Answer
Mahmoud M. AlSaadi responded on 20 Feb 2015 3:28 PM

Don't consider SQL scripts for that, use the PSTL Fiscal Period modifier tool provided on the professional services tools library

Here is a references on how to use it Fiscal Year Modifier

Best Regards,

Mahmoud M. AlSaadi

Dynamics GP Essentials |   mahmoudsaadi.blogspot.com

Reply
Suggested Answer
Bill Campbell responded on 20 Feb 2015 4:04 PM

Mahmoud is absolutly correct, there is no good way to do this other than in the PSTL.

I know others have tried other solutions and I am pretty sure they all fail.

PSTL is the only, best answer.

Be sure as always, do a good solid backup first.


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

Bill Campbell
Director, Operations
M.I.S. Management Information Solutions Ltd.
Skype: billc.edmonton
Cell: +1 780 994 2455
Off : +1 780 481 5564

Reply
Suggested Answer
BABU BASKARAN responded on 20 Feb 2015 5:56 PM

Hi Sarah,

When you fix the fiscal period using PSTL it will remove all the fiscal periods, so please take a back up first.  After fiscal period removed re-create them again and run reconcile against financial from oldest year to current year and all should be just fine.

Best Regards,

Babu Baskaran

Financial Systems Manager

Please mark this as verified if it answers your question. Verifying the answer will help others who experience this same issue.

 

Reply
Suggested Answer
Somakarpagamoorthy Kanagasabapathy responded on 22 Feb 2015 12:37 AM

To re-create a fiscal period, please have a look on the below link.

support.microsoft.com/.../871789

Hope this helps!!!

Note: Please mark it as verified, if this answer your question. Because this will helps to some others who experience the same.

Best Regards,

Somakarpagamoorthy K | Microsoft Dynamics GP Consultant | Dynamics Thoughts

Reply
Suggested Answer
Somakarpagamoorthy Kanagasabapathy responded on 22 Feb 2015 12:58 AM

To change the Account Format with using PSTL, follow below link.

www.wipfli.com/BlogPost_GP_Blog_090514.aspx

Hope this helps!!!

Note: Please mark it as verified, if this answer your question. Because this will helps to some others who experience the same.

Best Regards,

Somakarpagamoorthy K | Microsoft Dynamics GP Consultant | Dynamics Thoughts

Reply