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 … Continue reading AX – D365FO – Avoids deleting a record if it has records related to other tables (with table Relations functionality)
Category: Tables
AX – D365FO – Avoid saving record in a table
Imagine you want to avoid saving a record of a table if a particular condition is met. You must access table and use ValidateWrite method Only one record can have this checkbox set to TRUE. If the use tries to set as TRUE another record the record cannot be saved. We will use the ValidateWrite … Continue reading AX – D365FO – Avoid saving record in a table
AX – D365FO – Add table relation to an extended data type (EDT)
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 … Continue reading 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 … Continue reading 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 … Continue reading D365FFO – AX – SINGLE-RECORD CACHING
D365FFO – AX – SET-BASED CACHING
In Microsoft Dynamics AX, groups of records can be cached all at once with set-based caching. Set-based caching can be implemented in two ways: At design time, by setting the table's CacheLookup property to EntireTable.In code, by using the RecordViewCache class. EntireTable Cache When you set a table's CacheLookup property to EntireTable, all the records … Continue reading D365FFO – AX – SET-BASED CACHING
AX – D365FO – Modify existing fields in a table through extension
To modify properties on an existing field in a table, you must first create an extension for the table. You can modify the following properties: LabelHelp textCountry Region CodesExtended Data Type – You can select only extended data types (EDTs) that are derived from the currently selected EDT. The lookup in the property sheet is filtered … Continue reading AX – D365FO – Modify existing fields in a table through extension
AX – D365FFO – MODIFY TABLE PROPERTIES THROUGH EXTENSION
To modify properties on a table, you must create an extension of that table. In Application Explorer, right-click the table, and then select Create extension. A new table extension is created in the selected project, as shown in the following illustration. You can now modify the following properties through the property sheet: Created ByCreated Date TimeModified … Continue reading AX – D365FFO – MODIFY TABLE PROPERTIES THROUGH EXTENSION
AX – D365FFO – Table Properties (CASCADE, RESTRICTED, CASCADE + RESTRICTED)
Example of Restricted -Suppose we have two tables (Customer & Order) and the relation is of One-To-Many i.e Customer can have many orders.So on a parent table i.e.(Customer) if I set a delete action property to “RESTRICTED” for Order table. Then If I go and delete the record from a Customer table. It will first … Continue reading AX – D365FFO – Table Properties (CASCADE, RESTRICTED, CASCADE + RESTRICTED)
AX / Dynamics 365 For Finance and Operations blog 