Subscribe via RSS Feed Connect on LinkedIn

Code Example

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 »

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 »

Dynamics NAV 2013R2 Currency Dashboard Part 1

27th October 2014 0 Comments
Dynamics NAV 2013R2 Currency Dashboard Part 1

This Post is the First in a Series on Microsoft Dynamics 2013R2 Development, Part One will look at the Requirement, in Part Two I will look at the Code Behind the First Module Solution with an Object Download available in Text format. This Scenario has come up before on several occasions however I had never […]

Continue Reading »

Dynamics NAV 2013R2 Currency Dashboard Part 2

27th October 2014 0 Comments
Dynamics NAV 2013R2 Currency Dashboard Part 2

This post is the Second in a Series on Microsoft Dynamics 2013R2 Development, Part One Covered the Three Modules I will be Posting over the Coming Weeks, this Post is the “Code Behind” a Basic Currency Dashboard Shown in Part One the Objects in Text Format can be Downloaded at the Foot of this Post. This […]

Continue Reading »