Category Archives: Tips and Tricks

Tips and Tricks

Why SQL Server 2016 Management Studio Understands Navision


I spend a lot of my time in SQL Server Management Studio. I rarely ever run tables anymore from Object Desingner and run most of my data conversions directly in T-SQL. Why? Because it is so much faster, I can … Continue reading

Posted in Dynamics NAV, Product News, Tips and Tricks | 1 Comment

Tip #56 | Fix Error : Sorting cannot be done based on the XX field(s)


Today I’ve spent some time in NAV2016 figuring out this error message: As you know in NAV2016 you can sort on each column even if there is no key and even if it’s a flowfield. So why am I getting … Continue reading

Posted in Dynamics NAV, Tips and Tricks | 2 Comments

ALWAYS! Restart Service Tier after FOB Import!


Blogging about your own mistakes is always easiest. Reasoning is simple; if I make the mistake, chance is someone else makes it too. Yesterday we had quite some panic at one of my large customers. After importing a fob file … Continue reading

Posted in Dynamics NAV, Tips and Tricks | 8 Comments

Tip #55 | Add RDLC option to Visual Studio 2015 Community Edition


In Microsoft Dynamics NAV 2016 CU1, support for VS2015 Community Edition has been implemented. However if you do a default install of VS2015CE, the RDLC editor is not included and your report will show up as XML instead of the … Continue reading

Posted in Tips and Tricks | 8 Comments

Tip #54 | PowerShell Merge – A clustered key can appear only once in a table


If you upgrade your database to NAV2016 using the PowerShell Merge commandlets and have a change to table 49 you will run into this issue. Table 49 is the Invoice Posting Buffer table that NAV uses to create G/L entries … Continue reading

Posted in Tips and Tricks | 2 Comments

Tip #53 – Locks, Blocks, Deadlocks and Timeouts | What are they


Recently I’ve been asked to do a code review of a vertical solution. Since these are always interesting projects I cleared my schedule and planned an interview to see what it was about. I’m curious by nature. During the interview … Continue reading

Posted in Tips and Tricks | 3 Comments

Tip #52 – Run MODAL pages after INSERT


One of the things I spend a lot of time on during my workshop is design for performance and using temporary tables. There are so many great things you can do here. Let’s look at this code: Typically after an insert … Continue reading

Posted in Tips and Tricks | Tagged | 1 Comment

Tip #51 – Scrolling Development Environment in Windows 10


If you install Windows 10 RTM and Dynamics NAV 2015 development environment you will notice that the scrolling on the development environment with your mouse wheel does not work. I was pointed to this by the NAV Yammer group and … Continue reading

Posted in Tips and Tricks | 5 Comments

Tip #50 – Implementing Addresses


Many, many years ago, in 2009 I’ve written a blog about how to implement No. Series in Microsoft Dynamics NAV. This is one of the oldest features in the product, first introduced in Navision Financials 1.1. When I acquired the … Continue reading

Posted in Tips and Tricks | 1 Comment

Tip #49 | PowerShell, break long lines into readable code


Unlike other languages PowerShell does not allow you to just continue a command on a new line. You have to specifically tell it to do that by adding a “Backtick” character. This one: ` Example: Split-NAVApplicationObjectFile -Source “C:\Users\Mark Brummel\Documents\Export.txt” `                                … Continue reading

Posted in Dynamics NAV, Tips and Tricks | 1 Comment