When you have to format C/AL variables (numbers, dates/times, booleans) for exchange with other apps, call FORMAT(variable,0,9) instead of simply FORMAT(variable). The format 9 formats the variable according to XML standards, and this value can then be interpreted correctly on any system with any regional settings. This is useful also when passing string-formatted values from C/AL to C# or JavaScript.
A couple of weeks ago, a new page was created on PartnerSource – the “Demo Microsoft Dynamics NAV” page. You can access it at http://aka.ms/demonav
The page contains (at the time) two scripts and two How Do I videos that help you establish a demo NAV 2015 environment on Azure, in Office 365. The whole process is highly automated and you can get up and running in a matter of minutes. When I say “up an running” I mean this: having a virtual machine running on Azure, with NAV 2015 accessible through Windows, Web, and Tablet client, with single sign-on to Office 365, and a nice demo SharePoint Online portal with several reports from NAV.
If you haven’t yet – give it a try.
This post is well overdue, I admit it. I have demonstrated so many times so far how to create an Azure VM instance running Microsoft Dynamics NAV through a PowerShell script running on your PC, and it’s just about time to share this script and the theory behind it with the world.