ArcherPoint Dynamics NAV Developer Digest - vol 221
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.
Introducing the Upgrade Tag Table in Dynamics 365 Business Central
Richard Robberse shares the issues with upgrade codeunits in C/SIDE and introduces the new Upgrade Tags in Dynamics Business Central. The API contains two functions and is accessible from AL. Read Using Upgrade Tags to Facilitate Continuous Upgrades to learn everything you need to know about the upgrade tags in Business Central.
Do You Use the Query Object?
Kyle asks: “Do any of you ever use the Query object? If so, what do you use it for?”
Matt T responds: “Not often. Publishing data through a web service is what it is used for most times. The other use cases don't come up very often.”
Kyle adds: “I was hoping (back when they were first invented) that Microsoft was de-coupling data retrieval from report presentation. So basically, you could feed a Query object into a Report object, which would let you do all sorts of cool joins and what-not that C/AL sucks at doing. I have never had anyone ask me to do ODATA.”
Matt T says: “You can use a Query object to feed a report, but it's not as simple as setting a few properties.”
Suresh chimes in: “One of our clients uses it extensively to build cues on the Role Center page.”
Kyle asks: “What sort of cues did they build? Those always seemed a little useless to me, as though the count of Sales Orders might be useful. What are they using cues for?”
Post Batch Functionality Issue Fixed in Dynamics NAV 2018 CU09
Saurav shares: “There is an issue fixed in NAV 2018 CU09 related to Post Batch functionality for sales and purchase documents. Issues reported by users are:
- The Batch Processing Parameter Map already exist. Identification Fields and values: Record ID= Sales Header:Order
- When I try and post a batch, nothing happens. Also, if I try and invoice an individual order, it always posts to a fix date.
Object Impact for fix issue are codeunits - 88|98|1371|1372|1380
If these objects are not modified in customer database, we can replace the fob, otherwise compare text files to merge changes.
Additionally, we will have to delete data from table 52 & 53 (Batch Processing Parameter & Batch Processing Parameter Map).”
Publish Extension Error in Business Central On-Premises
Saurav shares in his blog instructions for how to fix the NetFX40_LegacySecurityPolicy issue when attempting to publish an Extension in Dynamics 365 Business Central on-premises. Follow these five steps to successfully publish your Extension.
If you are interested in NAV development, be sure to see our collection of NAV Development Blogs.
Read the "How To" blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV and Dynamics 365 Business Central, and contact ArcherPoint if you need assistance with Dynamics NAV or Business Central.