hello@tharangac.com New Zealand & Australia

Category: Uncategorized

  • The Long Road Toward a New Beginning

    The Long Road Toward a New Beginning

    There comes a point in every career where experience quietly changes shape. It stops being about learning new tools or delivering the next project and starts becoming something more personal. How you want to work. What you want to build. The kind of impact you want to leave behind. After fifteen years across multiple companies,…

  • Search, navigate and use app symbols as context for GitHub Copilot

    Search, navigate and use app symbols as context for GitHub Copilot

    Working with large AL codebases and multiple dependencies can often make locating specific objects or references difficult. With the latest updates, we can expect significant improvements! Search Downloaded Symbols with Ctrl+T It is now possible to search AL objects from downloaded symbol packages directly in Visual Studio Code using the ‘Open Symbol by Name’ (Ctrl+T)…

  • Directions EMEA 2023

    Directions EMEA 2023

    This year, Directions EMEA is happening in Lyon, France, from the 1st of November to the 3rd of November. At the time of writing the article, over 2,500 people had already registered for the conference. I will lead two sessions with Stephen, which are related to Business Central integrations. The first session is more about…

  • How to create a version 22 Sandbox (latest)

    How to create a version 22 Sandbox (latest)

    Microsoft allows customers and partners to create version 22 Sandboxes so that partners and customers can start preparing for the next major release. Follow the blogs post to know how to create a new sandbox.

  • Read Data from Dynamics 365 Business Central Replica Database (Data Access Intent) – Part 2

    Read Data from Dynamics 365 Business Central Replica Database (Data Access Intent) – Part 2

    My previous blog post discussed the benefits of using the read-only replica database. You can read it here. I want to share a little bit more about the new option available with Business Central APIs. Microsoft’s dynamics 365 Business Central Wave 2 release (version 19) onwards allows you to specify the Data Access Intent directly…

  • The request was blocked by the runtime to prevent accidental use of production services.

    The request was blocked by the runtime to prevent accidental use of production services.

    Once you create a Sandbox by copying over a production environment and trying to make HTTP requests, it gets blocked to prevent the use of production services. If you want to enable the requests going through, go to the Extension Management page and select the extension initiating the HTTP request. Go to the settings of…

  • OAuth – Part 04 – Understanding Service Principal
    , , , , ,

    OAuth – Part 04 – Understanding Service Principal

    In my previous blog post, we have gone ahead and registered an application in Azure Active Directory and then create an application account in Business Central. As the last step, we have granted permission from Business Central. In this blog post, I’m trying to briefly explain what we did in little bit more detailed way.

  • Lesson learned during Dataverse integration: Namemapping = ‘Logical’ was not found in the MetadataCache.
    , , , , ,

    Lesson learned during Dataverse integration: Namemapping = ‘Logical’ was not found in the MetadataCache.

    Yesterday I was working on integrating a custom entity using the box connector for Dataverse in Microsoft Dynamics 365 Business Central. After completing all the changes and deploying the app to a sandbox environment, I tried to open the custom entity table through its list page. Unexpectedly I ran into below dialogue box. The entity…

  • Force Lock

    Microsoft Dynamics NAV Object Designer have a option to “Force Unlock” the Objects which are locked by another developer. However I feel that it should have a option to “Force Lock” the objects. What you think? It will be much more easier than Force Unlock and then Lock again. Please provide your feedback with a comment. Thank you and…

  • What is New in Microsoft Dynamics NAV 2017?

    Microsoft has published a “What’s New in Microsoft Dynamics NAV 2017 Limited Beta” document on partnersource and it contain some of the very limited functionalities of Dynamics NAV 2017. I feel that there will be much more functionalities will be available on the actual Microsoft Dynamics NAV 2017 version.  According to the released document following are the main…

  • Microsoft Dynamics NAV 2017 – Limited Beta Version Available for Download

    Microsoft has released the Limited Beta Version for Microsoft Dynamics NAV 2017!! You can download it from the below link:  Download NAV 2017 Limited Beta. You need to fill the Dynamics NAV 2017 Limited Beta Agreement before you download theapplication. Stay tune for more info on Microsoft Dynamics NAV 2017 Please provide your feedback with…

  • Error: Configuration file required – Microsoft Dynamics NAV

    Double click on the Dynamics NAV icon but open up this window?  This error message pop up mainly because Microsoft Dynamics NAV cannot find the “ClientUserSettings.config” in the client computer. Most of the time Microsoft Dynamics NAV create this file itself and very rarely Microsoft Dynamics NAV will not be able create the file for you. In those kind…

  • Few more weeks to go : Microsoft Dynamics NAV 2017 & Roadmap

    In few weeks time Microsoft will release the Microsoft Dynamics NAV 2017. Few months ago Microsoft has published the latest Dynamics NAV roadmap and from that we can get a glimpse of what will be on next version.  You can check more related videos from the “World Partner Conference“. As  mention in his blog post following are…

  • Fatal Error During Installation – Microsoft Dynamics NAV

    Today I tried to install Microsoft Dynamics NAV 2015 to my computer to test few objects and soon after I click on install I got below error message. This is not a new error message and I thought why not share it in my blog.  As the error message says by itself, this is due…

  • The profile owner has not been specified. Contact your system administrator – Microsoft Dynamics NAV

    Check my previous two blog posts on how to Open the Microsoft Dynamics NAV RTC Client in Configuration Mode.  Open the Microsoft Dynamics NAV RoleTailored Client in Configuration Mode – Part 01 Open the Microsoft Dynamics NAV RoleTailored Client in Configuration Mode – Part 02 Once you tried to open the RTC in the configuration…

  • September 2016 Cumulative Updates for Microsoft Dynamics NAV

    Microsoft has published new Cumulative Updates for September 2016: Please refer below links for more information. CU 11 for Dynamics NAV 2016 (Build 46773) CU 23 for Dynamics NAV 2015 (Build 46765) CU 35 for Dynamics NAV 2013 R2 (Build 46774) CU 42 for Dynamics NAV 2013 (Build 46772) It is always good to update…

  • Open the Microsoft Dynamics NAV RoleTailored Client in Configuration Mode – Part 02

    If you didn’t went through the first part of the blog here is the link to it. If you have read the first part of the blog of “Open the Microsoft Dynamics NAV RoleTailored Client in Configuration Mode” and paid very close attention to the second command of it, you might have seen something interesting.…

  • Open the Microsoft Dynamics NAV RoleTailored Client in Configuration Mode – Part 01

    In order to configure a Microsoft Dynamics NAV Profile, administrator should open the profile in the configuration mode. It will allow the admin to remover the unwanted pages, action buttons from the user’s interface and make it more user role specific. This may sound bit old school to many of the people, but still this will be very useful…

  • Invalid License Data – Visual Studio

    If you tried to open the report designer using Visual Studio and got the below error?  Error it self says “Reinstall is required”, but it never says what you need to reinstall. Is it Microsoft Visual Studio, or Microsoft Visual Studio 2010 Shell? I tried re-installing Microsoft Visual Studio, then tried installing Visual Studio 2010 Shell,…

  • Allow users to filter random records in Dynamics NAV

    Most of the users would like to select few records (No commonly shared value) and filter them to a single view. I have seen many of the users use export to excel option available in Microsoft Dynamics NAV and then filter the records from excel so that they can compare them freely.  What if we…

  • August 2016 Cumulative Updates for Microsoft Dynamics NAV

    Microsoft has published new Cumulative Updates for August 2016: Please refer below links for more information.CU 10 – Microsoft Dynamics NAV 2016 (Build 46621)CU 22 – Microsoft Dynamics NAV 2015 (Build 46580)CU 34 – Microsoft Dynamics NAV 2013 R2 (Build 46577)CU 41 – Microsoft Dynamics NAV 2013 (Build 46576) It is always good to update…

  • Data Source name not found and no default driver specified. State ID: IM002 – Dynamics NAV

    Hello everyone, It has been few weeks since my last blog post.Directly into blog post, Have you ever got below message when you try to open the database using development environment or classic client in Microsoft Dynamics NAV? Today I got below error when I tried to open up the Microsoft Dynamics NAV 2013 Development…

  • July 2016 Cumulative Updates for Microsoft Dynamics NAV

    Microsoft has published new Cumulative Updates for June 2016: Please refer below links for more information. CU 9 – Microsoft Dynamics NAV 2016 (Build 46290) CU 21 – Microsoft Dynamics NAV 2015 (Build 46293) CU 33 – Microsoft Dynamics NAV 2013 R2 (Build 46296) CU 40 – Microsoft Dynamics NAV 2013 (Build 46292) It is…

  • June 2016 Cumulative Updates for Microsoft Dynamics NAV

    Microsoft has published new Cumulative Updates for June 2016: Please refer below links for more information. CU 8 – Microsoft Dynamics NAV 2016 (Build 46045) CU 20 – Microsoft Dynamics NAV 2015 (Build 46054) CU 32 – Microsoft Dynamics NAV 2013 R2 (Build 46057) CU 39 – Microsoft Dynamics NAV 2013 (Build 46056) It is…

  • How Many Lines Can be Added In Between Records?

    In my previous blog post I have discuss about AutoSplitKey function in Dynamics NAV. If you have missed that click here to open the previous blog post.  I ended my previous blog post with a question and hope at least some of you have try and tested your answer in Dynamics NAV development. If not…

  • AutoSplitKey

    What is AutoSplitKey?? According to the MSDN, AutoSplitKey is defined as, Sets whether a key is automatically created for a new record placed between the current record and the previous record. This means when you enter a record in between two records, Dynamics NAV will split the last field of the primary key group and create…

  • Code Behind “How to Prevent Negative Inventory” – Versions After 2013

    As mention in my previous blog post (How to Prevent Negative Inventory – Versions After 2013) Microsoft has added a option to prevent negative inventory in Microsoft Dynamics NAV. To find the code behind the validation I have import all the object files to “Statical Prism”. Then I search for the Inventory Setup table which…

  • How to Prevent Negative Inventory – Versions After 2013

    In my previous blog post I have explained on “How to Prevent Negative Inventory” in the versions which came before Microsoft Dynamics NAV 2013 R2. In this blog post I will describe “How to Prevent Negative Inventory” in the versions which came after Dynamics NAV 2013.  Luckily, Microsoft has finally added a control to validate…

  • How to Prevent Negative Inventory – Versions Before 2013 R2

    In the Microsoft Dynamics NAV Community Forum many users post questions about how to prevent negative inventory. These questions are related with all the product versions in Dynamics NAV. This blog post will contain the information about “How to Prevent Negative Inventory” in Dynamics NAV.  In the earlier versions (Before Microsoft Dynamics NAV 2013 R2)…

  • Cumulative Update 7 for Microsoft Dynamics NAV 2016 has been released (Build 45834)

    Cumulative Update 7 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

  • Cumulative Update 31 for Microsoft Dynamics NAV 2013 R2 has been released (Build 45822)

    Cumulative Update 31 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with…

  • Cumulative Update 38 for Microsoft Dynamics NAV 2013 has been released (Build 45787)

    Cumulative Update 38 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

  • Cumulative Update 19 for Microsoft Dynamics NAV 2015 has been released (Build 41779)

    Cumulative Update 19 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

  • Shortcut Keys in Dynamics NAV 2016

    The following shortcut keys are quite helpful, specially if you prefer using the keyboard instead of the mouse. You can definitely increase your work speed in daily doing using these shortcut keys and also it will look like you are an export on Dynamics NAV. 🙂  Key Event Right Arrow Move to the next field…

  • 25 Best Dynamics NAV Blogs of 2016

    Yesterday dynamics101 announced 25 top Dynamics NAV websites for 2016. I am really glad to see my blog is also listed as one of the top 25 blogs. I really appreciate all the people who supported to me to come this far and hope they will be around and support me in the future also.  Once again thank…

  • Dynamics NAV 2016 Indian Localization is Now Available to Download

    Most of the cases I personally prefer to use W1 version because it is less complex and hassle free, However if the TAX structure is complex then my first choice is Indian Localization. There are many added features available in the Indian localisation and now it is available to download.  Click here to download.   Please provide your feedback with a comment.  Thank you…

  • Azure Roadshow 2016 #SLAzureRoadShow

    Link : http://slazureroadshow2016.azurewebsites.net/ During the event I will be doing a session on “Deploying and Managing Microsoft Dynamics with SQL Azure”. If you are interested just join with us to get to know more about Azure.  Following is my session description : To have better security, performance and to reduce maintenance cost many modern world business…

  • Cumulative Update 37 for Microsoft Dynamics NAV 2013 has been released (Build 45477)

    Cumulative Update 37 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

  • Cumulative Update 30 for Microsoft Dynamics NAV 2013 R2 has been released (Build 45478)

    Cumulative Update 30 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with…

  • Cumulative Update 18 for Microsoft Dynamics NAV 2015 has been released (Build 41779)

    Cumulative Update 18 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

  • Cumulative Update 6 for Microsoft Dynamics NAV 2016 has been released (Build 45480)

    Cumulative Update 6 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

  • Microsoft #Build2016

    Build is underway, watch it live at Channel 9 Microsoft continues to focus on enabling developers to do amazing work as businesses and industries transform in support of the shift to a cloud-first, mobile-first world. At Build 2016 we will present the latest tools and technologies and how they can help today’s developers be their…