How to access timestamp from C/AL? When you Google/Bing this question, you mainly get three answers: Short answer: you can't, Write a SQL query using ADO.NET, Create a SQL view and use a linked table on NAV, When Microsoft introduced NAV 2016, we got a fourth answer described in this blog post by Dynamics NAV … Continue reading How to: Access timestamp from C/AL
C/AL
How to calculate Dimension Set ID
Starting from Dynamics NAV 2013, dimensions structure has changed a lot. Since then, a lot of developers struggle to insert or update dimensions pragmatically. I will not bother you with what was already explained a hundred times in other blogs on how to calculate Dimension Set ID. Better, I will share with you a simple … Continue reading How to calculate Dimension Set ID
Text encoding in NAV 2009 R2 Classic Client – Part 2
As I already explained in this blog post you can import text files with encoding in Dynamics NAV 2009 R2 Classic Client and old versions. Today, I will use the same trick in order to export a text file with encoding (UTF-8 in the example below). In order to illustrate this, let's export all items … Continue reading Text encoding in NAV 2009 R2 Classic Client – Part 2
Text encoding in NAV 2009 R2 Classic Client – Part 1
P.S: If you're still using Microsoft Dynamics NAV 2009 R2 Classic Client or a previous version, then you may want to continue reading this blog post. We all know that Microsoft Dynamics NAV 2009 R2 Classis Client supports ANSI only (code page 1252 or depends on your windows localization). In order to import/export encoded files … Continue reading Text encoding in NAV 2009 R2 Classic Client – Part 1
My two cents about Try/Catch in C/AL
By introducing NAV 2016, Microsoft introduced Try Functions in order to endow developers with some sort of Try/Catch in C/AL. The purpose of this blog is not to add another entry to explain how to use Try Functions. José Castro Fernández has already explained this here. The problem with these type of functions is resumed in … Continue reading My two cents about Try/Catch in C/AL
Dynamics NAV Generic SOAP Client
Last summer, when I posted my first article I though blogging is very easy and I'll post an article every week. Actually, it's not that easy. Anyway, after few months here is the article I promised: a 100% generic web service client for NAV. I was looking for a way to automate all my web … Continue reading Dynamics NAV Generic SOAP Client