Still my all time favorite tool for working with Microsoft Dynamics NAV is MergeTool. Long known as a tool for comparing customized objects in NAV, then providing the ability to merge changes into a new version, there are some aspects…
Still my all time favorite tool for working with Microsoft Dynamics NAV is MergeTool. Long known as a tool for comparing customized objects in NAV, then providing the ability to merge changes into a new version, there are some aspects…
Most users will use Scribe adapters to connect data between CRM and NAV. These adapters are very useful, especially with CRM’s restrictions on how data may be written into its database. Coming back from CRM to NAV, the adapters also…
Many customers with multiple companies will often have the same data repeated across all the companies. For example, the chart of accounts (G/L Account table) may be exactly the same for all companies in the database. This can also happen…
You are always looking at data through a form or a page. But what if you want to see all the data for this customer record even if it is not displayed on the card? For this you can use…
This is one of the techniques to mass change data in NAV. Create a new report, selecting the table you want to fix. Set the ProcessingOnly property as shown below CAUTION: Make sure you set a filter on…
Ever had a colleague enter or import a journal and found that the description has the same type in 1,000 lines? How about importing 5,000 customers and then needing to change the terms code for every user in the state…
If you want to see data from an external SQL-based application inside your NAV system, this can be done very easily without the messy process of exporting and importing data into NAV. And when we say SQL, this means any…
Yikes! It’s wonderful to have NAV data in SQL Server tables, but getting to this data using a SELECT statement can be enormously challenging because of the NAV data “nuances”. Let’s check our major table with critical data, the G/L…
With the release of NAV 2015 and the expiration of support for NAV 2009, the time to consider a comprehensive upgrade is here. This is a MAJOR upgrade and requires careful analysis by experienced NAV consultant/developers, because: there are some significant…
There are a couple of cases to always upgrade your executable version. from any version prior to NAV 5.x, SP1 to NAV 2009 – this executable upgrade will: reduce the size of your SQL Server database immediately by up to…