AX / D365FO – Preserve form query filters after explicit executeQuery call on a data source

Have you ever noticed that when you explicitly call DataSourceName_ds.executeQuery() it reinstantiates the queryRun of the form and thus removes all the query filters (not ranges!). This article explains ho to preserve form query filter throught Extension after explicit ExecuteQuery call on a data source : https://community.dynamics.com/365/financeandoperations/b/elandaxdynamicsaxupgradesanddevelopment/posts/preserve-form-query-filters-after-explicit-executequery-call-on-a-data-source-helper-class-included

AX / D365FO – Using Aggregate functions (Count, Max, Avg…) in a View

Suppose that you want to create a form that show a list of customers with the total count of their sales orders The result should be something like that.. But how to do that? You just need to follow these steps : Create an AOT QueryCreate an AOT View linked to the previous queryAdd a … Continue reading AX / D365FO – Using Aggregate functions (Count, Max, Avg…) in a View

AX – D365FO – Create a “Simple Details w/Standard Tabs” Form

First create a new Table "Al0VendorSearchCriteria" AccounNum is take from VendTable.accountNumStatesId is of type Int64 Al0VendorActicivityId is of type Int64 (taken from another custom table that could be seen in my article : https://d365ffo.com/2021/07/04/ax-d365fo-create-a-simple-and-detail-tree-form/ Create a relation betewwn Al0VendorSearchCriteria and Al0Activity Create Extended data types for the 2 fields Add 2 field s to the … Continue reading AX – D365FO – Create a “Simple Details w/Standard Tabs” Form

AX / D365FO – Make a form editable by default using “Always Open for editing” Property #ax #d365ffo #msdyn365fo

By default in D365FO a form is not immediatly editable. If you want to edit you first have to click on "Edit" button in the top left of the screen (like shown below) If you want a form to be immediatly editable you must open "Options" property and click on "Always open for editing". Next … Continue reading AX / D365FO – Make a form editable by default using “Always Open for editing” Property #ax #d365ffo #msdyn365fo

AX / D365FO – Create a Simple List Form in D365FO #ax #d365fo #msdyn365fo

This is a Simple list form and it's the final result we want to obtain Here are the steps to create a Simple List Form in D365FO Right click on VS Project and Add new item Click on Dynamics 365 Items > User Interface > Form > Insert the Form name > Add Right click … Continue reading AX / D365FO – Create a Simple List Form in D365FO #ax #d365fo #msdyn365fo