A major change to AL Language development is here! Collectible errors can hugely improve any validation procedures. And what's new? Everything is about a new data type ErrorInfo. ErrorInfo data type ErrorInfo is a new data type introduced in Microsoft Dynamics 365...
Warning: number_format() expects parameter 1 to be float, string given in /data/web/virtuals/7298/virtual/www/domains/kepty.cz/wp-includes/functions.php on line 423
AL Language
Exploring CosmosDB with Business Central, part 2
This part explains how to connect to Azure Cosmos DB from your Business Central extension using AL Language and how to get some values from the database.------------------------------------------------------------------------------------------------------------------...
Exploring CosmosDB with Business Central, part 1
Azure Cosmos DB is a fully managed NoSQL database for modern app development. Data in this database are available using APIs. To find out how to get Azure Cosmos DB, licensing and all other details see Microsoft portal...
DynamicsCon 2021 session recording available!
Finally, recordings from DynamicsCon 2021 Autumn edition are available! Check the official youtube channel. It was a great conference with over 250 people during my live session! I definitely hope I will be able to attend the next in-person DynamicsCon as a speaker...
Directions EMEA
Directions4Partners EMEA 2021 is still in progress here in Milan. I want to share all details about each day, but unfortunately, there are so many amazing things to see, watch and try I have almost no time. So today just a few words about the day before the...
Performance in AL Language development (BC2021 wave 2)
In just a few days the new major version of Business Central 2021 wave 2 will be introduced! This is again a huge set of changes that comes with this new version. In this article, we will look at the most important changes in AL Language performance (performance...
Field Level Permissions (Restricted Fields)
I just add a new project to my GitHub repositories. It is a new extension for Business Central that extends security functionalities with field-level permission. Using this extension, users are able to define who can or can not change specific fields in any table in...
How to install Business Central (developer) preview version
In the last weeks, I got some questions about installing the developer's preview version (the Insider build) of the Business Central. This version is available through Artifacts for docker similarly to standard versions; however, they are available only for Microsoft'...
Forget Confirm() method; start with Confirm Management module
For a long time, if we wanted to get input from the user to confirm something, we used Confirm() method. This method is straightforward - it has two parameters (+ unlimited number of constant values similar to StrSubstNo() method). The first one accepts text shown to...
Returning complex types in AL Language
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...
Import various file types with Interfaces
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...
PowerPlatform Community – Business Central Bootcamp session
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...
Kepty4Beginners: Flowfields in AL Language (Calculated Fields)
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...
New version of ALRM: AL ID Range Manager has just been released!
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...
How to import Excel files using Excel Buffer
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...
Kepty4Beginners: How to create a basic entity
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,...
OnAfterLookup: New page field trigger coming in v18
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...
Kepty4Beginners: AL Snippets
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