Subscribe via RSS Feed Connect on LinkedIn

Tag: Dynamics NAV

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 in Dynamics NAV

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

Continue Reading »

Excel Multiple Worksheets Report

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

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 »