TableType::ExternalSQL

One very cool feature in NAV2016 is the table type “ExternalSQL”. In older versions you had to use a view in SQL for each table and set the property LinkedObject. Now you don’t have to do that any more. Let’s take a look at it: Here you can see how you can use TableType, ExternalName […]

AltSearchField in NAV2016

The property AltSearchField is removed in NAV2016 but importing an object from NAV2015/2013 which had that property set will still keep the property value even though it’s not visible in the development environment. This might not be an issue until you try to rename the field that is set as AltSearchField. Then you’ll end up […]

Log your changes

From time to time we get into the situation where we need to run a batch report to update data in NAV. It’s always nice to log changes and there’s an easy way to do it by calling the standard Change Log functionality. This example blocks all Norwegian customers and writes the changes to the […]