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...
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…)
From time to time I run into situations where users want to view a filtered list of order lines; it could for example be a list of shipped not invoiced items or a shipping queue showing outstanding items to ship. Most of the menu items in Microsoft Dynamics NAV refer to the order headers and not the lines, but adding a page to the navigation pane that shows the order lines can be done by the users themselves with a few simple tricks without having to modify any objects. The key is to use the ‘Save View As’ feature on...
