Personalized Community is here!
Quickly customize your community to find the content you seek.
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 1 virtual launch event
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming 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