Jun 25
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.
Jun 25
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.
Mar 05
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 …
Feb 27
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 …
Feb 16
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.
Feb 16
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.
Feb 10
If you want to get the details about the environment you don’t have to reinvent the wheel, you can simply use the standard codeunit Microsoft has introduced. If you look into the codeunit 457 “Environment Information”, you will see there are many procedures that fetch attributes concerning the environment of the service on which the tenant is hosted. Codeunit 457 is part of the System Application.Source.
Feb 10
A temporary table is a temporary variable that holds a table. A temporary table is used as a buffer or intermediate storage for table data.
You can use a temporary table just like you use a database table. The differences between a temporary table and a database table are as follows:
A temporary table data isn’t stored in the database. It’s only held in memory until the table is closed.
The write transaction principle that applies to a database table doesn’t apply to a temporary table.
Sep 04
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 …
Oct 20
If you have not read my previous blog posts about the Implicit WITH, I suggest you read them to get a better understanding of the Implicit WITH. Also, you can read the Microsoft Docs to get more information as well. NoImplicitWith – The name #FieldName does not exist in the current context NoImplicitWith: The type …
