ArcherPoint Dynamics NAV Developer Digest - vol 224
The NAV community, including the ArcherPoint technical staff, is made up of developers, project managers, and consultants who are constantly communicating, with the common goal of sharing helpful information with one another to help customers be more successful.
As they run into issues and questions, find the answers, and make new discoveries, they post them on blogs, forums, social media…so everyone can 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 community—so we thought, wouldn’t it be great to share this great information with everyone who might not have the time to check out the multitude of resources out there? So, the ArcherPoint Microsoft Dynamics NAV Developer Digest was born. Each week, we present a collection of thoughts and findings from NAV experts and devotees around the world. We hope these insights will benefit you, too.
Where Were You on December 31, 1999?
As we say goodbye to 2018 and hello to 2019, I thought this little trip down memory lane would be fun…Kyle asks: “Where were you when…”
Matt T: “You know there are probably people who work here that have no idea what this is/means?”
Faithie: “I remember it! And I believe the canned tuna and bottled water industry gained quite a bit of momentum over it! 🙂 #wesurvived”
Saurav: “It’s partially true for me what Matt Traxinger said. I knew about this from news, but until then, I hadn’t touched/seen a computer.”
Chris Montgomery: “I worked for Navision then… the original Navision, not MS NAV. From the 1980s when it was created, the software always had 4-digit years, so it was never a problem. It was a HUGE selling point as the year 2000 approached. The Navision US office in Atlanta recruited and supported all the resellers in US and Canada (Navision Canada opened its doors in the late 90s). If the resellers had any issues with the software for any of their customers, they could contact us for assistance. Although we knew there would be no problem, we still had to come in to the office on January 1, 2000, just in case something strange happened, and a reseller needed assistance. I remember: It was a Saturday and it was the most boring 1/2 day spent – no calls, no problems.”
Kristine: “I was on a team for Y2K testing…hahaha. We actually found issues because the systems were not designed to go past that date. It seems so strange to think about now. As for me, I was also working at Navision during this time. It was definitely a fun time, not worrying about our systems going down when it seemed the world was frantic with worry. Alas, it was a non-event for most. We could still get cash from the ATM, our phones still worked, and our clients were in good hands.”
For those of you younger folks that aren’t old enough to remember, here’s a little history on the concerns of that time, as the world prepared to enter a new millennium.
Developer Tip of the Day: Report 10313, License Permissions
Kyle’s Developer Tip of the Day: “Report 10313 License Permissions is your friend. It will tell you what object types and ranges the customer currently owns, so you can easily see whether
you can develop without them buying new objects.”
Developer Tip of the Day: Get a List of Setup Tables That Have Data in Them
Another developer tip of the day from Kyle Hardin comes in the form of this scenario:
Consultant: “I need a list of all setup tables that have data in them, so I know what to capture in Rapid.”
Nerd: “I’ll have that in a spreadsheet for you momentarily.”
Use this TSQL:
SELECT o.name,
ddps.row_count
FROM sys.indexes AS i
INNER JOIN sys.objects AS o ON i.OBJECT_ID = o.OBJECT_ID
INNER JOIN sys.dm_db_partition_stats AS ddps ON i.OBJECT_ID = ddps.OBJECT_ID
AND i.index_id = ddps.index_id
WHERE i.index_id < 2 AND o.is_ms_shipped = 0 AND ddps.row_count > 0
ORDER BY o.name
Jon replies: “Nerd language.”
Saurav adds: “If we want a table list which have data in NAV 2013 R2 or higher, then we can use ‘Configuration Worksheet, action Get Table, and filter for Include with data. Hope this helps.”
If you are interested in NAV development, be sure to see our collection of NAV Development Blogs.
Read the “How To” blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV and Dynamics 365 Business Central, and contact ArcherPoint if you need assistance with Dynamics NAV or Business Central.