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...
With Microsoft Dynamics 365 Business Central 2020 Wave 1 (respectively with Runtime 5.0) a new object type has been introduced - Interfaces. This term is well known from other programming languages and probably a lot of readers have already used them in some way. The...
Enum is a new data type in the Business Central introduced with the very first version of Business Central. Since then many changes have been done to them and currently, they are usable instead of Option data type without any hesitation. In compare to Option, Enums...
Even if customizing of the core apps is not recommended, sometimes it is still necessary (as I already described in the previous article). So let's look at how to do it. Requirements There are no special requirements to change the Base App. The only thing that needs...
With upcoming new major version of Business Central (2019 wave 2 /15.0), there is a lot of breaking changes that we have to work with. One of the first any developer probably find out is warning about using of TempBlob record variable. This record is usually used as a...
Although it is really not the way how we should develop new functionality, it is sometimes still necessary to customize standard code in Base Application. I do not usually allow developers working on my projects to customize the standard apps if it is not absolutely...
