The views and opinions expressed in this blog are those solely of the author(s) and do not necessarily reflect Microsoft’s current policy, position, or branding. For official announcements and guidance on Dynamics 365 apps and services, please visit the Microsoft Dynamics 365 Blog.
Personalized Community is here!
Quickly customize your community to find the content you seek.
Customizing Dynamics NAV
Discover different ways to customize the application to give you and your colleagues access to the features, functionality, and data that you need most.
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Talent TechTalks
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.
Freddy calls out some important changes in the Version 0.5.0.11 release of NAVContainerHelper:
As you are working with Business Central, you’ll want to be aware of these changes and some workarounds offered.
Adrian is “having an issue setting up the SMTP Mail for the approval process in the TEST database. When we click the Test Email Setup button, we get an error message that says ‘Unable to Connect to the remote server’. How can we troubleshoot the issue? Thanks!”
Joe Shields asks: “Are you sure that is the right SMTP server address and port? Are they using Office 365 for email?”
Matt T adds this link to the Microsoft Office support article for POP, IMAP, and SMTP settings for Outlook.com.
In his post in the series, Index Tuning Week: How Many Indexes Are Too Many?, Brent Ozar boils it down to this rule of thumb for performance tuners: “Aim for around 5 indexes per table, with around 5 columns (or less) each.”
If you’re looking for some fundamentals for performance tuning your database, check him out.
Bill Warnke says: “I experimented with the new extensible enums (instead of making an Option field) just to see what it can do.
Oh, and of course one of the main reasons for enums is not having to do this anymore:
Quote,Order,Invoice,Credit Memo,Blanket Order,Return Order,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,New Value”
Kyle agrees: “Still uses an ID for each value. There could be collisions. Not Cool.
Isn't that a problem with enum types in any language? If you are storing it in a database, it either has to store an integer (ID) with some sort of mapping, or it must store the string itself?”
Bill replies: “Yeah. In this case, the ‘ID’ appears to only to be for uniqueness. The actual physical order it's in gives it its numerical position on the database. Now I wonder how it's going to handle installing an extension that extends an enum, uninstalling and then installing a different extension that extends the same enum. From the behavior I've seen, this means that the new extension will assume the integer values of the previously installed extension.
It seems the top 3 methods of storing in an enum in a database (in no order of correctness) are:
All of the opinions say option X is the best, and it's not done like Y anymore. I was kind of hoping for option 2-3 hybrid.”
If you are interested in NAV development, be sure to see our collection of NAV/BC Development Blogs.
Read the "How To" blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV and Dynamics 365 Business Central.
Business Applications communities