Shortcut Icon to connect to a specific Database NAV 2009 RTC / NAV 2013

,
Shortcut Icon to connect to a specific Database In NAV 2013 & NAV 2009 we can give out Shortcuts in Windows different parameters in order to automatically open a default Database / Company.Typically this can be used for Test System…

Object Designer: Install Objects (.fob files)

,
Object Designer: Install Objects (.fob files)1. Open the Microsoft Dynamics NAV Classic Client (SQL if applicable).2. Open the Database3. Shift-F12 or Tools >> Object Designer4. File >> Import >>…

Posting Date is not within your range of allowed posting dates.

,
Posting Date is not within your range of allowed posting dates. This error is caused when your Posting Date Range and the Posting Date on the document you are trying to post do not correspond with each other. I…

AutoSplitKey / The Line Cannot be Split

,
AutoSplitKey / The Line Cannot be SplitThis is an error caused by trying to insert/create too many lines in between existing lines. The solve this you can either: 1. Insert the new record at the end of the table. 2.…

The Reservation Entry Does Not Exist

,
The Reservation Entry Does Not Exist  Reservation Entries can cause a lot of issues in NAV (all version). Sometimes the Reservation Entry table can have duplicate reservations against a single item (same Source ID - Doc No.) and as a…

Create a Dataport

,
Create a DataportDataports are used when you want to export or import a lot of information from a specific table rather than doing it manually. As a result we can process thousands of lines of information extremely quickly - which can be…

Scheduled BAT file to check if a Service has Stopped / Restart if Stopped

,
Scheduled BAT file to check if a Service has Stopped / Restart if StoppedSometimes services will stop without our control, which can cause the knock on affect of bringing your whole system to a halt. The best example of this is if our NAV…

Kill a 'hung' service / 'Stopping' Service via CMD

,
Kill a 'hung' service / 'Stopping' Service via CMDSometimes we will encounter times when a service is stuck in a 'Stopping' state, even if we right click the service to stop it, it will remain in a 'Stopping' state indefinitely. The two…

Delete All Users from NAV 2013 - SQL

,
Delete All Users from NAV 2013 - SQLSometimes we will need to delete all of our users from a NAV 2013 database as we may inadvertantly lock ourselves out or experiences glitches with user accounts. A quick way to delete all users from…

How to Create a NAV 2013 RTC Service

,
How to Create a NAV 2013 RTC ServiceTo create a NAV 2013 RTC Service you must first have the NAV 2013 client / development client installed on the middle tier server you are going to use. As a result of having the development environment…