TechBlog

Did you know that a Code field is sorted different depending of you are using Native or SQL?

SQL will sort the Code field as a Varchar – which means it will sort the Code field as text!

In the following sorting example you can see the sorting Native vs. SQL
Read the rest of this entry »

In the earlier version of Navision it was not possible to enable keys on the fly. All you could do was either having fixed keys, using key groups or doing a “hack” with performing a SQL request.

Fixed keys are ok – but in large tables, it is not always a good idea to a lot of keys. Therefore often you will see that they have a minimized set of keys. A lot will properly be deactivated.
Read the rest of this entry »

In the early version of Navision it was only possible to handle string with a length up till 250 characters. This was often not enough and there was only a few ways to handle those strings. E.g. store the info in several fields, variables or a text file – that was imported to a blob field.

From Navision 4 it was suddenly possible to handle strings with a length up till 2147483647 characters – this is equivalent to 2 gb. In Navision 4 the data type BigText was introduced.
Read the rest of this entry »

In Navision number series are used to handle invoices, credit memo’s, customers etc. – actually they are pretty widely used around in Navision.

So how does number series work?
Read the rest of this entry »

Navision Customizations is done in C/SIDE.

C/SIDE (Client / Server Integrated Development Environment) is the core of Navision and is the foundation for almost all functionality in Navision. It is made up of 5-7 building blocks called objects (tables, forms, reports, dataports, codeunits, xmlports (introduced in ver. 4), menusuites (introduced in ver. 4)). These objects types are shared throughout Navision, which resolves in a uniform and consistent interface to the application.

Microsoft Dynamics NAV (also known as Navision) is an ERP software product by Microsoft.

It assists with finance, manufacturing, customer relationship management, supply chains, analytics and electronic commerce for small and medium-sized enterprises.

The first version of Navision was known as Navision Financials until version 2.60 – then it changed version to Navision Attain 3.0. When the version 3.70 was reached it changed name to Microsoft Business Solution Navision 4.0 and from version 5 it is called Microsoft Dynamics NAV.