Most of us that’s been programming in Dynamics NAV for a while are aware of the Excel Buffer table. It is a super useful table that can be used to create and read Excel files from C/AL code. This table have been around as far as I remember, and now it has some siblings, the XML Buffer and CSV Buffer tables. The concept is the same, a table with functions to create or read files, this time XML/CSV files instead of Excel files. Just like with the Excel Buffer table, the XML buffer and CSV buffer table should be used...
The 2016 version of Microsoft Dynamics NAV comes with a new C/AL editor. This is a big step forward for people that are writing code within Microsoft Dynamics NAV. The C/AL editor have, in my mind, always been much behind other code editors in terms of usability, but with the 2016 version Dynamics NAV catches up a bit. This blog post is about the new features you will find when you start writing code in Dynamics NAV 2016. The first thing that you will notice when you open the C/AL editor is how the functions looks with their colors etc. and that there...
By accident I discovered something quite interesting last week and I thought it was worth sharing it through a blog post. When you create an object type variable in Microsoft Dynamics NAV 2015 and you leave out the name then NAV will automatically suggest the name based on the subtype. So, when creating variables that are forms, records, reports, xmlports, etc. then there is no need to enter a variable name anymore. Nice! 🙂 Here is how it works; (more…)
This is something that I did some days ago and I thought it was creative enough to be worth a blog post. The task was to do a onetime mass update to the item records. There were more than 85.000 items in the company and they all had two production bin fields that needed to be updated according to a table with some rules provided in Excel. For items starting with ’10’ the two fields should be ‘RAW’ and ‘RAW’, for items starting with ‘11’ the two fields should be ‘TREATED’ and ‘CUT’, etc. like the below table, nothing strange. (more…)
