Table Permissions for Limited Users

With Nav 2013 a new License Model was introduced. Especially the new Limited User License is a bit hard to understand. First of all: full read access is permitted. But … write access is very strong limited. It’s said, that within a write transaction 3 tables are allowed to access, But … it’s not described,… Continue reading Table Permissions for Limited Users

You cannot create an Automation object ‘name of autom.’ on Microsoft Dynamics NAV Server. You must create it on a client computer.

This is an error message, when trying to create an instance of an automation on a nav server vs. >= 2013. It’s only possible to create the automation instance as client instance. Creating automation instances on nav server is allowed till nav 2009. solution: use create(<name_of_autom.>,false,true) instead of create(<name_of_autom.>). remarks: you need a installed version… Continue reading You cannot create an Automation object ‘name of autom.’ on Microsoft Dynamics NAV Server. You must create it on a client computer.

Sql Statements in C/AL – Part 1 : Select

There is no possibility to read data from an external database with standard c/al. Best way to do that till NAV version 2009 is using ADO. With Nav vs. 2013 upwards you can use .Net classes. The following code can be used to read data from a given, external database. // local variables ADOConnection Automation… Continue reading Sql Statements in C/AL – Part 1 : Select

Navgate – a new Development Environment for Dynamics NAV

hi all, good news on the front for development environments. First some rumours about the current Dev.env.: Maybe there will be a RTC Version of the Nav Dev.env. in the future. This means: complete new surface (like VS ?), shorter runtime when starting/testing nav objects, better integration with the test tool. The real good news… Continue reading Navgate – a new Development Environment for Dynamics NAV

Numbers to Words

This code converts given numbers to words. For usage run (sample): InitTextVariables; numText := NumberToWords(1256,”); // numText | Text | 100 Message(numText); NumberToWords(number : Integer;appendScale : Text) : Text numString := ”; IF number < 100 THEN IF number < 20 THEN numString := OnesText[number] ELSE BEGIN numString := TensText[number DIV 10]; IF (number MOD… Continue reading Numbers to Words

Date Functions

Date functions are quite often used and needed. Here are some samples: Calculate the 1st of current month: EndDate := CALCDATE(‘-CM’); Calculate last day of current month: EndDate := CALCDATE(‘CM’); Calculate the end date of a defined period (e.g.3 months) starting with the 1st of the current month; get the last day of the end month: EndDate := CALCDATE(‘-CM+3M-1D’);… Continue reading Date Functions

The spread of Dynamics NAV

Google Trends is a helpful tool to find out, how many people are interested in a certain version of dynamics nav (former navision). So i played a bit with that tool. This chart shows the google trend for the search terms nav 2009, nav 2013, nav 2013 r2 and nav 2015 for the date range 01/2008 – 11/2014.… Continue reading The spread of Dynamics NAV