Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

undo year-end closing

Posted on by Microsoft Employee

Is it possible to undo the  closing of a year if after closing it is discovered that the posting type for a major balance sheet account has been flagged as Profit and Loss?

 

*This post is locked for comments

  • RE: undo year-end closing

    And this was done without accessing the database or having any users log out of GP.

  • RE: undo year-end closing

    Absolutely!  I just encountered this very thing.  I followed these steps exactly and it worked like a charm!

    mbs2.microsoft.com/.../kbdisplay.aspx

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: undo year-end closing

    With Dynamics GP 2013 R2 you can accomplish this. GO To Microsoft Dynamics GP > Tools > Routines > Financial > Year End Closing and select 'Reverse Historical Year'.

    Have all users log out first. You can reverse multiple years - but you should reverse the most recent year first and work back. The original year end closing journal is deleted by this process...not voided. This process also reverses the Analytical Accounting year end if you are using AA.

    Ian.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: undo year-end closing

    It would be nice to be involved in such discussion. While the feature of reversing "Historical Year" is not a feature in previous versions of Dynamics GP prior to GP 2013 R2, it is definitely possible on the database level. The link provided by Babu is a corrective procedure that is considered why you close the year, while an account has been incorrectly defined in terms of the posting type (balance sheet / profit and loss).

    I have previously analyzed the technique considered by MS to do so in 2013 R2, here is Dynamics GP Essentials post on GP 2013 R2 – Reverse Historical Year . In brief, there is a stored procedure [GLReverseHistYear] in the company database which does the job. 

    Although, you should keep in mind that doing so is not a piece of cake, and should not be considered unless you have a consultant involved. Which is why calling Microsoft for this inquiry would be the easiest way out.

    Please never hesitate to share any further inquiries, 

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: undo year-end closing

    I'm not sure Babu.  However, the fact that reversing the Year End Close is now available in 2013 R2 and 2015 to me implies that they've known how to do this previously and have just now incorporated it in the application.

  • RE: undo year-end closing

    Hi Frank,

    I didn't know this is possible till now.  Is this done on database level.

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    RE: undo year-end closing

    Check with your Microsoft Partner.  I'm pretty sure Microsoft Support has the ability to reverse a year end close for you.

  • Suggested answer
    RE: undo year-end closing

    Hi Rogger,

    You can not undo year-end closing.  Changing posting type will be your options, please refer the KB article form Microsoft on the same.

    support.microsoft.com/.../864913

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans