Skip to content

ArcherPoint Dynamics NAV Developer Digest – vol 93

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: Is there a Data Cleaning Utility for NAV 2016?

Question: Is there standard functionality in NAV 2016 or a utility or download that will provide data cleaning of user data (e.g., clear out all posted ledgers, Posted Dimensions, Ledger, basically all non-setup data)? I can back up and restore companies using the Import/Export data but it brings over all data. I want to create the equivalent of a company template that can be used over and over again for testing, mock go lives, and go lives.

Ed Fager: I found a really good download and tested it. It works well. It has a "suggest function" that picks up the major tables and you click the other tables you want to clear. This tool shows you the number of records in each table. I t loaded fine in a 2016 database and works.

Download the tool:

Record Deletion Tool for Dynamics NAV 2015


Dan Sass shared an article on the one trait possessed by successful people:

In an article for Inc. magazine, Nicolas Cole wrote about the one trait shared by successful, innovative people:

"Successful people are 100% confident that, whatever the challenge, they will be able to figure it out--and at the same time, they are 100% willing to forgo everything they think they know and admit to knowing nothing."

The author goes on to say:

"It is actually the trait, arguably the only trait, that allows someone to constantly reinvent themselves--and subsequently the industries they play within."

Read the entire article:

The 1 Trait All Successful People Have

Robert Garofallou on Henry Ford and Innovation:

My colleague, Dara Daly, shared this famous quote:

“If I had asked people what they wanted, they would have said faster horses.” - Henry Ford

This and his other famous quote, "People can buy my cars in any long as it's black", are two of my favorites. But there is evidence Ford never said the "faster horses" quote. My research led me to this HBR article:

Henry Ford, Innovation, and That “Faster Horse” Quote

Whether or not the quote is real, the article's conclusion was very interesting to me because it showed both the upside and downside of Ford’s innovative thinking:

"An innovator should have understanding of one’s customers and their problems via empirical, observational, anecdotal methods or even intuition. They should also feel free to ignore customers’ inputs. Because by now it should be clear that Ford’s adherence to his vision of the mass-market car and how to materialize that vision was instrumental in both his early success in growing Ford Motor Company as well as his later failure to respond in a timely and effective manner to rapid innovation in the marketplace."


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.

Blog Tags: 
Read ArcherPoint's Blog Follow us on Twitter Follow us on Facebook Follow us on LinkedIn Link to our RSS feed Watch us on YouTube
Get Help Now