Subscribe via RSS Feed Connect on LinkedIn

Tutorials

Dynamics NAV 2016 Events

6th March 2016 0 Comments
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 […]

Continue Reading »

Dynamics NAV Use a Date Time as a Numeric Code

15th November 2015 0 Comments
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 […]

Continue Reading »

Dynamics NAV Export and Zip XMLPort Files

12th July 2015 0 Comments
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 […]

Continue Reading »

Excel Multiple Worksheets Report Extended

20th June 2015 0 Comments
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 […]

Continue Reading »

4-4-5 Accounting Dynamics NAV

14th March 2015 0 Comments
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 […]

Continue Reading »

Dynamics NAV Excel Import

9th March 2015 0 Comments
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 […]

Continue Reading »

Dynamics NAV MOD and DIV Part 1

28th February 2015 0 Comments
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 […]

Continue Reading »

Dynamics NAV MOD and DIV Part 2

28th February 2015 0 Comments
Dynamics NAV MOD and DIV Part 2

In Dynamics NAV MOD and DIV Part One I looked at the Operators MOD and DIV, I will attempt to offer a more Practical Example in this post, if I use a soft drink manufacturer one of the steps of bringing the product “Cronus Cola” to market is the production, the purified water will have […]

Continue Reading »

Dynamics NAV 1013R2 Global Currency Part 1

2nd November 2014 0 Comments
Dynamics NAV 1013R2 Global Currency Part 1

This Post is the Third in a Series on Microsoft Dynamics NAV 2013R2 Development, following on from the two post from Module One, This Post will look at the Visual Screens Module 2, Part Two will look at the Code Changes, the Objects can be “Downloaded in Text Format” in Part Two. This Scenario has […]

Continue Reading »

Dynamics NAV 1013R2 Global Currency Part 2

2nd November 2014 0 Comments
Dynamics NAV 1013R2 Global Currency Part 2

This post is the Forth in a Series on Microsoft Dynamics Nav 2013R2 Development, Parts One and Two Covered Module 1, this Post is the “Code Behind” Module 2 a Global Currency Dashboard Shown in Part One this Module, “Objects in Text Format can be Downloaded” at the Foot of this Post. This Scenario has […]

Continue Reading »