Author Archive: admin
Dynamics NAV 2016 Events
I have been coding in Dynamics NAV 2016 CU3 and have started to use the new events features in Dynamics NAV, I have watched a few videos and read a few articles, many have ‘Foo Bar’ and ‘Hello World!’, these are required reading or watching if you are new to events, I would suggest following the […]
Dynamics NAV Use a Date Time as a Numeric Code
I was working on some Dynamics NAV code recently where I was sending an XML file as a HTTP Request and receiving a response xml back from the Website, in the past I have worked with some systems where the sent file name had to be the same every time, if I had to export […]
Dynamics NAV Export and Zip XMLPort Files
A couple of years ago I was asked about Dynamics NAV file handling for zipping a file after exporting the data, at the time I looked at creating a batch file and scripting the zipping up of the exported file, however I prefer to do as much as possible from within Dynamics NAV, I have […]
Excel Multiple Worksheets in Dynamics NAV
There are a few solutions for adding Multiple Worksheets to an Excel Workbook for earlier versions of Dynamics NAV, many of these solutions are not transferable into Dynamics NAV version 2013, I thought I would add my solution for Dynamics NAV 2013 R2, in Part One I will show the changes to the Excel Buffer, […]
Excel Multiple Worksheets Report
In this post I will show the code added in a Report to use the multiple Excel Worksheets in Dynamics NAV 2013, in Part One I looked the changes to the Excel Buffer, and in Part Three I will add functions for formatting and to create real formulas. The Report 50004 Export Items by Inventory […]
Excel Multiple Worksheets Report Extended
In this Final Part I will add functions for formatting and to create real formulas in Excel with Dynamics NAV 2013 R2, in Part One I looked at the changes to the Excel Buffer, in Part Two I explored the code added in a new report to use the multiple Excel Worksheets. The Report 50006 […]
CAL Syntax Highlighter for WordPress
This website like 20% of all new websites and blogs is run on the WordPress platform, as the subject is Dynamics NAV it helps to add code that could be copied and pasted, Dynamics NAV uses the C/AL Language (Client/server Application Language) otherwise known as CSide which stands for Client Server Integrated Environment. There are […]
4-4-5 Accounting Dynamics NAV
4-4-5 Accounting in Dynamics NAV is only possible with manual setup, most Accounting Systems are setup for the Julian or Western Calendar the standard 1st January to the 31st December with the additional Leap Year day 29th February every 4 years, this is adequate for most purposes, the standard periods in Dynamics NAV use the […]
Dynamics NAV Excel Import
In Dynamics NAV I can use the Excel Buffer functions to import an Excel Worksheet into the Excel Buffer table and then use the data to insert or update records in the database, looking at the existing Reports in the Cronus database to import from Excel, they use a Case Statement to insert or update […]
Dynamics NAV MOD and DIV Part 1
In Dynamics NAV C/AL Operators are not selectable, they are used by the developers in the code, I am going to look at two of the numerical operators that are not used often MOD and DIV. MOD and DIV are simple little functions, if you Google them you will find some convoluted answers, they are […]