Oct 21

Reading from and writing to the Clipboard

Have you ever tried putting something in the clipboard? Well, aside from literally copying or pasting? If you have ever tried something like this in .NET, you might remember, you need to call the functionality in a thread with STA … Continue reading

Oct 07

Using Codeunits as Classes

This time, I’ll present you with another way to use Codeunits in NAV. By using Codeunits as parameters to a function, you can use Codeunits as (sort of .NET) Classes. If you declare different local variables to the same Codeunit, … Continue reading

Sep 17

Load NAV Service DLL for a specific Server Instance

Sometimes, you have multiple NAV Instances installed. When you have multiple installations, with different builds, you cannot use the PowerShell functions for each instance. You could try loading the NavAdminTool.PS1 in the correct NST folder. However, this will probably not … Continue reading

Aug 26

Creating users with Powershell

We all had our fair share of database we were locked out of, because a user added himself and no other users to a database. In that case, we have 3 options to gain access to the database. One of … Continue reading

Feb 27

Weekly exchange rate update (using DotNet)

A while ago, I posted a blog post to download the exchange rates from ECB. Someone replied that the code is using automations, which do not longer work as of NAV 2013. In this post, I will just do the … Continue reading

Dec 15

Customize Ribbon – Beware

It often happens that customers change their ribbon. Mostly to remove the clutter of actions and only keep the actions they care about. Today we got a customer change request saying, that if they have an error (the yellow bar … Continue reading

Aug 08

Import 2013 R2 report into 2013 R1: Invalid target namespace

Today, I had to copy a report of our product to a customers database. Our product database is currently NAV2013 R2, while the customer databases is a NAV2013 environment. I noticed that there are some difficulties into doing this.

Jun 06

NAV2013 Object Admin

Giving SQL Server permissions was not always secure in the past… When a user needed to be able to upload objects, they actually needed the db owner role. Which isn’t actually something that you always want. Since NAV2013 it has … Continue reading

Feb 25

Reading Excel – Alternative

Most of us had already experienced the joy of getting an error while reading Excel through C/AL: To support the <Language> (<Country>) language, install the Language Package for your version of Microsoft Office. It seems that even by using automations, … Continue reading

Nov 13

Using DotNet to put a file on an FTP server

By using DotNet variables, you can achieve great things, which would otherwise take you a lot of effort / hassle. Putting a file on an FTP server with C/AL would make you create batch files, specifically a file telling the … Continue reading