-
AL Extensions, Development, Microsoft Dynamics 365, Microsoft Dynamics Business Central, Microsoft Dynamics NAV, PowerShell, Tips and Tricks
Your program license does not allow you to publish
We recently ran into a new issue when we try to push one of our extensions to Microsoft Dynamics NAV 2018 On-premise installations. We used PowerShell script to upload the extensions to production and we did this couple of days ago too without an issue. However this time we got the below error during the installation :…
-
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…
-
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…
-
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…
-
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…
-
AL Extensions, C/AL, Development, Microsoft Dynamics 365, Microsoft Dynamics Business Central, Microsoft Dynamics NAV
My two cents on Dynamics NAV Extensions
Today morning I was reading few blog posts from Microsoft Dynamics NAV MVPs on Dynamics NAV future. In most of blog posts they have focused on the extensions and freezing Dynamics NAV code. Some of them have talked positive about it and some of them have talked against it. Even though I do not attend any of the Dynamics NAV conferences due to…
-
October 2016 Cumulative Updates for Microsoft Dynamics NAV
Microsoft has published new Cumulative Updates for October 2016: Please refer below links for more information Cumulative Update 12 for Microsoft Dynamics NAV 2016 (Build 47042) Cumulative Update 24 for Microsoft Dynamics NAV 2015 (Build 47039) Cumulative Update 36 for Microsoft Dynamics NAV 2013 R2 (Build 47043) Cumulative Update 43 for Microsoft Dynamics NAV 2013…
-
Now use Microsoft SQL Server 2016 with Microsoft Dynamics NAV
SQL Server 2016 released in June this year with many new and interesting capabilities. For further information, please take a look at the product information at this location:https://www.microsoft.com/en-us/cloud-platform/sql-server Over the last few months, the Dynamics NAV team has been testing compatibility with this new version of SQL Server, and we are now proud to announce…
-
Microsoft Dynamics 365 first look
“Get your first look at the next generation of intelligent business applications” Join us Tuesday, October 11, at 2:30 PM EST for a first look at the next generation of intelligent business applications. You can be one of the first to hear Executive Vice President Scott Guthrie share Microsoft strategy for digital transformation and unveil…
-
Workflows in Microsoft Dynamics NAV 2016
From now on you will be able to find some of my blog posts in the Theta NAV Blog as well. Following is my first blog post under Theta NAV Blog. Workflows in Microsoft Dynamics NAV 2016 Microsoft Dynamics NAV 2016 has been released with many new features which will cater for small to mid-sized…
-
Microsoft Dynamics NAV 2017 – New Announcement | Part 02
These are some of more news from Directions 2016.. Stay tuned for more info on Microsoft Dynamics NAV APPSOURCE Hope most of you already know App Store or Google Play, like that AppSource will be the place where customers by apps for Dynamics365 which are built with extensions. I don’t know much info about this at this time,…
-
Microsoft Dynamics NAV 2017 – Release Date and new Announcement | Part 01
As most of the NAV fans know #NAVDirections is underway in US. Even though I could not participate to it (Next year for sure), there are so much of information flowing about Microsoft Dynamics NAV 2017 and Dynamics 365. Daniel Rimmelzwaan and Saurav has shared many details about the new announcement and I have added the link on their…
-
What’s New in Microsoft Dynamics NAV 2017 [Published]
Microsoft has released the “What’s New in Microsoft Dynamics NAV 2017” document and related documents. You will be able to find many details about Microsoft Dynamics NAV 2017. Following are few links that you might be interested of : Get Ready Page What’s New in Microsoft Dynamics NAV 2017 Microsoft Dynamics NAV 2017 Beta Program Learning Plan…
-
Microsoft Dynamics 365 Pricing and Licensing
Microsoft Dynamics 365 is the next generation of intelligent business applications in the cloud. Microsoft 365 unifies CRM and ERP capabilities by delivering new purpose-built applications to help manage specific business functions, including Sales, Customer Service, Field Service, Operations, Marketing, Project Service Automation and Financials. In order to provide detailed training Microsoft has created pricing…