AX – D365FO – Update a field value of a table with the value of a joined table in update_recordset

This example shows that the update_recordset statement supports the joining of several tables. Data from the joined tables can be used to assign values to fields in the table that is being updated. static void Join22aJob(Args _args) { TableEmployee tabEmpl; TableDepartment tabDept; TableProject tabProj; ; update_recordset tabEmpl setting currentStatusDescription = tabDept.DeptName + ", " + … Continua a leggere AX – D365FO – Update a field value of a table with the value of a joined table in update_recordset

AX – D365FO – Add an hyperlink to a Form field to open the master data FOrm of that field

I have a form that contains a field called "IFRS code". I want to add an hyperlink to this field to open a form that contains the master table for that field when clicking on it (like below) If you do nothing you get this error while clicking on the field To solve the problem … Continua a leggere AX – D365FO – Add an hyperlink to a Form field to open the master data FOrm of that field

AX – D365FO – Add a field in a lookup with AutoLookup field Group

I have a lookup in "Released product" form that is linked to a custom table. When I open the lookup I see only one field (Id code), but cannot see the description The description is a field of the custom table so I must add to the lookup to see it. How to to do … Continua a leggere AX – D365FO – Add a field in a lookup with AutoLookup field Group

AX – D365FO – Avoids deleting a record if it has records related to other tables (with table Relations functionality)

If you want to avoid deleting record on a table that has child record related to other table just follow this instructions. You must create a relation between Table "Al0VendorActivity" and "Al0VendorSearcCriteria". We want to avoid delete record from "Al0VendorActivity" if at least one record exists in the table "Al0VendorSearcCriteria". Create a relation between the … Continua a leggere AX – D365FO – Avoids deleting a record if it has records related to other tables (with table Relations functionality)

AX – D365FO – Create Reference and Replacement groups

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 datat types for the 2 fields Create a new form of type … Continua a leggere AX – D365FO – Create Reference and Replacement groups

D365FO – AX – Cache Lookup Property of table

Caches are used on both the client and the server. It increases the performance, the ax will get data from the cache instead of doing round trips and DB calls. So for each table, it's good to use cache lookup property. Microsoft Dynamics Ax runtime manages the cache by removing old records when new records are … Continua a leggere D365FO – AX – Cache Lookup Property of table

D365FFO – AX – SINGLE-RECORD CACHING

Record caching is enabled for a table when all the following statements are true: The CacheLookup property on the table is enabled by setting it to one of the following values: NotInTTS, Found, FoundAndEmpty.The record buffer disableCache method has not been called with a parameter of true. Records are cached for all unique indexes when all the following criteria are … Continua a leggere D365FFO – AX – SINGLE-RECORD CACHING