Dynamics Business Central / NAV Developer Digest - Vol. 456
ArcherPoint’s Developer Digest focuses on Microsoft Dynamics 365 Business Central and Dynamics NAV development. This week’s volume includes performance improvement for DataAccessIntent property, prerelease versions of the AL Language extension for BC available for Visual Studio, managing user permission sets during on-prem to cloud BC migration, and managing multiple entity transactions across different BC environments.
The Dynamics 365 Business Central community comprises professionals devoted to advancing the success of their customers. Developers, project managers, and consultants collaborate to share helpful information across blogs, forums, and social media sites. From discovering new solutions to finding answers to complex issues, these dedicated individuals are constantly sharing their knowledge with others. At ArcherPoint, we recognize and appreciate this highly engaged community’s creativity, hard work, and collective intelligence. To ensure all users can benefit from their expertise, we want to share their wealth of information with everyone.
Performance improvement for DataAccessIntent property
Question: “If you have used the DataAccessIntent (=ReadOnly) property on API pages in BC SaaS, what’s your experience with performance improvement? I’ve read that sandboxes cannot be enabled with read scale-out, so testing would have to be done in a production environment. Same question for the UseReadOnlyReplica setting in Power BI – have you noticed any significant performance improvements? Is there a similar property or setting in NAV to redirect queries to the secondary/replica database (assuming that it has been enabled in the Azure SQL db)?”
Kyle H. responded, “That flag did nothing until BC22, so anything older than that won’t work. You are correct on the sandbox/production issue. Keep in mind that your report or query must strictly be no writing. None. Zero. Even just updating the print counter for a Sales Order will make the report fail.”
For more information, see Microsoft’s DataAccessIntent Property page.
Prerelease versions of the AL Language extension for BC available for Visual Studio
Microsoft has made a prerelease version of the AL Language extension available on Visual Studio Code Marketplace. Upgrading your code now allows you to develop on the latest code and test while it is still in Preview. Developers can still switch back to the older version if needed.
Watch the video by Saurav Dhyani, Get the AL Language extension in prerelease versions on Visual Studio Code Marketplace, to learn more.
Managing user permission sets during on-prem to cloud BC migration
When migrating Business Central from on premises to the cloud, the Cloud Migration toolset provides the actions and information you need to manage the migration. By default, users in the migrated company (except Admin) are assigned to the Intelligent Cloud user group and are given Read Only access to the database.
Stefano Demiliani discusses changes in Business Central 2023 Wave 2, where the Cloud Migration Management page provides a new action, Enable/Disable Removing Permissions from Users, that allows administrators to enable or disable assigning users to the Intelligent Cloud user group.
Find out more by reading his blog, Dynamics 365 Business Central: Cloud Migration and permission sets.
Managing multiple entity transactions across different BC environments
Managing transactions between multiple business entities can be complex. Business Central makes the process easier with its Intercompany Postings feature.
Mohana shows how to use this feature to:
- Set up an intercompany partnership between companies operating in different Business Central environments
- Automatically send and receive transactions for partner companies, letting you process sales and purchase documents, intercompany general journals, and purchase invoice cost distributions
- Map accounts to an intercompany chart of accounts to ensure transactions flow smoothly between companies
Watch the video, Seamless Intercompany Transactions: Connecting Business Central Environments, to learn more.
Reminder: Community Summit NA 2023 – October 15-20
This is the last chance to join us in Charlotte for the 2023 Community Summit October 15-20. In-person help desk, expos, and training sessions on Dynamics products, Power Platform, and latest innovations in AI will be held October 17-20. Premium training sessions will be held October 15-16.
Get 10% off by registering with the ArcherPoint discount link.
Interested in Dynamics NAV and Business Central development? Be sure to see our collection of NAV/BC Development Blogs.
Read “How To” blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV and Dynamics 365 Business Central.