Dynamics Business Central / NAV Developer Digest - Vol. 449
ArcherPoint’s Developer Digest focuses on Microsoft Dynamics 365 Business Central and Dynamics NAV development. This week’s volume includes using Partial Records in AL code, new message when creating a pre-existing warehouse shipment, the new AllowInCustomization property in AL, and an MSDW Podcast on AI adoption.
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.
Using Partial Records in AL code
Retrieving records with SQL queries using Get, Find, Next will load all the fields of the table, potentially impacting performance. Using Partial Records when accessing a data source in AL will let you load a subset of normal table fields, improving the performance of objects like reports and OData pages.
Alex Wiley recently posted, “I ran across the ‘new-to-me’ subject of using Partial Records while experimenting with some things for data warehousing, including this KQL sample query from Waldo. Thought I would share in case anyone finds it helpful.”
New message when creating a pre-existing warehouse shipment
Heinrich Vermeulen shared, “The latest minor release of BC creates this super cool message when trying to create a Warehouse Shipment if it already exists! What a breath of fresh air! Love love love BC SaaS.”
New: AllowInCustomization property in AL
Using the Add Field pane, you can obtain access to any field and manage which fields are displayed on the page, drag and drop fields to any location on the page canvas, and more.
The upcoming release of Business Central 2023 Wave 2 (version 23) will include the AllowInCustomizations field property, letting developers specify whether a table field can be used as source expression for new page fields in page customizations. This new property can be useful when protecting fields from displaying in the UI via customizations.
Stefano Demiliani describes this new property and gives a usage example in his blog, Introducing the new AllowInCustomization field property.
MSDW Podcast on AI adoption
Not all artificial intelligence (AI) is created equal. AI is comprised of different technologies, each with different use cases.
Ivan Cole, managing director at Mazars USA, joins Jason Gumpert, editor of MSDynamicsWorld.com, for a discussion about the present and future outlook of AI adoption in the Microsoft environment. This half-hour discussion covers Microsoft’s AI capabilities, how AI could impact various roles, and security for AI adoption.
Take a listen to the MSDW Podcast: Why organizations need an AI adoption framework.
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.