Dynamics NAV with Power BI


Dynamics NAV with Power BI

I spoke recently of using NAV with Power BI, currently this topic (NAV integration with Power BI) is current and widely discussed, many questions about “How-to” integrate new and old releases on NAV with Power BI. I have collected a series of posts videos on Power BI and about integration with NAV (the most interesting that I fond).

MICROSOFT POWER BI

Best Definition by Microsoft: “Microsoft Power BI is a Microsoft’s Business Analytics service for Visualizing, exploring and deriving insights from data!”

Power BI Portal

https://powerbi.microsoft.com

Power BI Features

https://powerbi.microsoft.com/it-it/features/

“HOW-TO “GET STARTED

Get Started

https://powerbi.microsoft.com/it-it/documentation/powerbi-service-get-started/

https://powerbi.microsoft.com/it-it/get-started/

Power BI Free ebook

https://robertostefanettinavblog.com/2016/06/18/introducing-microsoft-power-bi-free-ebook-from-sqlbi/

Power BI Developer

https://powerbi.microsoft.com/it-it/documentation/powerbi-developer-overview-of-power-bi-rest-api/

https://powerbi.microsoft.com/it-it/get-started/

Nice series of pages about power BI on EID Site (NAVlab Partner)

http://www.eid.it/microsoft-powerbi/

ABOUT DYNAMICS NAV CONTENT PACK & CONNECTOR

Power BI Integration

https://robertostefanettinavblog.com/2016/03/15/power-bi-integration-microsoft-dynamics-nav-microsoft-power-bi/

https://powerbi.microsoft.com/en-us/integrations/microsoft-dynamics-nav/

Microsoft Dynamics NAV with PowerBI.com

https://suvidhablogpost.wordpress.com/2015/10/13/microsoft-dynamics-nav-with-powerbi-com/

Dynamics NAV Content Pack

https://powerbi.microsoft.com/it-it/documentation/powerbi-content-pack-microsoft-dynamics-nav/

https://robertostefanettinavblog.com/2016/02/04/connecting-dynamics-nav-20132015-to-the-nav-content-pack-in-powerbi-com/

Microsoft Dynamics NAV and Power BI (with O365) – Schedule Report Refresh

https://suvidhablogpost.wordpress.com/2014/12/09/microsoft-dynamics-nav-and-power-bi-better-together/

BEST CONNECTORS FOR DYNAMICS USERS

BEST VIDEOS

Power BI Desktop for Beginners: Create your first Power BI report and dashboard in 10 minutes

https://www.youtube.com/watch?v=h6AIAxMEDiw

Webinar Basics of Power BI for NAV users

https://www.youtube.com/watch?v=v9VIfrXwAfo

Power BI and Microsoft Dynamics NAV by Steven Renders

https://www.youtube.com/watch?v=u_nWPvBkU9w

Power BI and Microsoft Dynamics NAV 2016

https://www.youtube.com/watch?v=Qbx0FdlZDBk

Enjoy!

Advertisements

About “UI Elements Removal” feature


About “UI Elements Removal” feature

 

I never talked about this subject because is “daily bread” for NAV users, however, since some of NAV customers (and some of my readers) are still in old versions of NAV and they want to understand how this technology works, i collected a bit of existing documentation about this topic; below you will find many links from MSDN.

 

About “UI Elements Removal” feature

“UI Elements Removal” feature was introduced with NAV 2015; Microsoft Position at the end of 2014 before NAV 2015 launching date: “To simplify the users’ experience in Microsoft Dynamics NAV 2015, we have introduced the UI Elements Removal feature. The feature can be used to remove user interface (UI) elements, such as fields and actions from pages in Microsoft Dynamics NAV so that the Role Center and pages become simpler to look at, easier to navigate on, and faster to get through.”

Access By Permission on NAV 2015 (v=nav.80).aspx

How to: Try Out the UI Elements Removal Feature based on Demo Permission Set

(v=nav.80).aspx

How System Works with “LicenseFileAndUserPermissions” option active?

When you configure user interfaces in Microsoft Dynamics NAV, you should make sure that the UI Elements Removal field is set to its default, LicenseFileAndUserPermissions, so that you only see the relevant UI elements in the Customize window.

 

What objects will be removed objects by LicenseFileAndUserPermissions option?

All types of UI elements will be removed if they relate to objects that are not included in the license or the user does not have the required permission to the objects:

• Fields, Actions, Page parts

 

“UI elements” removed “By Design”

Directly Related

UI elements that are directly related to an object through the TableRelation or the CalcFormula property can be removed automatically according to the license file and/or user permissions

Not Directly Related

For UI elements that are not directly related to an object, you can use the AccessByPermission property to remove the element according to the user’s permission to a related object

“All types” of UI elements will be removed if they relate to an object to which the user does not have the required permissions:

  • Fields on pages, including FactBoxes
  • Actions on pages, including toolbars and navigation panes

  • Page parts, such as Lines FastTabs

 

About “FOUNDATION” permissions set

A prerequisite for all other permission sets. The FOUNDATION permission set grants access to system tables and application setup tables that are required for most application features to work.

This permission set is “recommended” when using the UI Elements Removal feature to automatically remove UI elements according to user permissions.

To use the LicenseFileAndUserPermissions option in the UI Elements Removal field, you must assign the special FOUNDATION permission set to the user along with the relevant application permission sets that define which application objects the user will access. Unlike the BASIC permission set, the FOUNDATION permission set only grants access to application setup and system tables and requires that other assigned permission sets define which specific application objects can be accessed. For more information, see Special Permission Sets.

Note that all of the 167 default permission sets that are provided with Microsoft Dynamics NAV are ready to support the FOUNDATION permission set to remove UI elements according to user permissions. You must therefore edit the relevant permission sets as explained in the following procedures.

Important ! 1

“If you defined the property for a table field, then all instances of the field on pages are removed from the user’s view. To override the property on an individual page field, delete the permission value after the = sign in the Value field. Do not delete the whole string as that will be replicated on the property of the table field.”

Important! 2

“The majority of the permission sets that are provided with the CRONUS demonstration database cannot be combined with the FOUNDATION permission set to fully use the UI Elements Removal feature. You must first create or edit the relevant permission sets to avoid that the user is blocked from performing the involved tasks. For more information, see How to: Create or Modify Permission Sets.”

 

Post Based on MSDN Documentation and others sources

Accessbypermission Property (NAV 2017 HELP on MSDN)

Source https://msdn.microsoft.com/en-us/dynamics-nav/accessbypermission-property

Source https://msdn.microsoft.com/en-us/dynamics-nav/how-to–remove-ui-elements-using-the-accessbypermission-property

 

SAMPLES

NAV Service Configuration

“UI Elements Removal” property with “LicenseFileAndUserPermissions” option

To use this property, the UI Elements Removal field in the Microsoft Dynamics NAV Server Administration tool must be set to LicenseFile or LicenseFileAndUserPermissions.

This Property Applies To

  • Fields in tables (affecting all related fields on pages)
  • Fields on pages

  • Actions on pages

  • MenuSuite items

  • Page parts, such as a Lines FastTab

  •  

    “AccessByPermission “Property Values

    When you choose the AssistEdit button, the Access By Permission window opens.

    Field Description

    Object Type Specify the type of object to which permission is required to display the UI element

    Object ID Specify the object to which permission is required to display the UI element

    Read Specify if Read permission is required to display the UI element

    Insert Specify if Insert permission is required to display the UI element

    Modify Specify if Modify permission is required to display the UI element

    Delete Specify if Delete permission is required to display the UI element

    Execute Specify if Execute permission is required to display the UI element

     

    Sample on table 137 “Sales Invoice Line”, on field “Line Amount”

    Others samples (Standard NAV)

    Table 37 “Sales Line”

     

    Page 42 “Sales Order”

     

    MenuSuite

    Bank Accounts List Page

    Item PropertiesAccess by Permission

     

    AVAILABLE DOCUMENTATION ON MSDN, Microsoft NAVHelp on MSDN

    Accessbypermission Property (NAV 2017)

    https://msdn.microsoft.com/en-us/dynamics-nav/accessbypermission-property

    Removing Elements from the User Interface According to Permissions

    https://msdn.microsoft.com/en-us/dynamics-nav/removing-elements-from-the-user-interface-according-to-permissions

    How to: Remove UI Elements Using the AccessByPermission Property

    https://msdn.microsoft.com/en-us/dynamics-nav/how-to–remove-ui-elements-using-the-accessbypermission-property

    How to: Specify When UI Elements Are Removed

    https://msdn.microsoft.com/en-us/dynamics-nav/how-to–specify-when-ui-elements-are-removed

    ABOUT DEMO PERMISSIONS SETS

    How to: Try Out the UI Elements Removal Feature Based on Demonstration Permission Sets

    https://msdn.microsoft.com/en-us/dynamics-nav/how-to–try-out-the-ui-elements-removal-feature-based-on-demonstration-permission-sets

    Dynamics NAV New Books


    Many ask in the forum about books\ebooks\kindles on Dynamics NAV 2017; actually there are no books on Dynamics NAV 2017 (…the same for Dynamics 365 Business Edition), many books have been updated at least to Dynamics NAV 2016.

    Good News: “New books on Dynamics NAV will be released soon”.
    Below you can find the title and release date of each book, i must point them, the upcoming books look very interesting !

    nav-books

    You can find books on Amazon or on PacktPub (also from other sites)

    https://www.amazon.com   https://www.packtpub.com/

    NAV books

    Books currently purchasable

    Implementing Microsoft Dynamics NAV – Third Edition (by Alex Chow)
    http://amzn.to/2jKcTNd

    hi already talked about this book long ago, take a look to my old post.
    https://robertostefanettinavblog.wordpress.com/2016/04/15/new-book-implementing-dynamics-nav-2016-by-alex-chow/

    Microsoft Dynamics NAV 2016 Financial Management – Second Edition
    by Anju Bala
    http://amzn.to/2k5fxhv

    Extending Microsoft Dynamics NAV 2016 Cookbook
    by Alexander Drogin
    http://amzn.to/2kAtgwG    at this time i’m writing a review of this book (Kindle)

    Einstieg in Microsoft S Dynamics NAV: Microsoft® Dynamics(tm) NAV 2016
    http://amzn.to/2k5HndM
    Books that will be released soon (only bookable books)

    Building ERP Solutions with Microsoft Dynamics NAV (available from August 2017)
    by Stefano Demiliani
    http://amzn.to/2kANTZU

    Mastering Microsoft Dynamics NAV 2016 (avalialble from September 2017)
    Rabindra Sah
    http://amzn.to/2k52YTv

    Programming Microsoft Dynamics NAV – Fifth Edition (available from November 2017)
    http://amzn.to/2jK3eGM

    Have a nice reading !

    “How -to” restrict multiple logins for same user in NAV


    Force logins limitations for some users can boost\improve system (few active Sessions..) as standard users can login in NAV multiple times, ex of real Scenario: CEO can have multiple logins, operational people NO !!

     NAV 2013 and Later

    From NAV 2013 Microsoft created a table named: Active Sessions – Table ID 2000000110 This table contains information about all the active sessions, showing Connected Client Type\PC and Users)

    Take a look to my previous post about “ALL ABOUT” Kill (In)active Sessions when “no more licenses”, with the VB.NET app in this post, you can show Client Type\PC and Connected User from this app to decide “who is the user” than try to use more than one NAV session.

    Source https://robertostefanettinavblog.wordpress.com/2017/01/15/all-about-kill-inactive-sessions-when-no-more-licenses/


    Starting from User Setup Table

    You can add a boolean field “Multilogin” to User Setup Table (table 91)” ; with this boolean field you can check if user can login more times in NAV instead of only one time.

    User Setup – Table ID 91 User Setup

    ml-1

    Before you need to add the new field “Multilogin” on Page “User Setup” (…or comment C/AL check code… you can’t login in anyway if you haven’t configured your user in this table)

    ..We can’t use System Table User.. because is used by System on Login process .. if you try to use this table you can’t start Windows Client…

    ml-2

    ml 3.png

    To Restrict multiple logins we can use Login Codeunit

    Codeunit 40 – LogInManagement

    This codeunit is ht first fired on Login Time and I can add C/AL code here to trap user logins.
    Steps: Open Codeunit 40, goto function CompanyOpen()

    In CompanyOpen function add two new local variables: locUser and locActiveSessione

    ml-4

    Modify the CompanyOpen function in this way:

    C/AL Code “Before” 

    CompanyOpen()

    IF GUIALLOWED THEN   LogInStart; C/AL Code “After”

    CompanyOpen()

    locUser.GET(UPPERCASE(USERID));

    IF NOT locUser.Multilogin THEN

    BEGIN

    locActiveSession.RESET;

    locActiveSession.SETRANGE(“User ID”,UPPERCASE(USERID));

    locActiveSession.SETRANGE(“Client Type”, locActiveSession.”Client Type”::”Windows Client”); //For   RTC\Windows Clients

    IF locActiveSession.COUNT > 1 THEN

    ERROR(‘You are currently logged in NAV, you can’t have more sessions!’);

    END;

    IF GUIALLOWED THEN

    LogInStart;

    // Register all Microsoft Dynamics CRM connection strings

    IF CRMConnectionSetup.GET THEN

    CRMConnectionSetup.UpdateAllConnectionRegistrations;

    Results

    System abort login codeunit and display the Error Message “’You are currently logged in NAV, you can’t have more sessions!”; you can use\trap also others login types: ex: Web Client, Web Service, Background Sessions and so on.

    ml 5.png

    Another Nice Feature

    You can decide also “how many sessions” each user can launch adding a “No. Sessions” field in User Table.

     ml-6

    C/AL Code

    CompanyOpen()

    locUser.GET(UPPERCASE(USERID));

    IF NOT locUser.Multilogin THEN

    BEGIN

    locActiveSession.RESET;

    locActiveSession.SETRANGE(“User ID”,UPPERCASE(USERID));

    locActiveSession.SETRANGE(“Client Type”, locActiveSession.”Client Type”::”Windows Client”); //For   RTC\Windows Clients

    IF locActiveSession.COUNT > 1 THEN

    ERROR(‘You are currently logged in NAV, you can’t have more sessions!’);

    END

    ELSE

    BEGIN

    locActiveSession.RESET;

    locActiveSession.SETRANGE(“User ID”,UPPERCASE(USERID));

    locActiveSession.SETRANGE(“Client Type”, locActiveSession.”Client Type”::”Windows Client”); //For   RTC\Windows Clients

    IF locActiveSession.COUNT > locUser.”No. Sessions” THEN

    ERROR(‘You are currently logged in NAV, you can’t have more than ‘ + FORMAT(locActiveSession.COUNT-1) + ‘ sessions!’);

    END;

    IF GUIALLOWED THEN

    LogInStart;

    // Register all Microsoft Dynamics CRM connection strings

    IF CRMConnectionSetup.GET THEN

    CRMConnectionSetup.UpdateAllConnectionRegistrations;

    Results

    ml-7

    Bingo !

    “ALL ABOUT” Kill (In)active Sessions when “no more licenses”


    Sometimes it happens that there are “no more licenses available” for Dynamics NAV, from NAV 2013 R2 and next releases, it’s necessary to run the Windows Client or to use Powershell statements to kill some sessions and unlock others.
    If you are unable to access to NAV (“no more licenses”), you should need to use SQL Console and kill sessions from there (reading from Active Sessions Table of from sysprocesses View on master db..)
    “Some user don’t want to use SQL Server to achieve this !” …
    WARNING : “No more licenses !!”   … Immediately Buy Others !!!
    license1.png
    There are many ways to kill sessions, i list below some methods.
    With NAV Server Login
    – C/AL
    – Powershell
    Without NAV Server Login
    – SQL Server Stored Procedures\T-Sql
    – VB .NET Application
    Below some methods to kill the sessions even in the case of “no more licenses available“: SQL Script and VB.NET
    C/AL Statement to Kill Sessions
    The Standard Statement for C/AL Code is:  STOPSESSION(“Session ID”);
    Example:
    IF CONFIRM (‘Kill Session ?’) THEN STOPSESSION(“Session ID”) … GOAL !
    …. BUT YOU NEED TO CONNECT TO NAV SERVER !  .. sometimes is NOT possible!
    ———————————————————-
    My VB.NET Solution
    “I wrote a simple solution on VB.NET to Kill Active Sessions using a SQL Connections,
    you cand find it on GITHUB and TECHNET.”
    ON GITHUB
    ON TECHNET
    Post link
    Download link
    About My VB.NET Simple Solution, some pictures
    kill1
    kill-2
    kill-3
    App Config File
    <?xml version=”1.0″ encoding=”utf-8″ ?>
    <configuration>
    <configSections>
    </configSections>
    <connectionStrings>
    <add name=”NAV_2017_KIll_SQL_Inactive_Sessions.My.MySettings.Demo_Database_NAV__10_0_ConnectionString”
    connectionString=”Data Source=STEFANETTILEN\SQL2012ENT;Initial Catalog=&quot;Demo Database NAV (10-0)&quot;;Integrated Security=True”
    providerName=”System.Data.SqlClient” />
    </connectionStrings>
    <startup>
    <supportedRuntime version=”v4.0″ sku=”.NETFramework,Version=v4.5″ />
    </startup>
    </configuration>
    ———————————————————-
    SQL KILL STATEMENTS
    KILL (Transact-SQL)
    – Syntax for SQL Server, Syntax for Azure SQL Data Warehouse and Parallel Data Warehouse

    KILL ‘session_id’ [;]    
    Source https://msdn.microsoft.com/it-it/library/ms173730.aspx

    KEEP IN MIND !!!   DON’T KILL PROCESSES IN THIS STATES:
    -AWAITING COMMAND
    -CHECKPOINT SLEEP
    -LAZY WRITER
    -LOCK MONITOR
    -SIGNAL HANDLER
    My Customized release
    1) SP_SQL_KillNavServerSession
    SET ANSI_NULLS ON
    SET QUOTED_IDENTIFIER ON
    GO
    — =============================================
    — Description: KILL ALL NAV ACTIVE USER SESSSIONS WITH MULTIPLE INSTANCES
    — =============================================
    CREATE PROCEDURE [dbo].[SP_SQL_KillNavServerSession]
    AS
    BEGIN
    DECLARE @RowIndex AS INT;
    DECLARE @MaxIndex AS INT;
     SET @RowIndex = 1;
    SELECT @MaxIndex =
    (SELECT top 1 MIN([Session ID])
    FROM [ITA].[dbo].[Active Session]
    WHERE [User ID] = ‘************’
    group by [Session ID])
     — Remove Active Session
    DELETE FROM [DB].[dbo].[Active Session] where [Session ID]>@MaxIndex AND [User ID] = ‘*********’
    END
    2) SP_SQL_KillNONavSession
    SET ANSI_NULLS ON
    SET QUOTED_IDENTIFIER ON
    GO
    — =============================================
    — Description: KILL SLEEPING NO NAV SESSIONS
    — =============================================
    CREATE PROCEDURE [dbo].[SP_SQL_KillNoNavSession]
    AS
    BEGIN
    DECLARE @Session TABLE
    (
    id INT IDENTITY(1,1) PRIMARY KEY,
    [sid] int,
    ltime DATETIME,
    hname varchar(MAX),
    uid varchar(100),
    lret datetime,
    etime int
    );
    DECLARE @NotAffectedUserList TABLE
    (
    id INT IDENTITY(1,1) PRIMARY KEY,
    [uid] varchar(MAX)
    );
    DECLARE @session_time as int;
    DECLARE @vSID as int;
    DECLARE @command as varchar(MAX);
    DECLARE @RowIndex AS INT;
    DECLARE @MaxIndex AS INT;
    set @session_time=15; — Assign Session time in Minutes
    — Assign List of Users who “will not be affected” by this Session Kill
    INSERT into @NotAffectedUserList SELECT ‘sa’
    INSERT into @NotAffectedUserList SELECT ‘NT AUTHORITY\SERVIZIO DI RETE’
    INSERT into @NotAffectedUserList SELECT ‘**************’
    INSERT into @NotAffectedUserList SELECT ‘scheduler’
    INSERT into @Session
    SELECT
    session_id as [Session ID],
    login_time as [Login Time],
    host_name as [Host Name],
    LOGIN_NAME as [Login ID],
    last_request_end_time as [Last Request End Time],
    DATEDIFF(minute,  last_request_end_time,getdate()) as[Elapsed Time (minutes)]
    FROM
    sys.dm_exec_sessions
    WHERE
    open_transaction_count = 0
    AND host_name <> ‘NAVSRV’ COLLATE Latin1_General_CI_AS
    AND host_name is not NULL
    AND DATEDIFF(minute,  last_request_end_time,getdate())>=@session_time
    –AND client_version=4
    AND login_name COLLATE Latin1_General_CI_AS not in
    (
    SELECT DISTINCT uid
    FROM @NotAffectedUserList
    )
    SET @RowIndex = 1;
    SELECT @MaxIndex = MAX(id) FROM @Session;
    WHILE( @RowIndex <= @MaxIndex)
    BEGIN
    SELECT @vSID = sid
    FROM @Session
    WHERE id = @RowIndex;
     — String together the KILL statement
    SELECT @command = ‘KILL ‘ + CAST(@vSID AS varchar(5))
     BEGIN TRY
      — Execute the final string to KILL the spids
    EXEC (@command)
    END TRY
    BEGIN CATCH
    declare @emsg varchar(500);
    SELECT
    @emsg=ERROR_MESSAGE();
      print @emsg;
    END CATCH
     SET @RowIndex = @RowIndex + 1;
    END;
    END
    // KILL SQL INACTIVE SESSIONS FOR NAV APPLICATIONS
    // ONLY FOR SLEEPING SESSIONS – OLD NAV CLIENTS
    a very Simple SQL Stored Procedure to ‘kill’ sql inactive sessions
    idle (sleeping) for 10 minutes related to “Nav Client” applications
    *** it’s necessary to identify correct “application name” ***
    *** ex: program_name LIKE N’%NAV client% *** or %NAV Web%
    DECLARE @v_spid INT
    DECLARE c_Users CURSOR
    FAST_FORWARD FOR
    SELECT SPID
    FROM master..sysprocesses (NOLOCK)
    WHERE spid>50
    AND loginame <> ‘DIR%’
    AND program_name LIKE N’%NAV client%’
    AND status=’sleeping’
    AND DATEDIFF(mi,last_batch,GETDATE())>=10
    AND spid <> @@spid
    OPEN c_Users
    FETCH NEXT FROM c_Users INTO @v_spid
    WHILE (@@FETCH_STATUS=0)
    BEGIN
    PRINT ‘Killing ‘+ CONVERT(VARCHAR,@v_spid)+’…’
    EXEC(‘KILL ‘+ @v_spid)
    FETCH NEXT FROM c_Users INTO @v_spid
    END
    CLOSE c_Users
    DEALLOCATE c_Users
    ———————————————————-
    OTHERS NICE SOLUTIONS (NAV LOGIN IS REQUIRED)
    Olof Simren Solution
    Kill Sessions in Dynamics NAV (from NAV Page)
    Source https://www.olofsimren.com/kill-sessions-in-dynamics-nav/
    Gunnar Solutions
    ADO NET Solution
    Kill Idle Connections
    Source http://www.dynamics.is/?p=471
    Poweshell Solution
    Stopping Idle Microsoft Dynamics NAV Services
    Nice Sessions Killing !

    How To setup “Keep Alive Interval” setting NAV2016-NAV2017


    Many posts in forums about this topic; some people report that Idle Client Timeout configured in NAV Administration is not working.
    Example of scenario: “Users logs in to the Navision by windows client installed on their PC but after setting idle client timeout session for 3 minutes then also it does not log off after 30 minutes also.”
    or
    Automatically Idle Client Timeout – NAV2016 – doesn’t work!
    http://forum.mibuso.com/discussion/66081/automatically-idle-client-timeout-nav2016-doesnt-work

    History of ClientKeepAlive setting
    Since the October 2015 cumulative updates, the Dynamics NAV Windows client timeout configuration was managed at the service level by setting the Idle Client Timeout setting.

    “The October 2015 cumulative updates added a new setting: “ClientKeepAlive”.
    This  setting is managed at the user level and located in the ClientUserSettings.config file.

    The value of this setting is given in seconds and defines the interval between ‘pulse’ signals sent by the client to prevent the client from going idle in some scenarios, or for some users.

    ClientKeepAlive: about this setting

    1. In the server configuration file, set Idle Client Timeout  to 00:10:00
    2. In the client configuration file, set ClientKeepAlive  to any value  larger than 600
      This value is in seconds, so 600 equals 10 minutes.

    Microsoft, by popular demand, changed in Dynamics NAV 2016 Cumulative Update 8:
    The ClientKeepAlive setting has been moved from the user level to the service level: “Keep Alive Interval “, and is no longer defined in number of seconds but as a time interval, just like the Idle Client Timeout setting.”

    Keep Alive Interval : about this setting

    So following our example above, to configure a timeout interval for the Dynamics NAV Windows client to 10 minutes, in Dynamics NAV 2016 Cumulative Update 8 and later, you must set the following:

    1. In the server configuration file, set Idle Client Timeout  to 00:10:00
    2. In the server configuration file, set Keep Alive Interval  to a value larger than 00:10:00

    PS: If you are running on a NAV 2016 build earlier then CU 8, your clientkeepalive settings will still be located Client side, in ClientUserSettings.config

    Web Client
    “To configure the timeout for the Dynamics NAV Web client, it is sufficient to configure the SessionTimeout setting in the web.config file to the relevant interval – in our example it’s 00:10:00.”

    PS: Check your NAV Release and build for correct configuration!

    Sources:
    Configuring Client Timeout
    https://blogs.msdn.microsoft.com/nav/2016/06/24/configuring-client-timeout/

    Understanding Session Timeouts NAV 2016-NAV 2017
    https://msdn.microsoft.com/en-us/library/dn789725(v=nav.90)

    Dynamics NAV in Remote App Mode


    Dynamics NAV in Remote App Mode

    Some people have asked me information on how to use the NAV Windows Client (ex RTC) in remote app mode.
    This environment can be useful for those still using the NAV Windows Client (in a few years I think that you will only use the Web Client or NAV in SaaS Mode).
    In various forums there are many posts about this topic, I bring my personal experience about this topic.

    About my Experience
    I use it for many years and I must say that it works well, the published NAV Windows Clients (ex RTC) in remote app is very light and the band occupied is very low.
    For example: it allows quickly to activate NAV in foreign branches without installing anything and without worrying too much about internet bandwidth etc. etc.

    Points of Strenghts
    – Don’t install anything on the client, just deploy the application icon or to give access to a portal (gateway remote app like in the picture)
    – is also usable on PCs with XP window (…), I don’t buy new PC if I don’t need high performance
    – The occupied bandwidth is really little, similar to other remote application tools)
    (when the local NAV Client is slow, via remote app however can be fast…
    – Compared to the standard terminal server is much less invasive, user uses only what has been published, not everything a remote desktop.
    – I can also use it in VPN (if I do not want to publish on the internet)
    – I can use all NAV versions starting at 4.0 SP1.

    Points of Weakness
    – if you are using Word Layout, Word must be installed on the remote server or you cannot print (ex: errors with Post & Print function)
    – Sometimes the NAV session is not closed on the server (even if it is closed on the client)
    – Copy and Paste operations are more harder bur possible.
    – If you don’t want to use a VPN , you need to use applications published on the Internet Gateway (… is the same situation with Azure and endpoints)
    – Today is considered “old technology”, not web based and oriented.

    REMOTE APPS GATEWAY

    LOGIN PAGE

     

    NAV Windows Client on Remote App (remote execution).. you are Welcome !

     

    Some Links for you

    Below are some useful links to understand the operational mode of remote app and how to setupconfigure a new remote app environment.

    Overview of Remote App

    https://technet.microsoft.com/en-us/library/cc755055(v=ws.11).aspx

    Remote Desktop Services (RDS) Quick Start Deployment for RemoteApp, Windows Server 2012 Style

    https://blogs.technet.microsoft.com/yungchou/2013/02/07/remote-desktop-services-rds-quick-start-deployment-for-remoteapp-windows-server-2012-style/

    Publishing RemoteApps in Windows Server 2012 (GREAT !)

    https://social.technet.microsoft.com/wiki/contents/articles/10817.publishing-remoteapps-in-windows-server-2012.aspx

    NAV 2016 via Remote App

    https://community.dynamics.com/nav/f/34/t/185099

    Dynamics NAV & TS RemoteApp

    https://community.dynamics.com/nav/f/34/t/25259

    Publish Dynamics AX client as RemoteApp on Remote Desktop Services

    https://community.dynamics.com/ax/b/axfortechies/archive/2012/10/25/publish-dynamics-ax-client-as-remoteapp-on-remote-desktop-services

    Introducing Terminal Services Easy Print: Part 1

    https://blogs.technet.microsoft.com/enterprisemobility/2007/04/26/introducing-terminal-services-easy-print-part-1/

    Have a nice new Year 2017 !

    Cumulative Update 11 for Microsoft Dynamics NAV 2016 has been released – Dynamics NAV Team Blog


    Cumulative Update 11 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016.

    The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see http://support.microsoft.com/contactus/.

    The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

    •   AU – Australia
    •   AT – Austria
    •   BE – Belgium
    •   CH – Switzerland
    •   CZ – Czech Republic
    •   DE – Germany
    •   DK – Denmark
    •   ES – Spain
    •   FI  – Finland
    •   FR – France
    •   IS – Iceland
    •   IT – Italy
    •   NA – North America
    •   NL – Netherlands
    •   NO – Norway
    •   NZ – New Zealand
    •   RU – Russia
    •   SE – Sweden
    •   UK – United Kingdom

    Where to find Cumulative Update 11

    You can download the cumulative update from KB 3188240 – Cumulative Update 11 for Microsoft Dynamics NAV 2016 (Build 46773).

    Warning

    Before you install a cumulative update in a production environment, take the following precautions:

    1. Test the cumulative update in a non-production environment.
    2. Make a backup of the system or computer where the cumulative update is to be installed.

    Additional Information

    For information about how to install the cumulative update, see How to Install a Microsoft Dynamics NAV 2016 Cumulative Update.
    Note that if you upgrade to this cumulative update from a version older than Microsoft Dynamics NAV 2016 Cumulative Update 6, you must run the development environment with elevated rights (run as administrator).

    For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2016.

    How to Use MVC.Net on the Dynamics NAV Database Structure


    How to Use MVC.Net on the Dynamics NAV Database Structure

    MVC

    nice post about ASP MVC.Net integration with NAV (post by Codeproject).

    About ASP MVC.Net

    ASP MVC.Net is an robust & good pattern-based way to build dynamic websites; if you don’t like to use Web Services & OData this is a valid alternative (old but actual). You can use to build Website based on NAV database structure. “How you can use the Entity Framework in an MVC.Net web application with Dynamics NAV ?”

    Tutorial

    This tutorial will show you how you can use the Entity Framework in an MVC.Net web application with Dynamics NAV.

    Take a look to project.

    Source: http://www.codeproject.com/Articles/421643/How-to-Use-MVC-Net-on-the-Dynamics-NAV-Database-St