Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How can I correct fisc...
Microsoft Dynamics GP (Archived)

How can I correct fiscal periods through the SQL scripts?

(0) ShareShare
ReportReport
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

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    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.

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    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!!!

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    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!!!

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    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.

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    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.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    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

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans