Open Forum

Expand all | Collapse all

Reverse Year End - impact after JEs made

  • 1.  Reverse Year End - impact after JEs made

    Posted Oct 18, 2019 12:08 PM
    We just migrated our budget maintenance to GP and realize after closing the Year End (June 30 2019) that we are unable to post budget appropriation changes which are needed against the closed year. I read on here one hack is to load the change to the current year then modify the back-end tables, which I am not thrilled about. If we decide to reverse the year end, does anyone know what happens to the journal entries that have been created to the historical year since closing? Is there risk to reversing the year end close, posting the amendment changes and re closing the year now that weeks have past and many entries were made to history? Any other solutions to meet this need? TIA!!

    #YearEnd #GeneralLedger #Finance #GP2018and2018R2​​​​

    Allison McNally
    County of Albemarle
    Charlottesville VA
    Academy - Online Interactive Learning from Experts

  • 2.  RE: Reverse Year End - impact after JEs made

    Posted Oct 18, 2019 12:32 PM
    Hi Allison,

    From my simulation, the journal entry that got generated from the YEC procedure got 'removed':
    • performed the YEC... resulted to JE3537
    • able to query JE3537 in GL20000
    • reversed the YEC
    • the GL20000 query returned zero results for JE3537 
    You would want to simulate this process in a TEST company so you can 'preview' the result without having to test it our directly on your PROD.

    Additional info:
    For Microsoft Dynamics GP 2013 R2 (12.00.1745) and later versions, you can go to the Year End Closing Routine window and click on the button for Reverse Historical Year, verify the Year to Open displayed and click Process. The year will be reopened as if it was never closed in the first place, so you can change the posting type on the account and then run the Year End Closing routine again.

    KB - Year-end closing procedures for General Ledger in Microsoft Dynamics GP

    Ryan Galang
    BTP Technologies LLC

    Academy - Online Interactive Learning from Experts

If you've found this thread useful, dive deeper into User Group community content by role