Skip to content

ArcherPoint Dynamics NAV Developer Digest – vol 80

ArcherPoint’s technical staff pose questions, find answers, and share new discoveries about Microsoft Dynamics NAV

The ArcherPoint technical staff—made up of developers, project managers, and consultants – is constantly communicating internally, with the goal of sharing helpful information with one another.

As they run into issues and questions, find the answers, and make new discoveries, they post them companywide on Yammer for everyone’s benefit. We in Marketing watch these interactions and never cease to be amazed by the creativity, dedication, and brainpower we’re so fortunate to have in this group—so we thought, wouldn’t it be great to share them with the rest of the Microsoft Dynamics NAV Community? So, the ArcherPoint Microsoft Dynamics NAV Developer Digest was born. Each week, we present a collection of thoughts and findings from the ArcherPoint staff. We hope these insights will benefit you, too.

Question on accessing the NAV WebClient and MAC computers:

Question: Does anyone know of issues with NAV WebClient and MAC computers? I have a user that is trying to access the WebClient from his MAC and gets the error "A Server error has occurred, and content cannot be displayed. Refresh the page or open a new Brower window." every time he tries to connect on the MAC. But when he is on a PC he does not get this error. I Googled and did not see any work around. Suggestions?

Brian Winfrey: The NAV Web Client for 2013 and 2013R2 is not supported on Safari for the MacOS. It will work on Safari on IOS. NAV 2015 is supported on Safari 7.0 or OSX and 2016 looks to be supported on Safari 8.08 or OSX.

Michael Wong: They may be able to use Google Chrome with a browser extension called IE Tab, which emulates the internet explorer browser inside the chrome interface, but this only works on windows computers.

Here's the link to the Chrome extension for IE Tab.

Kyle Hardin: I think Parallels comes with OSX and that will let you run a windows VM.

Question on changes to a NAV 2016 database collation:

Brian Winfrey: Does anybody know how to change a NAV 2016 database collation from Latin1_General_100_CI_AS to SQL_Latin1_General_CP1_CI_AS and what the consequences of doing that are? New implementation database, very little data other than setup, no transactions posted yet. The way I had to solve this was create a blank database using the NAV client. Then run an ALTER DATABASE SQL script to change the collation. Then I imported all the objects from the old database. Finally migrated the data using the Export-NAVData/Import-NAVData PowerShell commands.

Greg Kaupp: Here is a link to a Microsoft Blog Article describing how to do it in NAV 2013 R2. Assume you can still find the Alter Database in the same place for NAV 2016 Dev Client.

How to change the collation on a Microsoft Dynamics NAV 2013 R2 database.

Brian Winfrey: Appreciate the article, but for everybody's edification, the problem I had with using the Development Client is that I couldn't choose the specific collation that the customer required. It lets you choose a language, capitalization, and accent sensitivity but not anything else.

From the Development Team: This may help: While converting a Nav2009 database to Nav2013, the following error message appears about changing collation:

“The database collation cannot be changed if a schema-bound object depends on it.”

The solution is to remove all the views from the affected database, then re-create views after changing to the new collation.

Right click the database, select "Tasks" -> "Generate Scripts" then follow the wizard to create a script for dropping views and create another script for creating views.

1. Run the Drop View Script file,

2. Change the collation from within SQL.

3. Run the Create View Script file.

Question on bin count does not match the ILE count:

Crystal Tollison: Customer has had several instances where their bin count does not match the ILE count. They would like for us to create a function that they could use themselves to correct. They are on 2013 (no R2). Just checking to see if anyone has developed this type of functionality in another database already?

Matt Traxinger: And they are running the process on the warehouse side to clear the adjustment bin?

Crystal Tollison: Right, they have done all those steps but it did not fix the miss-count in the bins.

Faithie Robertson: Another client has a report whereby they enter some information on the report request page and it creates an adjustment warehouse entry to even out the difference. NORMALLY, this would not be the way to do it, since they should not be different values. But in this client’s case, they knew that the pick had been deleted, the items were shipped, and there was no way to adjust it otherwise. Be aware, it came with strong warnings to both their IT director and on the report request page, since the report allows permission to add to the warehouse entry table outside of the natural NAV processing.


If you are interested in NAV development, check out our collection of NAV Development Blogs.

For step-by-step instructions on how to perform specific tasks in Microsoft Dynamics NAV, see our collection of How-To blogs.

If you found this post useful, you might also be interested to read through our archive of the Dynamics NAV Developer Digest.

Read ArcherPoint's Blog Follow us on Twitter Follow us on Facebook Follow us on LinkedIn Link to our RSS feed Join us on Google+ Watch us on YouTube