Recently, Microsoft has been doing a lot to improve Word reporting. However, Word reporting is still lagging behind, and many developers prefer working with RDL/RDLC. So, what is Word lacking, and can it ever become a viable reporting system? A logical question also arises: why put so much effort into improving Word when RDLC could be enhanced instead? I will attempt to answer these and other questions in this post.

When you've been blogging for several years, the articles you wrote long ago can become outdated and less relevant. This is a perfectly normal and natural process. "Here we must run as fast as we can, just to stay in place. And if you wish to go anywhere, you must run twice as fast as that." That's why I'm doing a summer cleaning of my old articles and projects to keep them up-to-date with current realities.

Have you heard about the addition of the ternary operator in AL? Some developers are happy, while others say that it is very bad. In some ways, I am closer to those who believe that there is more harm than good in it. However, I still believe that the tool itself has a neutral connotation; it all depends on who uses it and how they do it. I want to thoroughly analyze the pros and cons of using the ternary operator with examples. Where it is worth using and where it is better never to use it.

Table Data Editor is an open-source application for Business Central. This application allows you to easily manipulate data in Business Central tables. Table Data Editor is completely free and open-source, distributed under the MIT license. Anyone can contribute or share their ideas for the development of Table Data Editor on GitHub.

I think integrating Sharepoint into Business Central is a fairly common request. The standard library already supports some level of Sharepoint/OneDrive integration out of the box, but it is quite limited. What if we need more advanced logic? In that case, we can use Sharepoint Interfaces from the System Application! But did you know that this will only work if the user has permissions on Sharepoint? Regardless of whether we are using Microsoft Entra Application, it all comes down to the authorization that Sharepoint Interfaces use by default. Let's dive in and understand this better.

In one of my series of posts, I examined Number Series and Number Sequences from a performance perspective. I am pleased to report that the situation has significantly improved starting from Business Central 24! I will focus on the cloud version.

I think Friday is the perfect day to break Business Central! Very dangerous, do not repeat this on Production!

ShortCutKey is a fairly well-known property for actions in Business Central. But did you know about such a unique ShortCutKey as Return? Let's talk about it.

Previously, we thought that in the future robots would sweep the streets while humans engaged in creative activities. Now the future has arrived, but it's the robots that are being creative, and humans are sweeping the streets. This text is unusual for me. Typically, I write about the technical aspects of Business Central, preferring to use programming languages and technical analysis. This article, however, will be more of a general reflection on my view of AI as a whole.

Sometimes we need to know the current CallStack in the code, but what if we only have GetLastErrorCallStack and we don't have any error?

Business Central is partially an open-source product and anyone can contribute to the app. Today I will tell you how to do it and what is specifically available. To give an example, I will show how to contribute to the System Application.

This is a continuation of the discussion of Number Series and Number Sequence. This time we will be testing in Cloud Business Central. We will also encounter unexpected results and try to understand the reasons. We will do SQL statement analysis as well.

It is fairly common practice to use Number Series to generate a key field value for a table in Business Central. This is very convenient, but do you know how slow it is? Let's try to look at examples and performance measurements, talk about Number Series and Allow Gaps, as well as Number Sequence.

Today, I want to share an updated universal SendRequest method. Additionally, I'd like to show an example of working with multipart form data.

I would like to introduce a major update for Table Data Editor in Business Central. It includes new features such as Sort, Update Column, and Find & Replace. Additionally, I have decided that considering the number of changes since the release, it makes sense to name the application Table Data Editor 2.0.

It may seem like working with text is one of the simplest things to do. However, in reality, it is quite a deep topic and not as easy as it may appear at first glance. In this article, we will cover the main approaches to working with text, as well as discuss the issue of text encoding.

Welcome to my blog, where today I am excited to introduce you to a new tool that will make a developer's life easier when working with APIs in Business Central. The API Object Generator is a tool that simplifies the process of generating objects based on XML or JSON data. As many of you are likely aware, working with XML and JSON data in Business Central can be a time-consuming process. However, the API Object Generator automates the generation of objects based on the information contained within these formats, which saves developers a significant amount of time and effort. By automating the generation of objects, developers can focus on more important tasks, such as designing and implementing APIs that meet the needs of their clients.

List and Dictionary are powerful data types for working with data. Every Business Central developer needs to know and be able to work with them. Today I want to describe basic examples of use and also go into more details, such as nested lists and dictionaries, how to read or write data and etc.

Continuing to develop my free extension for editing any table in Business Central directly. This time I offer you the feature to insert a new record in any table!

PDFObject is a library that runs the standard built-in PDF renderer in the browser. This means that the rendering in different browsers may be different. This is a very interesting option for displaying PDFs in Business Central, as browser-based PDF Viewers often have powerful functionality.

Today I'm going to talk about how we can use JavaScript AddIn to create a drag & drop factbox for files in Business Central.

The purpose of this post is to learn the basics of working with XML and SOAP in AL. Besides, we'll look at my suggestion of the generic API method SendRequest(), which fits most APIs without authorization. The authorization itself is not difficult to add to the general logic, but in the post, they are not considered due to their large number and often unique logic.

One of the frequent requests I hear from users is the WYSIWYG editor. Unfortunately microsoft has not added the editor yet. So I decided to integrate some free editor to Business Central. My choice was summernote, a simple and functional WYSIWYG editor. I will also talk about new app updates.

I run a technical blog about Business Central & Navision, I've always been far from politics. But what is happening to my country does not allow me to remain silent, my country was treacherously attacked at 4 am without a declaration of war. Russia bombed peaceful cities, many civilian victims, children. There are also rocket attacks on our infrastructure from the territory of Belarus. In my hometown of Zhytomyr, residential houses were shelled by these rockets, there are civilian casualties, a school in my hometown was destroyed. Why shoot at a school? This war is anti-human, Russia must leave my country.

Data manipulation is one of the most trivial things for Navision/Business Central Developer. We are constantly working with data in tables, adding, deleting, modifying, and so on. Today we're going to discuss data grouping. What does it mean to group data? How do you do it in AL? What is the best and fastest way to do it? I hope we can find answers to all these questions.

I would like to discuss some strange flaws with the RecordRef.Rename() method. And I don't even mean the logical limitations that you can observe because of SQL server mechanisms. Let's take a closer look at the design of this method.

I would like to thank everyone who provided feedback on the Table Data Editor application. I tried to listen to your suggestions and criticism to improve the application. I will still appreciate your feedback, you can also create a Github issue describing the problem. Thanks to your input the application got the support of new features I want to tell you about.

You probably remember the glory days when we had direct access to data in Navision tables. But with the move to Cloud Business Central, we lost that ability. It's probably much safer and more correct, but what if we need to fix some data problem and we know what we're doing? We can write a routine that fixes that problem. But I suggest a better option, this Data Editor extension that allows you to change and delete information from any table in Business Central.

Business Central Docker: Quick Start Guide

I have prepared a lightweight ready to go extension for viewing PDF documents in Business Central.

What if we have a loop in which some actions occur that can cause an error. What if we need to continue iterating through the loop after the errors and save the errors to the log? Today I will show you how this can be done even for transactional operations.

We all know that Visual Studio and the RDLC report format partially support dynamic rendering of HTML content from the control. But only partially, many tags are simply ignored. And if we have a word template, what can we do in this case? Today I will share the result of my analysis and provide a working example code for word template reports. We will also learn how to convert docx to html and vice versa.

Recently, faced with a funny example of bad code in Base Application, I got the idea to write about this case and not only. This case illustrates how much work remains to be done in rewriting and improving our beloved Business Central product.

Continuing my cycle of posts on basic examples of integrating third-party applications with Business Central, I decided to choose Spotify API for demonstration.

Partial records. Performance improvements for Business Central.

FilterGroup(-1), cross-column search in Business Central and Navision.

Integration REST API to Business Central. Parse JSON and store data via AL. New York Time API.

Storing passwords directly in a table is a bad idea from a security point of view.For secure storage of passwords, the Service Password system table was previously used. In Business Central 15.0, it has been removed.

Today I want to talk about the Copy function. Specifically, about one seemingly innocent property.

Visual Studio Code - Useful extensions for AL development