Category: Development

Are you looking for an Action image browser in BC?

AL developers for Microsoft Business Central need to browse the Business Central image gallery to select meaningful images. This allows them to assign these images to new action buttons, enhancing the user interface for better usability. The AZ AL Dev Tools extension simplifies this process by adding new commands that load and display available images …

Continue reading

Decluttering Your Enums: How to Show Only What Matters

It is common practice to use existing objects when developing new modules. Microsoft Dynamics 365 Business Central offers a wide array of pre-defined enums; however, specific options within these enums may not be relevant to the new module’s requirements. Additionally, there may be instances where it is advisable to restrict users from selecting specific values …

Continue reading

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.

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.

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.

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