Skip to main content
Submitted by Suzanne Scanlan on 2 October 2020

ArcherPoint Dynamics NAV / Business Central Developer Digest - Vol 313

The Dynamics NAV and Business Central 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/BC experts and devotees around the world. We hope these insights will benefit you, too.

Page Inspector Now Supports Temporary Tables

Page Inspector is a useful tool used by developers to learn about the structure of a page, and now you can utilize the Page Inspector tool on temporary tables.

Developer Tip of the Day: PowerShell and SQL Server (and BC On Premises) 

Kyle imparts his wisdom: “PowerShell can be used to backup and restore SQL databases, which is useful for refreshing Test with a fresh copy of Production. I covered the steps for doing this in a previous blog post, How to Use PowerShell to Refresh a Microsoft Dynamics Business Central On Premises Test Database. But sometimes, especially if you are on a customer server running an older or LTS (Long-Term Support) version of Windows Server that doesn't get updated very often, installing the SQL PowerShell module can fail with an obscure error about not being able to find the module in a repository. What that really means is that PowerShell on that server doesn't know how to talk newer HTTP encryption methods like TLS1.3, so it can't reach Microsoft's repository. This article, Unable to Install NuGet Provider for PowerShell, has the steps to solve that problem. You will enable TLS1.3 for PowerShell.” 

Error: Table Missing a Matching Permission Set

Tom Hunt reveals a resolution to this issue: “I had an issue today with the AL(PTE0004) error from CodeCop, saying ‘Table [x] is missing a matching permission set’. This blog entry, Missing Permission Set, told me how to fix it, but if you don't want to read it, you can know that you need to hit Ctrl+Shift+P in Visual Studio to pull up the Command Palette and then run the ‘AL: Generate permission set containing current extension objects’ command. (You can type ‘perm’ into the Command Palette to bring it up directly.)”

Granting External Accountant Access to Dynamics 365 Business Central

Last year, we provided an update on Microsoft licensing for D365BC, which included the addition of external user licenses for Accountants and System Administrators. Robert Stefanetti shows us how to grant your Accountant access to Business Central and covers the permissions you need to do so. 

Microsoft Dynamics NAV and 365 Business Central Cumulative Updates for September

In case you missed them, here are the Cumulative Updates for September 2020:

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