My professional life
Open Data Protocol (OData) is a data access protocol initially defined by Microsoft. In NAV 2013 Microsoft first added a support for OData. On the Developer Network Microsoft has a few walk-throughs aimed to get us started in using both SOAP and OData web services. To get started with OData first make sure that the …
We have several ways of using the JSON interfaces. I will give few examples with the required C/AL code. I will be using Advania’s Online Banking solution interfaces for examples. The Advania’s Online Banking solution is split into several different modules. The main module has the general framework. Then we have communication modules and functionality …
And what is an interface Codeunit? A Codeunit that you can execute with CODEUNIT.RUN to perform a given task is, from my point of view, an interface Codeunit. An interface Codeunit has a parameter that we put in the This parameter is always a table object. We have multiple examples of this already in the …
I am upgrading multiple companies to NAV 2016. I really like to use the multi tenant setup and use it in most cases. In NAV we have the option to make a table common with all companies. This option has been available for all the versions of NAV that I can remember. Using a multi tenant …
A new operating system from Microsoft sure has it’s impact on our ecosystem. Our Microsoft Dynamics NAV is based on top of Microsoft operating systems. With the power of SOAP and OData services in Microsoft Dynamics NAV everyone is now able to design a custom user interface dedicated for a simple task, both for employees …
I just got a question from a client; Gunnar, Do you have a “King Kong” license that will allow you to delete any object? It appears our development license does not have the rights to some of the newer LS Retail objects and I need to create a CRONUS database with just our stuff. Well, …
Continue reading “Building a clean database – remove not licensed objects”
In my earlier posts I showed how to create the databases and how to install Dynamics NAV on the server machines. The next step is to create an instance for every application and mount the default tenant. The default tenant is the only one that will be able to change the application data. To finish this …
Continue reading “Create Instance, Web Client and ClickOnce with PowerShell”
In my latest blog in this PowerShell series I showed how to install Dynamics NAV on a remote or local computer with PowerShell. The next step is to create the databases. To prepare PowerShell I use these functions to prepare for NAV and SQL administration [code lang=”powershell”]Import-Module ‘C:\Program Files\Microsoft Dynamics NAV\71\Service\NavAdminTool.ps1’ Import-Module SQLPS [/code] I …
Continue reading “Restore Database with PowerShell and create Tenants”
I have now gone through my first upgrade from NAV 2013 to NAV 2013 R2. Stopped and uninstalled NAV 2013 Server Opened NAV 2013 database with NAV 2013 Developement Environment and upgraded the database Compiled all system tables (2000000004-2000000130) Installed and started NAV 2013 R2 Server Compiled all objects Imported Upgrade700701.IS.1.fob from the NAV 2013 R2 …
I just finished my install on databases and service to our developement server. When creating several databases and several instances I wanted to use PowerShell. I based the setup on the demo database backup and used PowerShell ISE as an Administrator to do the setup. First step is to set up parameters. #Change Id to …
Continue reading “Setting up our NAV 2013 R2 Developement with PowerShell”