Skip to content

ArcherPoint Dynamics NAV Developer Digest - vol 224ArcherPoint's Developer Digest Weekly Blog

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…”

Old, remember to turn off your computer on 12/31/99 before midnight sticker from Best Buy

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.

Blog Tags: 

Comments

Comment: 

Hi Kyle,

I can't find "Report 10313, License Permissions" nor in W1 neither in NAVGB. Is it part of the US Localization?

Cheers,

Marton Nagy

Comment: 

I checked NAV 2016 CU4 W1 and you are correct - that is an NA report only. But there shouldn't be any reason you can't download the NA version of NAV and copy the report object.

Thanks,
Kyle

Comment: 

Tim Muldoon, Account Manager at ArcherPoint, also notes:

I can't open the report 50013 object, so I'm making an assumption. My guess is this report will do what it is intended, but it won't show you if objects are incorrectly assigned or duplicated. Duplication of object assignments is very common with Dynamics NAV versions from 2013 to 2018.

By default, a perpetual (2013-2018) license (assuming Starter and Extended Pack), comes with the Designer granules, therefore tables (50000..50009), pages (50000..50099), reports (50000..50099), and XML Ports (50000..50099) are already assigned. If a client also purchased Application Builder, they also received 100 codeunits, already assigned 50000..50099, and not editable, by default. 

What I often see is when a client purchases additional objects, they are assigned the same ranges as the defaults. Or, if a client is upgrading from a pre-2013 version, and they receive these additional granules, we may need to renumber previously assigned ranges. If so, then those ranges need to be edited in PartnerSource and an updated license downloaded. I have seen this so many times, It is something that should be reviewed for each license at some point, but typically if upgrading, or looking to purchase additional objects.

When in doubt, talk to your client's Account Manager

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