web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

accidentally closed 2 fiscal years

(0) ShareShare
ReportReport
Posted on by 5,136

Hello Experts,

OUr accounting department inadvertently closed the 2020 and 2021 fiscal years in Accounting Period. We are using Nav 2013.  I know you cannot reopen closed fiscal year, unfortunately. 

So i need to reopen these fiscal years manually in the backend.  Have you guys ran into this kind of problem?  How did you reopen the fiscal year period?  E.g., is it just table 50 (accounting period) that we have to modify change value of Closed = False?  It seems too good to be true.  There must be more tables to modify.  This happened in our Consolidated company so it's tough coz i can't just restore a backup.  My other option is to manually blank out all consolidated company tables and replaced with the back up for these tables but that seems too far fetched.

Please help!

I have the same question (0)
  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    14,275 Super User 2025 Season 2 on at
    RE: accidentally closed 2 fiscal years

    the closing year does not do much in NAV. it is just tagging accounting period Closed = true.

    Changing the value to false from backend should fix your issue.

  • mbr Profile Picture
    5,136 on at
    RE: accidentally closed 2 fiscal years

    Thank you Teddy...However, I looked into the code and there's an event that gets triggered when you close the fiscal year.  I haven't fully traced the code but it seems like it's touching the financials data.  Hence, I hesitated to just simply set the value to false on the OPEN field.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,377

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,696 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,512 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans