Moving From C/AL to AL

Finally I was able to attend a two days online training in order to get a solid introduction into AL Programming.

I can highly recommend this course to any C/AL developer who want’s to get started with AL quickly.

The intend of this post is not to go into the details of this training. Rather I want to point out the my top take-aways:

1. Be prepared for the cloud (NAV BC SaaS). A lot if smart people mention this as the first rule whenever you have to make a decision.

2. Get yourself trained on the concept of Microservices as this is probably also a very good approach for extension design.

3. Learn about the Power Platform. The connection between NAV BC and the Power Platform is getting better and better. So you should at least consider using the Power Platform in certain cases.

4. Get familiar with Azure and Azure functions. My feeling is that you will need them more and more.

5. When redesigning any NAV C/AL solution in AL think not about coding challenges in the first place. Redesigning the solution is the real challenge.

6. Just because it is possible doesn’t mean you should do it.



NAV (BC) Integration Old vs. New

Ok this webcast had a clear focus on NAV BC SaaS. But nevertheless I think these two pictures have a clear message.

Register for On-demand version

When moving from the old NAV world to the new one it is not a question of CAL vs. AL. In my opinion the biggest challenge is to break out from our traditional way of solving problems.

The first picture shows a very familiar scenario. I think most NAV developers including myself will be fine with this solution. But the point is we have a whole set of new tools available which we should get familiar with. And these tools can also be a great help even in On Prem. Power Automate, Logic Apps, Azure functions…

So this is my entry point in the new world. Gather as much information as possible about Azure to be afterwards in a position to make valid decisions. Not everything needs or should be done in NAV BC if we already have tools available which can do the task out of the box.


Lesestoff / Linksammlung

Momentan habe ich echt viel zu tun, trotzdem gibt es immer mehr als genug neuen Lesestoff. Nachfolgend ein kleiner Auszug, muss zugeben, habe selber noch nicht alles gelesen. Aber dafür ist dieser Blogbeitrag ja da, sprich ich kann später nachschlagen…

Power Platform:

Codeunit API’s in Business Central

Power Apps Community Plan without Office 365

Using Power BI service without an Office 365 account

Currency Conversion in Power BI Reports


Moving X-Axis in Power BI

Analyzing PASS SQL Saturday data using Power BI

Paginated Reports Bonus Tutorial – Use the XMLA endpoint to create a live connected Excel table

Read API Data with Power BI using Power Query


NAV Business Central:

Codeunit API’s in Business Central

Business Central Blog

Import Tenant Data

How to use the Excel Buffer in Business Central cloud

Another great BC Blog

And another great Blog….

Dynamics 365 Business Central Workflows Auto Posting Transactions




Split Delimited String with Split Delimited with PARSENAME function



Cloud ETL With Azure Data Factory & CDS

Custom Logging and Auditing of ADF Data Flows

Syncing on-premise databases to Microsoft Azure Cloud using Azure Data Factory

Azure Functions Live – Feb 2020



Typescript – The Excel VBA Killer?

Using Power Platform Dataflows to extract and process data from Business Central

Und wieder eine ausführliche Blogserie zum Thema PowerBI dataflows. Diesmal wird ausführlich gezeigt, wie Daten aus NAV BC mittels dataflow in einen Azure Data Lake übetragen werden können. Ist ausführlich erklärt und somit auch leicht „nachzubauen“…

Using Power Platform Dataflows to extract and process data from Business Central