How can I correct fiscal periods through the SQL scripts?

(0) Share

Report

Posted on by SarahB

215

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?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: How can I correct fiscal periods through the SQL scripts?

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

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report

RE: How can I correct fiscal periods through the SQL scripts?

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.

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

RE: How can I correct fiscal periods through the SQL scripts?

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.

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

RE: How can I correct fiscal periods through the SQL scripts?

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

support.microsoft.com/.../871789

Hope this helps!!!

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

RE: How can I correct fiscal periods through the SQL scripts?

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

www.wipfli.com/BlogPost_GP_Blog_090514.aspx

Hope this helps!!!

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

RE: How can I correct fiscal periods through the SQL scripts?

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.

Was this reply helpful? Yes No