October 2, 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 TablesPage 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 SetTom 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 CentralLast 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 SeptemberIn case you missed them, here are the Cumulative Updates for September 2020:
- Update 15.10 for Business Central 2019
- Update 33 for Dynamics NAV 2018 (Build 44657)
- Update 46 for Dynamics NAV 2017 (Build 30340)
- Update 59 for Dynamics NAV 2016 (Build 51934)
- Login Error: Communication protocol mismatch between client and server
- Creating a Date Table in Power BI
- How to Make Measures Total Correctly in Power BI Tables
- The Microsoft Technology Stack – What It Is and Why You Should Care
- The Top Eight KPIs Retailers Should Be Tracking (with Formulas) for Your Retail KPI Dashboard