When you have read my last post about Pipelines using NuGet you might have recognized that there is a drive in the direction of NuGet. There are already many tools and libraries which support NuGet for Business Central. But there was nothing directly in VS Code Therefore I create the AL Nuget Helper Extension for … Continue reading AL Nuget Helper Extension for VS Code
Business Central Pipeline using Nuget
Continous integration and Continues deployment are common practice for some years now. Most of the pipelines using docker environments, this is common practice for automated tests, but the start of containers is consuming some time. The container is used to get the symbols for Microsoft Apps in the right version, and mostly to get the … Continue reading Business Central Pipeline using Nuget
Exploring Interface Implementation: A Journey from Events to Enums
Abstract Last week, I had an conversation with my colleague Natalie Karolak. She faced a unique challenge: replacing an event-driven feature with interfaces. Her goal was to provide a template for end-users to implement every necessary function while ensuring the possibility of executing multiple implementations of the interface. As the designated pattern enthusiast at our … Continue reading Exploring Interface Implementation: A Journey from Events to Enums
How to copy data from one Azure SQL database to another via SQL Script
There are many scenarios were you want to copy data from one database to another, in my case it was a Business Central Upgrade which I've done some month ago. And I somehow lost some data on the way and had to transfer it again.This was the first time I worked with Azure SQL so … Continue reading How to copy data from one Azure SQL database to another via SQL Script
Creating recurring invoices in Business Central
Create a recurring purchase invoice in BC using Power automate
The (rather) unknown superstar “BCAgent”
Some weeks ago a collegue of mine akt me if there is a simple way of accessing client ressources from Business Central SaaS (and of course also OnPrem), without using .net directly from AL. I remembered a session where someone talked about the BCAgent (I guess it was on BC TechDays). After some researching I … Continue reading The (rather) unknown superstar “BCAgent”
The object oriented way of JSON handling in AL – Part 1
On the left side we have a normal JSON formatted object, on the right side we have a normal AL implementation of JSON generation Item JSON Object { itemNo: "123", price: 10.25, description: "Insane Item", ... ... ... active: true, variants: [ { description: "Total insane variant" }, { description: "not so insane variant" } … Continue reading The object oriented way of JSON handling in AL – Part 1
Compare Business Central versions easily with Azure Devops
In preparation for a What's New webinar (organized by COSMO CONSULT) I wanted to compare the code of BC19 with BC20. This task is a challenge for most comparison tools. However, not for the GIT comparison tools which are integrated in Azure DevOps. I had the idea to generate a pipeline which copies the current … Continue reading Compare Business Central versions easily with Azure Devops
Using the “Template method pattern” in AL
In this blogpost I continue my series of design patterns for AL. This time I write about a simple pattern which could make the readability of your code much better. I'm talking about the "Template method pattern". The pattern defines the skeleton of a process without implenting it. The real implemenation is handelt in another … Continue reading Using the “Template method pattern” in AL
Part 2: How to Implement a Command Queue in pure AL
In my last blogpost I wrote about how we can implement a Command Queue in AL. In the second part I will go a little bit in detail about the Solution. First of all you have to understand the differenences between valuetypes and referencetypes. If you already know you skip to the next paragraph. TL;DR; … Continue reading Part 2: How to Implement a Command Queue in pure AL