Dynamics NAV Idle Time Setup (Windows Client)

Dynamics NAV Idle Time Setup (Windows Client)

Hi Everyone,

Today we will demonstrate you, how to set idle time in Dynamics NAV for windows client. 

As we all understand, most of the companies need a cost effective ERP solution today and the number of license purchased by the company can be very limited. 

If any user has logged in to the system but doesn't do any work, another user will not be able to work because Dynamics NAV will give an error restricting the user log in as all licenses are in use at that time.

So the solution for this issue is setting up a maximum idle time for the client. Therefore, if any user is logged in but not using the system, the system will automatically end the session of the user.


The first step is to open Dynamics NAV 2017 Administration.

Then you have to select the instance that is been used currently.

The go to the client services tab --> idle time out --> Edit

Type the time out in following format (hh:mm:ss) > Save

Example: For a time out after 15 mins of idle time, you have to set the time as below,

Once the time is set, select the server and restart the server (By clicking right button of the mouse)

Thank you.

Have a good day. 😊

Thil.

SQL Authentication on Microsoft NAV Server Instance

SQL Authentication on Microsoft NAV Server Instance

Hi Allllll,

This topic describes how to configure SQL Authentication on Microsoft NAV Server Instance using Microsoft Dynamics NAV Server Administration tool.
When using SQL Server authentication, Dynamics NAV requires an encryption key to encrypt the credentials(Username and password) that the Microsoft Dynamics NAV Server instance uses to connect to the Dynamics NAV database in SQL Server. The encryption key must be installed on the computer where the Microsoft Dynamics NAV Server is installed and also in the database in SQL Server.

To do that, first you must delete the existing key file, if any. Here I am going to configure SQL authentication for the “DynamicsNAV101” instance.

1. Go to the following path and delete the relevant key file. (Here, ProgramData is a hidden folder).

C:\ProgramData\Microsoft\Microsoft Dynamics NAV\100\Server\Keys

2.     Open the Microsoft Dynamics NAV Server Administration tool.

click Start, enter Microsoft Dynamics NAV Administration in the Search textbox, and then choose the related link.

3. In the console tree, which is in the left pane, expand the node for the computer that contains the Microsoft Dynamics NAV Server instance, and then select the Microsoft Dynamics NAV Server instance.    

4. In the Actions pane, choose Database Credentials.

       5. On the Database Credentials page, click the Edit button.

6. Set the Database Authentication Mode to SQL Server Authentication.
7. In the Database User Name field, type the login name for the database user that you want to use to access the Microsoft Dynamics NAV application database in SQL Server.
8.  In the Password field, type the login password for the database user that you want to use to access the Microsoft Dynamics NAV database in SQL Server.

Add caption

      9. Click Save button, and then click OK button on the Enable Encryption on SQL Server Connections dialog box.

   10. On the Information dialog box about encryption, again click OK button.

11. Click the root of the console tree, which is in the left pane.

12.If the instance is  stopped, then Start it. If the instance is running then Restart it. Also make sure that the server instance is in the Running status all the time.

Thank you.
Chameera

Change Log - Dynamics NAV

Change Log - Dynamics NAV

Hello All,

In this post, we will be explaining how the change log in Dynamics NAV works. As we all agree,  proper user activity tracking is an important aspect to consider when selecting an ERP system. The administrators should be able to locate the changes and the errors in data from masters to day to day journal entries. 

Dynamics NAV provides the capability to track the modifications done by any user in any  table with the date and time. 

Forthcoming blog will guide you to setup and view change logs in Dynamics NAV.

Setting up Change Logs

You can setup the change log from,

Departments --> Administration --> IT Administration --> General --> Change Log Setup or you can simply type Change Log Setup in Search Bar

To activate change logs, mark change log activated as below,

Once the change log is activated, you need to define which tables should record the change log. This can be done by selecting tables in action pane.

You can enable the change log for three types of changes.

1. Log Insertion

2. Log Modification

3. Log Deletion

The changes can be applied for all fields or some fields.

If you select Some Fields, make sure you select the fields you want to enable change log, by clicking assist edit.

If you want to see the list of tables, which you have added change log you can simply run change log setup list report.

Okay now we're done with setting up the change log. 👍 Let's move to viewing change logs.

Viewing Change Logs

Viewing change logs is very easy if you know how to filter the information. The change logs can be viewed,

Departments --> Administration --> Application Setup -->  General --> Change Log Entries

You can add the filters to any field and track the data changes in your system 😀 As an example, if you want to see the activities of a specific date, you can add the date as a filter or you can add multiple filters according to your preference.

Hope this blog was helpful for you!

Have a Good Day!! 😃

Thil

What is Microsoft Dynamics NAV ?

Microsoft Dynamics NAV is an 

enterprise resource planning (ERP) 
app from Microsoft.

The product is part of the Microsoft Dynamics family, and intended to assist with finance, manufacturing, customer
 relationship management, supply chains, analytics and electronic commerce
 for Small and Medium-sized Enterprise and 
local subsidiaries of large international 
Groups. 
For modifications of the system, the
 proprietary programming language
 C/AL is used.

History

Microsoft Dynamics NAV originates from Navision, a suite of accounting applications which Microsoft acquired in 2002.

Navision originated at PC&C A/S (Personal Computing and Consulting), a company founded in Denmark in 1984. PC&C released its first accounting package, PCPlus, in 1985 - a single-user application with basic accounting functionality. There followed in 1987 the first version of Navision,^[1] a client/server-based accounting application that allowed multiple users to access the system simultaneously.The success of the product prompted the company to rename itself to Navision Software A/S in 1995.

The Navision product sold primarily in Denmark until 1990. From Navision version 3 the product was distributed in other European countries, including Germany and the United Kingdom.

In 1995 the first version of Navision based on Microsoft Windows 95 was released.

In 2000, Navision Software A/S merged with fellow Danish firm Damgaard A/S (founded 1983) to form NavisionDamgard A/S. In 2001 the company changed its name to "Navision A/S".

On July 11, 2002 Microsoft bought Navision A/S to go with its previous acquisition of Great Plains. Navision became new division in Microsoft, named Microsoft Business Solutions, which also handled Microsoft CRM.

In 2003 Microsoft announced plans to develop an entirely new ERP system (Project Green). But it later decided to continue development of all ERP systems (Dynamics AX, Dynamics NAV, Dynamics GP and Dynamics SL). Microsoft launched all four ERP systems with the same new role-based user-interface, SQL-based reporting and analysis, SharePoint-based portal, Pocket PC-based mobile clients and integration with Microsoft Office.

In September 2005 Microsoft re-branded the product and re-released it as Microsoft Dynamics NAV.

In December 2008 Microsoft released Dynamics NAV 2009, which contains both the original "classic" client, as well as a new three-tier GUI called the RoleTailored Client (RTC).

In October 2013, Microsoft released Dynamics NAV 2013, which was available with the RTC only, and introduced support for 64-bit Windows operating systems as well as a redesign of storing dimension sets, interoperability with SharePoint, and a web client.

In October 2014, Microsoft released Dynamics NAV 2015. This version’s improvements feature the tablet client, document reporting using Microsoft Word, Bank Integration, and more.

In October 2015, Microsoft released NAV 2016 features enhancements in reporting and email integration, deferral accounting, and posting preview function.

Microsoft continues to invest in Dynamics NAV and is now on an annual release cycle.

The product itself has gone through several name changes over the time. Initially "Navigator" was used in Denmark, although most Danish users knew it as "IBM-Navigator", as IBM distributed the software. Internationally it was sold as "Navision", except in the U.S., where it was called "Avista". The names "Navision Financials", "Navision Solutions", "Navision Attain", "Microsoft Business Solutions - Navision Edition", and - as of 2014 - "Microsoft Dynamics NAV" (pronounced N-A-V, except in the U.S. where most customers simply say "nav" - short for "Navision") have all been used to refer to this product.