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
How to Implement a Command Queue in pure AL
In this article I show how to implement the command pattern (https://en.wikipedia.org/wiki/Command_pattern) and include it in a queue First of all we need the command interface Interface ICommand interface ICommand { procedure Execute(); } Because we want to add this to an queue we need a queue entry, i choose a codeunit to this put … Continue reading How to Implement a Command Queue in pure AL
Print Business Central Documents using Power Automate (Desktop)
Print Business Central Documents using Power Automate (Desktop)