27 October 2016

Microsoft Dynamics NAV 2017 Released & Download Page

Hi All,

Microsoft  Dynamics NAV 2017 Released for 22 countries with W1 version.

Below is the Link for Download Page of Microsoft Dynamics NAV 2017

https://mbs.microsoft.com/partnersource/global/deployment/downloads/product-releases/msdnav2017download


Thanks & Regards,
Nandesh Gowda

08 October 2016

Indentation and Tree View of List Pages NAV

Hi All,

Here we will talk about the Indentation Properties available on Pages.

These properties Applies to Pages of Type = Group &  Subtype = Repeater

If you go to property of  Repeater Control, we will see few properties which controls the Indentation for List pages.







IndentationColumnName Property : 
Here we specify the column that will control the Indentation. The Data Type has to be Integer.
We can use a Table field or a Variable to set this property.


IndentationControls Property :
Here we choose columns on which we need indentation. Click on Assitbutton  and select the appropriate columns and press OK.



As you can see below the Name Column is Indented. Once you run Indent Chart of Accounts.



How does the Name column got indented, simple based on Integer table field "Indentation"  which gets updated when you run Indent Chart of Accounts.

Indentation field Value is set to a Variable NameIndent on OnAfterGetRecord trigger.

NameIndent Variable is mapped to  IndentationColumnName Property.




ShowAsTree Property :

Sets the indentation of rows on a List Page to Tree View. If you enable this property, you can expand or collapse indented rows on a List Page





Similarly we can use the above properties of Repeater Control List page to Indent or show tree view on Documents SubPage as well,



Thanks & Regards,
Nandesh Gowda

Calling Web Services from NAV

Hi All,

A need may arise to Integrate NAV with third party Applications.

There are ways to Integrate systems with NAV through SQL, using Files, using Web Services, etc.

To make it real time mostly web services are preferred.

Below is the Sample Code on how to connect to External SOAP Web services from  Automation Variable using XML HTTP calls.

I had done this long time back for NAV 2009 R2 with MS XML 3.0. So I have changed it to MS XML 6.0 .

You may need to do some changes/modifications in code to make it work.

Calling  External SOAP Web Service from Automation








Below are few links which may be useful.

Call external Web service using new CU 1290

Call External Web Service using CU 1290



Calling NAV Web Services with in NAV.

Consuming NAV Web Services within NAV


Thanks & Regards,
Nandesh Gowda

Using Virtual Table FILE to read files and Import using XMLPort NAV

Hi All,

Using Virtual Table File  to get the files in a directory & then calling a XMLPort to Import the file in NAV.

Below are the variables to be defined




Below is the Sample Code for the same.





Thanks & Regards,
Nandesh Gowda

Checking Objects Permission using Virtual table License Permission NAV

Hi All,

There may be a need to check whether the objects are included in License or not.

We can check the Permissions by using Virtual Table "License Permission"

Create a new List Page by selecting table License Permission  table.



Run the newly created page and you will see all the objects with their permission.





Thanks & Regards,
Nandesh Gowda

Reading & writing Unicode Files NAV

Hi All, 

You can use an instance of the System.IO.StreamWriter class to write to an OutStream OR the System.IO.StreamReader class to read from an InStream

You control the encoding by using the System.Text.Encoding class where you select between Default, Unicode or UTF8 encoding.


  • Please note that XMLports directly supports importing and exporting flat text files in MS-DOS, UTF-8, UTF-16 encodings by setting the new TextEncoding property.


You can refer below MSDN blog post for more detail. 
Reading-and-writing-unicode-files-using-cal


Thanks & Regards, 
Nandesh Gowda