-
Getting Started with Dynamics 365 Business Central APIs
API (Application Programming Interface) is an interface which allows applications to talk with each other. Simply put, it is more like a website, where you make a call to the server and you get a response from the server. Dynamics 365 Business Central (D365BC) expose many “ready-to-use” APIs which allows seamless integration experience between other…
-
What is Docker? What are Containers?
Every year Microsoft is releasing a major version of Microsoft Dynamics NAV and on top of that, they release monthly updates for each of these versions. You would love to have all your clients and developed add-ins to be only in the latest version of Microsoft Dynamics NAV. However, we all know that is far…
-
Third consecutive year as a Microsoft Most Valuable Professional (MVP) – Business Applications
Third consecutive year as a Microsoft Most Valuable Professional. It is a great honor to receive the Microsoft Most Valuable Professional (MVP) award. Thank you, everyone, for helping me out on this great journey. Thank you and Regards,Tharanga Chandrasekara
-
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
-
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,…
-
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,…
-
List of System and Hidden Tables – Microsoft Dynamics NAV 2018
Below is the list of Virtual and System tables in Microsoft Dynamics NAV 2018. Some of these hidden tables save hours of work for developers if they used properly. Click here to refer a complete blog post about Date table and how to use. 10 New System tables added in NAV 2018 Object ID Object Name…
-
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…
-
AL Extensions, Development, Microsoft Dynamics 365, Microsoft Dynamics NAV, Microsoft Dynamics NAV 2018, VSCode
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…
-
AL Extensions, Development, Microsoft Dynamics 365, Microsoft Dynamics NAV, Microsoft Dynamics NAV 2018
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…
-
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
-
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”…
-
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…
-
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…
-
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,…
-
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.…
-
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…
-
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…
-
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…
-
March 2017 Cumulative Updates for Microsoft Dynamics NAV
Microsoft has published new Cumulative Updates for March 2017: Please refer below links for more information Cumulative Update 4 for Microsoft Dynamics NAV 2017 (Build 15601) | Details Cumulative Update 17 for Microsoft Dynamics NAV 2016 (Build No 48067) | Details Cumulative Update 29 for Microsoft Dynamics NAV 2015 (Build No 48062) | Details Cumulative…
-
C/AL, Development, Microsoft Dynamics 365, Microsoft Dynamics Business Central, Microsoft Dynamics NAV
Understanding COMMIT and transaction scope with temporary records within Microsoft Dynamics NAV
If you did not went through the previous post on “Understanding COMMIT and Transaction Scope within Microsoft Dynamics NAV“, I suggest you to go through it before start reading this blog post. What do you think about temporary records and transaction scopes? Most of developers think temporary records are managed as transactions, but it’s not. …
-
AL Extensions, C/AL, Development, Microsoft Dynamics 365, Microsoft Dynamics Business Central, Microsoft Dynamics NAV
Use of Virtual Table : Date – Microsoft Dynamics NAV
This blog post is about something powerful but hidden within Microsoft Dynamics NAV. I believe many developers always work with dates over and over during their day-today life and i’m sure many of you have done many functions which convert, split and do all sort of things with date. Saying that many developers does not…
-
January 2017 Cumulative Updates for Microsoft Dynamics NAV
Microsoft has published new Cumulative Updates for January 2017: Please refer below links for more information Cumulative Update 02.1 for Microsoft Dynamics NAV 2017 (Build 15052) Cumulative Update 15.1 for Microsoft Dynamics NAV 2016 (Build 47838) Cumulative Update 27 for Microsoft Dynamics NAV 2015 (Build 47665) Cumulative Update 39 for Microsoft Dynamics NAV 2013 R2…
-
Integration, Microsoft Dynamics 365, Microsoft Dynamics CRM, Microsoft Dynamics NAV, Microsoft Dynamics NAV 2017
Integrate Dynamics NAV 2017 with Dynamics CRM Online
This blog post contain step wise guide on how to integrate Dynamics NAV 2017 with Dynamics CRM Online (Dynamics 365). If you like to create a temporary test CRM account, please follow below steps in the gif. Make a note of Dynamics CRM URL and user account details in a separate notepad. These details will…
-
Dynamics NAV and Windows Server 2016
Windows Server 2016 released in October 2016 with many new and interesting capabilities. For more information, see their announcement here: https://www.microsoft.com/en-gb/cloud-platform/windows-server Over the last few months, the Dynamics NAV team has been testing compatibility with this new version of Windows Server, and we are now proud to announce that Microsoft Dynamics NAV 2017, Microsoft Dynamics…
-
Awarded as Microsoft MVP – 2017
What a great way to start the new year! Second consecutive year as a Microsoft Most Valuable Professional. It is a great honor to receive the most prestigious award a person who works with Microsoft technologies can receive. The Microsoft Most Valuable Professional (MVP) award. I want to thank all the people who helped me to…
-
Wishing You All a Happy New Year!
It’s 2017 already and I wish you and all your loved once a perfect year ahead. Year 2016 is one of the best year for me due to many reasons. Specially it is the first year I got the MVP award from Microsoft for Dynamics NAV and it allows me to become the first Dynamics…
-
Preview of Dynamics NAV Development Tools – How to get Started
I think most of you know by now already that Microsoft has released new Development preview for Dynamics NAV. If you still not updated on that yet, then refer below link on the Preview of Development Tools for Dynamics NAV Preview of Development Tools for Dynamics NAV In this blog post we are going to…
-
Preview of Development Tools for Dynamics NAV
Microsoft has deiced to give an early Christmas gifts to the world by introducing new tools to build extensions and apps in and for Dynamics NAV Tool comes in two flavors and both are available in preview from today (21/12/2016). The in-client designer Before talking about it, just have a look at the below gif. I’m sure most of…
-
AL Extensions, C/AL, Development, Microsoft Dynamics 365, Microsoft Dynamics Business Central, Microsoft Dynamics NAV
Understanding COMMIT and Transaction Scope within Microsoft Dynamics NAV
Have you tried and thought about what is the transaction scope. In this blog post I am going to discuss little bit about transaction scopes and how the transaction scope works within Microsoft Dynamics NAV. In order to check the simple scope I am planning to use below code. Pretty simple, its just inserting a record…
-
Overview of User Permission : Microsoft Dynamics NAV
During last few versions of Microsoft Dynamics NAV, Microsoft has introduced some cool new features. One of my favorite is user permission (It has a long way to go, but it is getting there) . CRM and User Permission : If you have worked with Microsoft Dynamics CRM you might have noticed how good (cool) is…
-
December 2016 Cumulative Updates for Microsoft Dynamics NAV
Microsoft has published new Cumulative Updates for December 2016: Please refer below links for more information Cumulative Update 01 for Microsoft Dynamics NAV 2017 (Build 14199) Cumulative Update 14 for Microsoft Dynamics NAV 2016 (Build 47444) Cumulative Update 26 for Microsoft Dynamics NAV 2015 (Build 47438) Cumulative Update 38 for Microsoft Dynamics NAV 2013 R2…
-
Modern Dev Experience in NAV
It is a new chapter for Microsoft Dynamics NAV Community! Microsoft has released new AL language code samples for developing extensions on Dynamics NAV plaform. Thank you Microsoft Dynamics NAV development team for making this a sucess and releasing this early preview. Take a look at how a simple “Hello, World!” codeunit would look like…
-
Why Codeunit 1530 : “Request Page Parameters Helper” ignores my report filters
Hi, Last week I was working on a “Customer Statement” Report in Microsoft Dynamics NAV 2017 database. This report was a copy of the original “Statement” (Report 116). Once the modification was done, I simply change the report selection in the Database and then ran the report using Development Environment. Applied few filters to the…
-
November 2016 Cumulative Updates for Microsoft Dynamics NAV
Microsoft has published new Cumulative Updates for November 2016: Please refer below links for more information Cumulative Update 13 for Microsoft Dynamics NAV 2016 (Build 47042) Cumulative Update 25 for Microsoft Dynamics NAV 2015 (Build 47039) Cumulative Update 37 for Microsoft Dynamics NAV 2013 R2 (Build 47043) Cumulative Update 44 for Microsoft Dynamics NAV 2013 (Build…
-
Microsoft Dynamics NAV 2017 – Home Page
Hi Everyone, I will be posting blog posts about the newly realeased Microsoft Dynamics NAV 2017. This page will be the home page for those blog posts. If you need to know anything specific please post them on the commnet section of the blog post. I will be able to look into those and provide…
-
New look on List Pages – Microsoft Dynamics NAV 2017
Microsoft Dynamics NAV 2017 Web Client offers a complete new look for the list pages. Webclient comes with sevaral options to change the UI of the list pages. This is something many of client’s requested since it will be easy for them to use tile version UI with touch screens. Following are few sample screens…
-
Workflow Wizard with Microsoft Dynamics NAV 2017
In previous version on Dynamics NAV, we had the option of creating workflows, which was one of the exsiting functionalities. For previoud blog post on Workflows click here In latest Dynamics NAV 2017 product, Microsoft has taken a extra step to ease the life of partners and users. In new product you can create a…
-
Download Microsoft Dynamics NAV 2017
Now you can download Microsoft Dynamics NAV 2017!! Use below link to access the download page: Link PS: Thanks Freddy for the hot news. Please provide your feedback with a comment. Thank you and Regards,Tharanga Chandrasekara
-
New Release Date : Microsoft Dynamics NAV 2017
Microsoft has announced that they will not be realsing the new Microsoft Dynamics NAV 2017 version till end of this week. To be excat new realses date will be 28th October 2016. Please provide your feedback with a comment. Thank you and Regards,Tharanga Chandrasekara
-
Date Shortcuts in Microsoft Dynamics NAV
I have seen many users are using T when they want to get the Today in the Dynamics NAV, however they do not know thre are few more shortcut keys they can use to ease their life when working with Microsoft Dynamics NAV. Following are some of other options available in Microsoft Dynamics NAV related to…
-
Report color code to identify blank rows
Hi, If you have been developing RDLC reports for Dynamics NAV, most probably you might have come across the situations where some blank lines are printing in the body of the report and just a glance you cannot identify from where these lines are coming from. Very recently one of my colleague asked me to…