In this example we delete the usage data for Class called "TaxReport" of the current user. SysLastValue sysLastValue; delete_from sysLastValue where sysLastValue.RecordType == UtilElementType::Class && sysLastValue.userId == curUserId() && sysLastValue.elementName == 'TaxReport';
Category: AOT
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 … Continue reading AX – D365FO – Add an hyperlink to a Form field to open the master data FOrm of that field
AX – D365FO – Loop through values of a Base enum – X++
SysDictEnum SysDictEnum = new SysDictEnum(enumNum(SalesStatus)); int i; for (i=0;i<SysDictEnum.values();i++) { info(SysDictEnum.index2Label(i)); }
AX – D365FO – Show the Layer in AOT Development Workspace for Elements in AX2012
The Application Object Tree (AOT) in Microsoft Dynamics AX can display information about which layers elements are in or have been modified in. The layer information is shown in parentheses immediately following the element name in the AOT; for example, CustTable (sys). This topic describes how to specify the layer information that appears with elements in … Continue reading AX – D365FO – Show the Layer in AOT Development Workspace for Elements in AX2012
AX – D365FO – Delete a version controlled object from AOT
If you delete a version controlled object from AOT you will probably also want the change to propagate across all AX environments (Test, UAT, PROD). To do this you need to check in the item. The problem is that the object, once deleted, disappears from the AOT, so where do we find it? To find … Continue reading AX – D365FO – Delete a version controlled object from AOT
AX – D365FO – Set NULL/Empty value as a default value on an enum type
It's not possible to set an enum type with a null value This is default behavior of Base Enumeration. By default if user doesn't choose a value the index 0 is defaulted for new record. If you want to achieve what you are looking for, you may add a third element in Base Enum, set … Continue reading AX – D365FO – Set NULL/Empty value as a default value on an enum type
AX – D365FO – SSRS – Use Enum values in filter expressions
This article describes how to use enum values in filter expressions : https://robscode.onl/ssrs-use-enum-values-in-filter-expressions/
AX – D365FO – Add table relation to an extended data type (EDT)
D365FO – AX – Import/Export a report from an environment to another
Open the original environment, go to "SSRR Reports", choose the report you want to export and click export Open the original environment, go to visual studio projects, Dynamics AX model Projects, choose the report you want to export and click export An xpo file will be generated. Save it Open the target environment, go to … Continue reading D365FO – AX – Import/Export a report from an environment to another
D365FO – AX – Convert an enum into a string
Info(enum2Str(SalesStatus::Backorder)); //this will display 'Open order'