Converting Decimal Numbers To Hexadecimal In Power Query M

This is a very short post! A lot of people have blogged about how to convert numbers between different bases in M (see for example Maxim Zelensky’s very elegant solution for converting from binary to decimal), but today I noticed there was a very easy way to convert a decimal number to hexadecimal using the Number.ToText() function: you just need to use “x” in the second parameter.

Bron : Chris Webb’s BI Blog
Lees meer…

How to convert Dynamics NAV reports to NAV Extensions

Dynamics NAV Extensions are a way for Microsoft Dynamics NAV developers and ISVs to extend the functionality of NAV without modifying Microsoft’s original source code.

In this blog post I will provide detailed information on how to move Dynamics NAV reports to NAV Extensions V2, also I will explain how to modify converted reports and review other related issues.

Bron : Simplanova
Lees meer…

Convert Nav Report (that used a DotNet List) into AL Extension

When developing Extensions for NAV, using the Modern Development Environment in Visual Studio Code, you cannot use .Net Interoperability. See this link if you want to read more about this subject.

So if you have NAV developments that use .Net and you want to move them into Extensions you will probably need to replace the logic implemented using .Net with something else.

Bron : Andrei Lungu
Lees meer…

Converting Dynamics NAV source code from C/AL to AL using PowerShell

Converting from C/AL to AL can be a bit of a hassle: First you need to open den Development Environment Then filter the objects that needs converting Export the objects to a txt file in a folder Then Run the Txt2AL.exe Lastly import them in the workspace So, I thought: Why cannot I do that directly from VS Code with PowerShell?

Bron : Aphorisms about Microsoft Dynamics NAV
Lees meer…

Convert Base64 with AL code

A couple of weeks ago, I was trying to write web service examples in AL code for VS Code. Unfortunately, at that time, it was not possible to call the Base64 methods on the TempBLOB table. And because those functions on the TempBLOB table are using .Net, I figured it was going to take a while before we get Base64 support in AL code. So I decided to write Base64 encoding / decoding routines myself. Just as an excercise and at that moment I didn’t know if I would even succeed.

Bron : Kauffmann @ Dynamics NAV
Lees meer…