In Microsoft Dynamics 365 Business Central 2021 w1 (released in May 2021), a profound change was introduced to ways how we can design our applications Until this version, the only way to return complex data types (like records, codeunits, Lists etc.) was using the var...
A few weeks ago, I described a solution for importing an Excel file to the Business Central using Excel Buffer in AL Language (see here). In today's article, we will look at how to build a more complex solution that can be used for file imports without the needs to...
The Business Central Bootcamp conference is almost here! Let's check all sessions and find your favourite ones at https://events.powercommunity.com/business-central-bootcamp/. You can register for the event using this registering form for FREE! I am part of this...
Not all fields in AL Language are stored in SQL Database. Flowfields are a great example of these fields. Flowfields are special field type that allows you to create a field that loads a value from another field within the same or even different table. In the AL...
Today I have released a new version of both the ALRM (AL ID Range Manager) extension for Visual Studio Code and Microsoft Business Central. If you do not know what ALRM is, check some of previous articles here on my blog. Both extensions are available on my GitHub...
Last week, I saw a question about importing data from Excel file to Business Central using AL Language. A few years ago, the only solution was to use DotNet integration. However, with the Business Central, there is a much quicker and better approach. All functions for...
In today’s beginner series article, we will look at how to create a basic entity such as Item, Customer, Vendor etc. Creating basic entities is one of the core things anyone has to know. It is also necessary to know which properties must be defined (LookupPageID,...
One of the news in AL Language that is coming with the upcoming major version (Business Central 2021 W1) in April is a new trigger AnAfterLookup. The new trigger is described on Microsoft Docs (however, the description is still a bit confusing…). As the Lookups are...
In today's beginner series article, we will look at Snippets in AL Language. What are snippets? How can we use them? What is the reason to know how to use them/when to use them? All these questions are answered in the video below! https://youtu.be/XIhSNkUdewc
The first article from my new youtube channel is here (if you want to find out why I have decided to start my own youtube channel, see here)! This is the very first video for beginners - how to create a new AL project. In this video, we will look at how to create a...
It is only four months since the last major version of the Business Central (2020 wave 2) has been released, and we can already look forward to another version that will be released in April. Microsoft has already provided the list of planned and confirmed...
AL ID Range Manager is VS Code & Microsoft Dynamics 365 Business Central extensions made for developers who need to manage their object/field IDs across multiple projects (or in the multi-developers environment). Source codes are available online on GitHub...
This is another article about Partial Records (as we already discussed earlier in the article about Partial Records and later in the first part of articles about partial record's performance). In this article, we will explore the ration between performance, partial...
I am glad to announce that the very first version of AL ID Range Manager is available for everyone on Visual Studio Code Marketplace! AL ID Range Manager is an extension for VS Code that helps with managing AL objects between developers who are working on the same...
Partial Records in the Business Central are a new technology in 2020 wave 2 release. Let's look at the quick description in one of the posts from previous month "Partial Records". Now check it in more details. In this first part, we will look at how the partial...
Partial Records are a new capability of Business Central introduced in Business Central 2020 release wave 2. It allows specifying fields that should be loaded when accessing SQL based data. How does it work? Without using partial records, Business Central normally...
This is 3. part from the article series about Interfaces in AL Language. See the first one or the second one. In previous parts, I have described the basics of Interfaces in AL Language (what is an interface, how to work with them in AL and started working on advanced...
This is 2. part from the article series about Interfaces in AL Language. See the first one. In the first part of this series, I have described what Interfaces are and showed the example of how they can be created. In this article, I will show a more advanced example...
