https://www.sikich.com

Microsoft Dynamics 365 for Finance and Operations: Improved Grid Control

Jonathan Havard

Nov 26 2019

2 min read

March 2020 release of Microsoft Dynamics 365 for Finance and Operations is scheduled to include a new grid control, which inherently supports totaling fields displayed in the grid as well as support for faster data entry.

Since this is a new control, we expect that most existing forms will retain their current set of functionalities, and over time existing forms will be updated to utilize the new grid. Developers should consider using the new grid control when developing custom forms, as it will have better performance for data entry, more intuitive scrolling, as well as a feature to display sums of information.

Functionality to see totals for what is displayed in a grid typically is done via a data method displayed on a form, which requires code to calculate the total, or a fact box control which is linked to the data source. Seemingly, this grid-based feature will be “what you see is what you get,” allowing for a closer link between what the user expects to see and what is displayed. Since it’s built into the grid, we can expect it to have superior performance over the other options that require another query into the data.

The fast data entry feature seems to provide an alternative to records validating and saving when the focused record changes. This could provide faster response time when entering records.

Have any questions about the upcoming improved D365FO grid control, future updates, or D365FO in general, do not hesitate to reach out to one of our experts!

This publication contains general information only and Sikich is not, by means of this publication, rendering accounting, business, financial, investment, legal, tax, or any other professional advice or services. This publication is not a substitute for such professional advice or services, nor should you use it as a basis for any decision, action or omission that may affect you or your business. Before making any decision, taking any action or omitting an action that may affect you or your business, you should consult a qualified professional advisor. In addition, this publication may contain certain content generated by an artificial intelligence (AI) language model. You acknowledge that Sikich shall not be responsible for any loss sustained by you or any person who relies on this publication.

About the Author

Jonathan Havard

Jonathan Havard is a senior solutions architect and software engineer with a focus on extending functionality within Microsoft Dynamics 365 for Finance & Operations and related technologies. With over 10 years of experience, Jonathan assists clients with technical and functional aspects of implementation projects by suggesting business processes and bridging functional gaps in the software when necessary. He specializes in serving clients in industrial equipment manufacturing and distribution industries.