Skip to main content
Submitted by Suzanne Scanlan on 3 January 2020

ArcherPoint Dynamics NAV / Business Central Developer Digest - vol 274 

ArcherPoint Dynamics NAV and BC Developer Digest BlogThe 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.

MICR Fonts Available in Business Central SaaS

MSD365 Business Central Online customers can now print checks with MICR fonts. Microsoft will be providing this functionality in update 15.3, and has links to documentation as well as demo versions of the fonts so you can be ready for this update.

Developer Tip of the Day: AL, SQL, Record Fetches, and Performance 

See this article from Microsoft, AL Database Methods and Performance on SQL Server, to learn about the relationship; between basic database functions in AL and SQL statements. 

Vote for Extending Keys in a Base Table from an AL Extension

Kyle is frustrated: “It blows that you cannot add a TableExtension key that references an existing base table field. And you can't even add a SQL index, because TableExtensions are a lie - they aren't an extension to the table at all. They are separate SQL tables joined with some sort of view magic. Which actually explains why I can't add the key - but it still blows.”

Bill W adds: “Yeah, it's a SQL join. I needed to do this and the answer is to mirror the fields, duplicate the key, and add a new field in the extension.”

Jon shares his LinkedIn post on this topic: “Microsoft is working on this.

Saurav suggests: “There is a request to Microsoft on the idea website, see Extending Keys in a base table from an AL Table Extension

Vote for it.”

Kyle responds: “Grrrr...but I voted for it anyway. 

DO NOT ALLOW creating a key where they have fields in both the parent table and extended table (which would make sense, since you cannot create a SQL index against two or more tables).” 

Adding Tests to an Existing Project

Bill W asks: “When is the best time to add tests to a project that doesn't have any? Adding a new feature is probably the easiest. The next best time, bug fixing.

I had a bug to track down, so I created 3 new test cases. Two that immediately failed, these were the target condition and one that I knew matched a good desired outcome. Taking my two failures from red to green lets me know I've solved the bug and (just as important) keeping the successful test green means I haven't broken existing functionality. Even though I had to write the tests it probably saved me time running the scenario over and over again versus, manually navigating and punching data into pages. Also, very assuring to know that I didn't break anything else.”

If you are interested in Dynamics NAV and Business Central 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.

Blog tags