Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Creating new accounting periods for NAV 2017

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello,

I have created a new company for a client who said the beginning of operations is 2017, but later I found out it is actually 2016. I have already created 2017 and NAV does not allow to create 2016 anymore. No entries were maid. Is there any solution to this or I need to create a new company and start all over ?

*This post is locked for comments

  • Verified answer
    Ahmed Mohamed Rafik Profile Picture
    Ahmed Mohamed Rafik 3,049 User Group Leader on at
    RE: Creating new accounting periods for NAV 2017

    Hi GretaLT,

    First you need to delete the periods of 2017, and Create new year starting from 1/1/2016.

    You can do this by following these steps:

    1- Delete all 2017 Periods as they are all open except 1/1/2017 that is Date Locked & can't be deleted.

    2- Go to the Development Environment, Table 50 which is "Accounting Period".

    3- Click on Design Button to open the fields of the table.

    4- Open the Properties of the field "Date Locked".

    5- Search for Property "Editable" - Current Value set to: No

    6- Change the Current Value from No to Yes.

    7- Compile and Close the Development Environment.

    8- Restart NAV Server Administration.

    9- Open NAV Client.

    10- Go to "Accounting Periods"

    11- Delete the Period 1/1/2017 and it will be removed.

    12- Now you will be able to create new fiscal year 2016.

    If you find this solution helpful, Click Yes to Verify the answer to share with other community members and credit my solution.

  • Verified answer
    AJAnsari Profile Picture
    AJAnsari 5,754 on at
    RE: Creating new accounting periods for NAV 2017

    Hi Greta,

    The ‘new year will be closed automatically’ message you are seeing is not an error, but an informational / warning message. If you click Yes, it will continue and create the periods. And as I noted in my previous post, you can reopen closed periods later.

    That said, if your earliest period is 1/1/17, and you want to add periods from 1/1/14, my advice is to work your way back 1 year at a time (not required, but will give you a greater sense of control). So, first, create 1 year from 1/1/16, then 2015, then 2014.

    And yes, if you try to manually key in a date / accounting period prior to what’s currently the earliest accounting period, NAV won’t let you do that. That’s why I recommended using the function in the ribbon.

    If you are concerned about the consequences of doing it, I suggest going to the Companies page and using the Copy function to make a copy of the current company and trying it there first. That way, if you are not happy with the results, you can simply delete that copy of the company.

    I hope this helps. If my response has answered your question, please verify by clicking Yes next

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Creating new accounting periods for NAV 2017

    Hello,  when I try to create new year using a "NEW YEAR" function as you say I get an error message "The new fiscal year begins before an existing fiscal year, so the new year will be closed automatically." For me now the 1/1/2017 shows date locked. If I create a period 1/1/2014 manually is shows the value for date locked must be NO. (2017 is not closed, it just has 1/1/2017 as date locked)

  • Suggested answer
    AJAnsari Profile Picture
    AJAnsari 5,754 on at
    RE: Creating new accounting periods for NAV 2017

    Hi GretaLT,

    By default, you should be able to create periods prior to what you have in NAV. For instance, if you have Accounting Periods starting 01/01/17, you can still create a year from the "Create Year" function in the ribbon of the Accounting periods. Set the Starting Date to 01/01/16, No. of Periods to 12, and Period Length to 1M, and run the function.

    It will warn you that the periods will have to be closed (if 1/1/17 is closed), but as you know, you can reopen them later.

    The only real issue comes if you had an accounting period starting 1/1/17, and you accidentally created a year starting 1/1/15 (effectively, creating a one year gap of 1/1/16 to 12/31/16). Then, NAV will error out if you subsequently try to create the 2016 year. But you can have a developer temporarily override that code if it was just an oversight and you haven't posted anything to the system yet.

    I hope this helps. If my response has answered your question, please verify by clicking Yes next to "Did this answer your question?"

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,492 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans