May 9, 2018

Dynamics 365 Saturday - Melbourne 2018

I will be taking the stage this Saturday with Wagner Silveira at Dynamics 365 Saturday - Melbourne to talk about "Richer integration with logic apps for Microsoft Dynamics NAV and Dynamics 365".

Join us.

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara
Read more »

Apr 13, 2018

Directions Asia 2018 Bangkok: MVPs report back

The original post is posted in Theta's Official Blog

Directions is the biggest Microsoft Dynamics NAV conference in the world, and was held for the second time in Asia, on 15th and 16th March in Bangkok. It’s an independent conference for Microsoft Dynamics partners from the ERP and CRM channels focusing on the small and medium-sized business (SMB) market, organised by partners, with the help of Microsoft.

Attending any Directions conference is always an advantage for any professional involved in the Microsoft Dynamics platform, as the conference provides the perfect environment for knowledge sharing, networking and discovery of new opportunities for future growth and collaboration.

This year we had the opportunity to send Theta’s two Microsoft MVPs, Tharanga  Chandrasekara and Wagner Silveira, to Bangkok, not just to attend the conference, but as presenters at Directions ASIA, selected and sponsored by the Directions committee. Here is what they have to say about the experience.


Integration at a Microsoft Dynamics Conference?


Precise, up-to-date information is key to a successful business, as it adds real value to the decision-making process, making it faster and more reliable.

Today, ERP and CRM systems are entwined, making it hard to implement one without the other. But a reliable and conflictless integration is quite hard to achieve. The standard Microsoft Dynamics NAV CRM connector works perfectly when a point to point integration and data flow direction are unidirectional - “To Integration Table” or “From Integration Table”. 


But the Microsoft Dynamics NAV CRM Connector faces difficulties when integration requirements become multi-point or bi-directional. So what are the alternatives?


We decided to share our experience integrating Microsoft Dynamics 365 and Microsoft Dynamics NAV with the community, demonstrating new integration possibilities and best practices.


During our session, we brought together our two areas of expertise to discuss patterns to integrate Microsoft Dynamics NAV and Microsoft Dynamics 365 (CRM) when multi-point or bi-directional integration is required. We demonstrated the use of Logic Apps with Microsoft Dynamics NAV to achieve bi-directional, close to real time, multi-point integration scenarios.

The audience was engaged and enthusiastic, and especially interested in the three demo scenarios, which showed the new capabilities Logic Apps can bring into the world of Microsoft Dynamics.


Conference highlights
During the conference, Marko Perisic (General Manager, Microsoft Dynamics SMB) announced Microsoft Dynamics 365 Business Central.
Business Central
Microsoft Dynamics 365 Business Central brings the full power of Microsoft Dynamics NAV to the cloud, as a modern solution for modern businesses. Along with the new capabilities, the application will include an all-new user experience. With a familiar Microsoft Office 365 user interface, personalised feeds, smart notifications, embedded AI capabilities – amassing over 100 new functionality items, Business Central enables users to work smarter and be more productive than ever before.


The conference was a huge success, and we’re looking forward to attending again next year.

Microsoft Dynamics 365 Business Central will be generally available on April 2, 2018, in 14 countries (United States, Canada, United Kingdom, Denmark, Netherlands, Germany, Spain, Italy, France, Austria, Switzerland, Belgium, Sweden, and Finland) and will be available through the Cloud Solution Provider (CSP) channel. The solution will be generally available in Australia and New Zealand from July 1, 2018.


DXtFyHHU8AA3v-c.jpg
Tharanga Chandrasekara, a senior consultant in our ERP team, and Wagner Silveira, Theta's principal integration architect, are both Microsoft MVPs, and were invited to present at this conference by the Directions committee.







Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara
Read more »

Mar 13, 2018

Microsoft Dynamics 365 Business Central is now official

While waiting at Auckland Airport for my flight to Bangkok to attend Direction Asia, I got a pretty exciting mail from my MVP group.

Microsoft Dynamics 365 Business Central is now official! 


Generally available beginning April 2nd, Business Central offers businesses a single, end to end solution for managing finances, operations, sales and customer service, and an opportunity to easily upgrade from entry-level accounting software and legacy ERP systems.

Dynamics 365 Business Central will be generally available on April 2, 2018, in 14 countries – United States, Canada, United Kingdom, Denmark, Netherlands, Germany, Spain, Italy, France, Austria, Switzerland, Belgium, Sweden, and Finland, purchased through Cloud Solution Provider (CSP) partners. 


Australia and New Zealand will be generally available beginning July 1, 2018.

You can read more about this exciting news on clicking here

Will Tweet and blog about Microsoft Dynamics 365 Business Central when we heard more during Direction Asia. 


Please provide your feedback with a comment.
Thank you and Regards,
Tharanga Chandrasekara
Read more »

Feb 14, 2018

Direction Asia 2018 : Richer integration with logic apps for Microsoft Dynamics NAV and Dynamics 365 (CRM)


I'll be speaking at #DirectionAsia 2018 this March in Bangkok together with Wagner Silveira. Join with me and other Dynamics expects at the Directions ASIA conference!

Topic: Richer integration with logic apps for Microsoft Dynamics NAV and Dynamics 365 (CRM).

Session Type: Technical.

Abstract: Precise, up-to-date Information is key to success, as it adds real value to the decision-making process, making it faster and more reliable.

Today, ERP and CRM systems are really entwined, making really hard to implement one without the other. But a reliable and conflictless integration is quite hard to achieve. Standard Microsoft Dynamics NAV CRM connector works perfectly when a point to point integration and data flow direction are unidirectional - “To Integration Table” or “From Integration Table”. 

But the Microsoft Dynamics NAV CRM Connector can’t cope well when integration requirements become multi-point or bi-directional. So what are the alternatives?

In this session, Tharanga Chandrasekara – Business Solution MVP (Dynamics NAV) -  and Wagner Silveira – Azure MVP - are going to discuss patterns to integrate Microsoft Dynamics NAV and Dynamics 365 (CRM) when multi-point of bi-directional integration is required, that goes beyond the Standard Microsoft Dynamics NAV connector, demoing the use of logic apps with Microsoft Dynamics NAV to achieve bi-directional, close to real time, multi-point integration.


Learn more about sessions on http://www.directionsasia.com/about/more-about-sessions/

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara
Read more »

Dec 5, 2017

Configure Visual Studio Code with Dynamics NAV 2018 (Local Server Installation)

After installing Dynamics NAV 2018 I want to configure Visual Studio Code with Dynamics NAV to use new Development tool

I already had Visual Studio Code installed on my computer (Click to download Visual Studio Code) so I open up the application.

Do not follow Section 01 steps because you will run into issues. Read the Section 02 of the instructions to get it work.

Section 01 :

First thing I want to do is download AL Extention. In order to download AL extension follow below steps:

  1. Go to View Menu and click on Extensions. 
  2. Search for AL 
  3. Click Install


Once the Extention installation is complete I followed below steps:

  1. Press Alt+A, Alt+L to trigger the Go! command, 
  2. Choose "Your own server"
  3. Once you select the "Your own server" you will see a code like below in the "launch.json" file. 


I change the settings as below :


  "version": "0.2.0",  
   "configurations": [  
     {  
                "type": "al",  
                "request": "launch",  
                "name": "Local server",  
                "server": "http://localhost:7049",  
                "serverInstance": "DynamicsNAV110",  
                "tenant": "default",  
                "authentication": "Windows",  
                "startupObjectId": 22  
     }  
   ]  


Once I do that I got an error message, and I could not resolve it. (Could not download symbols. Please see the Visual Studio output log for more details)



Then I thought it is something to do with the Service tier config so I open up the config file and notice that "Enable loading application symbol reference at service startup" is disabled. I enabled it and restart the instance.



Even after that also I could not get to download symbols. Therefore I thought to use a different approach.

Section 02: 

I thought to install AL extension manually by using VSIX file.

  1. Uninstall AL extention from Visual Studio Code.
  2. Click View -> Extention.
  3. Click on ... to open the extension menu.
  4. Click on Install from VSIX



You can find VSIX file on the installation medium path: "ModernDev\program files\Microsoft Dynamics NAV\110\Modern Development Environment" or in the "C:\Program Files (x86)\Microsoft Dynamics NAV\110\Modern Development Environment"


This will install AL Language Version 0.12.15355

Once the Extention installation is complete I follow below steps

  1. Press Alt+A, Alt+L to trigger the Go! command.
  2. Choose "Your own server"
  3. Once you select the "Your own server" you will see a code like below in the "launch.json" file. 


   "version": "0.2.0",  
   "configurations": [  
     {  
       "type": "al",  
       "request": "launch",  
       "name": "Your own server",  
       "server": "http://localhost",  
       "serverInstance": "nav",  
       "authentication": "UserPassword",  
       "startupObjectId": 22  
     }  
   ]  

In my local installation, I use Windows Authentication and my NAV instance is different. Therefore I change the file values as below.

    "version": "0.2.0",  
   "configurations": [  
     {  
       "type": "al",  
       "request": "launch",  
       "name": "Your own server",  
       "server": "http://localhost",  
       "serverInstance": "DynamicsNAV110",  
       "authentication": "Windows",  
       "startupObjectId": 22  
     }  
   ]  

Once I update the values and save the file, it successfully downloads the symbols.

Please let me know if you use a different approach or if it workes with online extension installation for you.

Please provide your feedback with a comment.
Thank you and Regards,
Tharanga Chandrasekara
Read more »

Install Dynamics NAV 2018 with Modern Development Environment

Microsoft released Microsoft Dynamics NAV 2018 a few days ago and by now most of you have already downloaded the setup. If you don't have it already, you can download it by clicking here.

In this blog post, I will not go through each step as it is not much different with the installation process compared to previous versions. I want to highlight few new things which most people will not notice during the installation process.


In most of the time, I use the Customize installation option as it allows me to select individual components I want to install. In this instance, also I select the Customize option.

If you want to work with new development tool (to develop extensions) you want to enable "Modern Development Environment". By default, it is enabled and you do not have to do anything. If you not planning to work with new development tool then you can remove it from installation.



In the very next step, you will find another 2 new fields (it is growing by each version)
which are related to new Developer tool. 
  • Field 1: "Developer Service Port"
  • Field 2: "Developer Service Enabled"
You can ignore these two fields but if you planning to work with Modern Development Environment then I suggest you set it up correctly on the first go.

Developer Service is disabled by default, so you need to enable it (YES)



Once you pass the above step, everything is similar to previous version installation.

If you have already installed Microsoft Dynamics NAV 2018 without enabling the "Developer Service" then you can go to Dynamics NAV instance and change the settings (Restart instance after the changes)



Or

If you like to use PowerShell to change the port numbers (Try to make it a habit to use PowerShell as much as possible) you can use cmdlet

 Set-NAVServerConfiguration <InstanceName> -KeyName 'DeveloperServicesPort' -KeyValue <PortNumber>  
 Set-NAVServerInstance <InstanceName>-Restart -Verbose  

Good luck!!

Please provide your feedback with a comment.
Thank you and Regards,
Tharanga Chandrasekara
Read more »

Dec 1, 2017

Welcome to Microsoft Dynamics NAV 2018

The long wait is finally over. Microsoft Dynamics NAV 2018 is now available for download. 



You can now download Dynamics NAV 2018 by clicking here

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara
Read more »

Oct 16, 2017

Check Dynamics NAV license from RTC

In order to check the current uploaded Microsoft Dynamics NAV License from RTC environment please follow below steps. 

01. Open RTC Environment.
02. Click on the white arrow in the top left corner of the client. (Refer below image)
03. Go to Help - > click on "About Microsoft Dynamics NAV"


04. "About Microsoft Dynamics NAV" window will have basic information about the license. Such as Product version and to whom the product is licensed to. 

05. In order to get more details click on the link "View your license information". It will open up a detailed license information page. 

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara
Read more »

New Release Date of Dynamics NAV 2018 and future of Dynamics NAV

It is a good news for all the Microsoft Dynamics NAV partners and for new customers who were waiting for Dynamics NAV 2018 on-premise version. 

The release date of Dynamics NAV 2018:
The wait is finally over and Marko Perisic announced in Madrid last week that we will have the published Dynamics NAV 2018 on December 1st. 

Dynamics NAV 2018 and VS Code Extension v2:
Dynamics NAV 2018 will allow partners to use Visual Studio Code for Extensions v2. This will allow partners to get ready for new Dynamics NAV 2018 R2 version which will be released in spring of 2018.

Same code two names: 
Dynamics NAV 2018 R2 and Dynamics 365 "Tenerife" will have the same codebase even though the names are totally different to each other which might change in near future. 

Rebranding:
Microsoft is thinking of rebranding Microsoft Dynamics NAV. Therefore most probably in future, we will not have the name "Dynamics NAV", but we will still have the powerful product. Future is bright for Dynamics NAV (let's just call it like that for now).


Please provide your feedback with a comment.
Thank you and Regards,
Tharanga Chandrasekara
Read more »

Jul 25, 2017

Value '-1' is not a valid value. The following values can be used >=0.

Hi,

Recently one of my colleague was trying to copy "Chart Of Account" to "IC Chart of Account" in NAV 2017 using default "Copy from Chart of Account" functionality. 

This is a really nice functionality available because within a single button click all the accounts in "Chart of Accounts" get copied to "IC Chart of Accounts".

Copying the accounts went smoothly as expected but once the copying finished screen changes to below. 

We first thought it was a refresh issue and just tried to refresh the page, but end up with below error message.
"Value '-1' is not a valid value. The following values can be used >=0."



We open up the IC GL account table and check for indentation and found that "End-Total" has a value of -1. The error went away once we change it back to 0 in the table.


So what went wrong? 

The first point to check was "Chart of Account" indentation and it was all OK. All set to 0. 




To understand what went wrong we open up the Page 605 and went to the "CopyFromChartOfAccounts" function. 

As highlighted in below for every "End-Total", program -1 from the current indentation value. Since "Chart of Account" indentation is set to 0, end-values in "IC Chart of Account" end up with -1. 

This built-in logic is totally acceptable if the Indent "Chart of Account" is done as below. 

Once the "Indent Chart of Accounts" is done, "Copy from Chart of Accounts" worked like a charm.

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara
Read more »

Apr 29, 2017

Internal error 52033 in module 93

Hi, 

During last week I was upgrading a 4.0 DB to NAV 2017. While opening the database from Microsoft Dynamics Classic Client, I got below error message. 

---------------------------
Microsoft Business Solutions-Navision
---------------------------
Internal error 52033 in module 93. 
Contact your dealer if you need assistance.
---------------------------
OK   
---------------------------

In order to resolve the error, you need to add T4616 to SQL Server Startup Parameter list. Please do follow below steps,

1. Open SQL Server Configuration Manager.
2. Select MSSQLServer Properties.
3. Navigate to Advanced Tab.
4. Select the Start up Parameter.
5. Navigate to End of the line and add String ;-T4616 as shown below.


Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara
Read more »

Mar 31, 2017

Quick Fix : OLE control or Automation server identified by GUID-{F9043C85-F6F2-101A-A3C9-08002B2F49FB} not found

If you are working with a version of Microsoft Dynamics NAV, then most probably you might be familiar with below error message. 


This message is for C/AL Programmers:
Could not create an instance of the OLE control or Automation server identified by GUID-{F9043C85-F6F2-101A-A3C9-08002B2F49FB}.
Check that the OLE control or Automation server is correctly installed and registered.
GUID always helps to find the root cause for the issue. (Google GUID and you will get list of solutions)

In this case GUID {F9043C85-F6F2-101A-A3C9-08002B2F49FB} refers to the "Microsoft Common Dialog Control, v6.0". 

This normally get installed and placed in below folder path : "C:\WINDOWS\System32\comdlg32.ocx' and C:\Windows\SysWOW64\comdlg32.ocx"

Fix:
  • Download "comdlg32.ocx" from here.
  • Copy downloaded file to below two folder path
    • C:\Windows\System32
    • C:\Windows\SysWOW64 
  • Run command prompt in administrator mode (Run as administrator)
  • Run below two commands in command prompt to register comdlg32.ocx
  • 1:  regsvr32 c:\Windows\system32\comdlg32.ocx  
    2:  regsvr32 c:\Windows\SysWOW64\comdlg32.ocx  
    
  • After each command you will get individual confirmation messages. 
Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara
Read more »

Quick Fix : There is no system code page on your computer that matches the code page of the collation for the database.

If you are still using a old version of Dynamics NAV or if you are trying to upgrade old version to a newer version of Dynamics NAV, then you might have a chance of getting below error message when you open up the database from Classic Client. 
---------------------------Microsoft Dynamics NAV Classic---------------------------
There is no system code page on your computer that matches the 850 code page of the SQL_Latin1_General_CP850_CI_AS collation for the XXXXXXXXXXXXXXXX database.
Your system code pages are: ANSI: 1252, OEM: 437.
Ensure that the Regional Options of the computer use the correct system language and locale for the code pages to match.
You can also disable the 'Validate Collation' setting for this database. It is possible that certain text data will not be converted correctly when stored in the database.
Click OK to disable the 'Validate Collation' setting and continue to use the database, or click Cancel to exit.
---------------------------OK Cancel ---------------------------
This error us due to your DB collations is different from your computer collation. You can have a quick fix to resolve this error however you might need to talk to your system and DB admin for a permanent solution. 

Quick Fix:

You need to change registry value in your computer to required Code page. In order to do that,

1. Press Start + R : To open Run Window
2. Enter "regedit" and click OK to open "Registry Editor"
3. Navigate to below path and find the OEMCP
4. Double click on the OEMCP and change Value Data to 850.


 [HKEY_LOCAL_MACHINE \SYSTEM \CurrentControlSet \Control \Nls \Codepage] OEMCP = "850" (Default = 437)  

5. Restart Your computer to update registries. 

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara
Read more »

Mar 12, 2017

Quick Fix : Visual Studio displaying NAV Report Layout as XML

I got this issue with Visual Studio 2015 Enterprise Edition. 

Every time I open a Dynamics NAV report layout in Visual Studio, RDLC is rendered as XML file instead of visual layout with all the fields and tool boxes. 

How the report layout looks: 

FIX : In order to fix the issue you need to install "Microsoft SQL Server Data Tools"

To install "Microsoft SQL Server Data Tools" you need to go to 
Control Panel  -> Programs and Features - > Microsoft Visual Studio <Edition> -> Change

Or you can re run the installation setup. 
From the features list, enable "Microsoft SQL Server Data Tools" option and proceed. 
Once the installation is completed you are good to go. This time report layout will open in correct design layout. 
Hope this helps you to resolve the issue. happy designing. 

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara
Read more »

Mar 11, 2017

Best Practice - SQL Script

Hi,

This blog post is about one small best practice that can save lot of time in the long run if you are working with SQL Server Management Studio. 

Many people who involved in Dynamics NAV does not have a very close relationship with SQL Server Management Studio even though back-end of NAV is totally based on SQL DB. 

Even during that very little usage of SQL Server Management Studio, many people (including me) use wizards to do things because it's more easy and error free most of the time. 

Just like below, few clicks and we are almost there.. 


If we making backup (as an example) of same database for 10 times, then that mean we need to go through the same process over and over 10 times. 

Is there way we can do all those in one simple click? 

This blog post is about that. How about we create a small script in other word SQL Query which will do the same process for us. 

If you are not an expert in  SQL then you can use wizard to build your query. Do all the steps you usually do and then stop just before you press OK. 

Click on Script button and save it on a file or open in a new query window. 

If you open up in a new query window, your query will look like this and you can change the parameters as you want and just press execute. it will do the job for you.
 
Beauty of this method is that you do not have to go through wizard to get your task done, you can just do that with a click of a button. Think about time you going to save in long run. 

Other advantage is if you are doing a time consuming process then SQL Management Studio will show you the progress of your process in text format. 

I should give credit and thankful to SQL expert, my colleague Tomasz Szypilo who pushed me to use SQL scripts. 

Thank you for reading and hope you learned something from the blog post. 

Please provide your feedback with a comment. 
Thank you and Regards,
Tharanga Chandrasekara
Read more »

Mar 9, 2017

March 2017 Cumulative Updates for Microsoft Dynamics NAV

Microsoft has published new Cumulative Updates for March 2017: Please refer below links for more information
It is always good to update your environment to latest Cumulative Update.

Please provide your feedback with a comment.
Thank you and Regards,
Tharanga Chandrasekara
Read more »