Tharanga Chandrasekara

Over ten years of experience in developing and implementing software solutions within the banking, tourism, manufacturing, education and retail sectors. Proven success of technical and functional skills in Technical Solution Development, Technical Consultation, Business Process Analyst, Process Re-Engineering, Solution Design, Project Management, Research & ERP Implementations. Managed and participated in over 40+ successful ERP (Microsoft Dynamics NAV) implementations during the past 10+ years while building relationships and exceeding client and management expectations. Possess a strong ability to turn around at-risk projects and deliver unique results. Recognize the value of being friendly, calm and helpful when interacting with people in all areas of life and always willing to learn new skills to build on strengths and learn from experiences. Active member and a community moderator of the official Microsoft Dynamics NAV Community forum and regularly share knowledge with others through personal Dynamics NAV Blog, user groups and webinars. Strongly believes that "one small piece of knowledge someone shares today could be the cornerstone of a huge concept that changes the world tomorrow". Recognized as a Microsoft MVP (Most Valuable Professional) for the years 2016, 2017, 2018 and 2019. It is the only Dynamics NAV MVP in New Zealand and Sri Lanka. Specialities: » Development Languages: AL, C/AL, » ERP: Microsoft Dynamics NAV 5.0 to Business Central » Databases: MS SQL » Other: SANA, LS Retail

Author's posts

Business Central Performance Profiler

If a business process takes longer than expected, your administrator can use the Performance Profiler page to record a snapshot of the process. While recording, the profiler monitors all of the apps that are involved in the process.

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 …

Continue reading

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 …

Continue reading

Docker: You cannot sign in due to a technical issue. Contact your system administrator.

Docker: You cannot sign in due to a technical issue. Contact your system administrator.

Incorrect URL: http:///BC/SignIn

Correct URL: http:///BC/SignIn?tenant=default

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

One beautiful thing about Microsoft Dynamics 365 Business Central is that it allows you to have a read-only replica of the Azure SQL database and use that replica database to perform read-only queries to retrieve data. Queries to retrieve data running on the replica database, your main database instance will run smoothly without any performance impacts.

OAuth – Part 05 – Service-to-Service Integration and Task Scheduler

In Basic authentication, we used an actual user to connect to BC, but with the new S2S authentication we are not using an actual user and Scheduled tasks must be created and executed in the context of a licensed user. Therefore API requests cannot schedule a background task. It is simple as that.

Microsoft Dynamics 365 Business Central 2022 release wave 1 (BC20) SaaS preview environment is available.

Creating a Microsoft Dynamics 365 Business Central 2022 Wave 1 preview environment is now possible. You need to go to the Admin Center of the Business Central tenant and create a Sandbox and select the version. Make sure to select 20.x.xxxxx.x (Preview) and click Create. To remember, Microsoft will sometimes remove these preview environments without …

Continue reading

OAuth – Part 03 – Logic App, OAuth and Business Central

This is the 3rd blog post of the OAuth series, and I have already completed the numbers 2 and 4. Once I complete this blog post today (Hopefully), I only have one to write. I will try to complete that one also within next week when I find some time during the night. I have …

Continue reading

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.

OAuth – Part 02 – Configure Service to Service Authentication

In this blog post, I’m going to take you through the steps required to complete the OAuth client credentials flow for Business Central. Check this link if you want to refer to the official post from Microsoft.