Category: AL Extensions

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.

How to get Business Central Environment Related Attributes?

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.

TableType Property = Temporary

Ram Cards

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.

Quick fix for warning AL0604: Use of implicit ‘with’ will be removed in the future.

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 …

Continue reading

NoImplicitWith: The type or method ‘Copy’ cannot be used for ‘Extension’ development.

If you have not read my previous blog, I suggest you read it to get a better understanding of NoImplicitWith. Microsoft recently announced about obsoleting the WITH statement and if your app.json file contains NoImplicitWith as a feature then you will probably be getting below error. The type or method ‘Copy’ cannot be used for …

Continue reading

NoImplicitWith – The name #FieldName does not exist in the current context

If you have used WITH statement in your AL code to make the code readable, then this blog will be helpful for you. There are people who completely support the use of WITH statement and I also was on that category a few years ago. Fortunately, I moved on from the use of WITH statements. …

Continue reading

Navigate directly to a symbol of a file in VS Code

How would feel about if you can directly navigate to a symbol of a file? It is now possible in VS Code.  All you need to do is press “Ctrl” + P and type the object name you want to navigate to and then press @, it will list down all the fields, functions and …

Continue reading

Object types is case sensitive in TenantWebServiceCollection

Last week while I was working on an integration project, I wanted to call a Business Central function from Azure Logic Apps. I had few options with APIs but I went ahead with creating a CodeUnit with a function and expose it as a web service.   Rather than exposing the CodeUnit by manually inserting …

Continue reading

Obsoleting Microsoft Dynamics 365 Business Central Events

If you are working on the extension development, then I’m sure that you already have published and subscribed to many events. There are some rules that you should strictly follow around events if your extension is eventually be used by another partner to build their solution on top of yours.  Business Central has two types of events …

Continue reading