If a fiscal year has been accidentally closed within the Account Period in NAV, is there a way to reopen the year?

More Information

Unfortunately, there is not a reopen or undo option within the Account Period similar to what you would see within the Inventory Period window. Within the base application, once you close the year by clicking the Close Year button, you will be unable to make the changes to the Accounting Periods. This prevents companies from changing their fiscal year data AFTER the year has been closed.

At this point, the best AND ONLY supported option would be to restore to a backup prior to the year being closed. Also I would recommend taking away permissions to the Account Period to any user that should not be closing or changing any of the year setup.

If that is not an option, then you could do the following. HOWEVER, this IS NOT a supported way since you will be doing data manipulation. This would be just a general guideline of what you could do.

1. Was Close Year the only option you completed? If yes, then you can refer to steps B-E.
2. If the user did run the additional step of Close Income Statement process, after the Close Year was done, were the entries from this batch posted?

If the entries WERE NOT posted, then you can refer to steps A-E.

If the enteries WERE posted, then restoring to a backup prior to this occurring is your only option. Reason being is you not only would have to manipulate the Account Period setup but also several entries as they are the C12/31/xxxx type of closing entries. It would be a lot of work trying to change these entries as well as making reversing entries to get your accounts back to where they were prior to the close(i.e. balance sheet vs. income statement accounts doing the reversal etc..). This is also NOT SUPPORTED when data manipulation of this type is done.

A. Delete the close income statement batch job that currently exists
B. Through the object designer, you will need to edit table 50 Accounting Period so that the following fields have the option of editable set to yes

Date Locked

C. Once step B is completed, then you will need to open the Account Period form and manually unmark all periods for the Closed field within the year that SHOULD NOT have been closed.

D. Next you will unmark all Date Locked periods within the incorretly closed year EXCEPT the first period. If you are going based on calendar year, then an example would be 01/01/2010. This should have the New Fiscal Year Marked, Closed field unmarked and Date Locked marked.

**NOTE: This is assuming that the prior year, in this example it would be 2009, has already been officially closed. Otherwise the Date Locked would not yet be marked for 01/01/2010. The best and recommended option would be to compare what the setup was PRIOR to the Close Year being done to verify the new settings are correct IF restoring to the backup is not an option**.

E. Once all prior steps are completed, then NAV should be back at a point of where you were prior to the 2010 being closed.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!