AX / D365FO – Show “NoYes” Enum field as Combobox instead of Checkbox

I'm building a form from a table. One of its fields is a enum YesNo. I can't figure out why every time I add it to the form it appears as a checkbox instead of a combobox. I want a combobox with a lookup and inside display the values "Yes" and "No". After several attempts … Continue reading AX / D365FO – Show “NoYes” Enum field as Combobox instead of Checkbox

AX / D365FO – How to add enum filter with “All values”

Sometimes customers request a specific filter in a form. The filter is based on an enum and must have All element to display all records regardless of field value. For example, a filter has 3 elements: All, Quotation, Order; although enum has only 2 elements: Quotation, Order. To achieve the result you need to add a ComboBox control in codeThe algorithm is the following:- … Continue reading AX / D365FO – How to add enum filter with “All values”

AX / D365FO – How to get values of base enums using code in x++

static void getEnumValues(Args _args) { EnumId enumId = enumNum(LedgerDimensionType); //Put here your enum DictEnum dictEnum = new DictEnum(enumId); int numOfValues = dictEnum.values(); //This method gets the total number of enum values int counter; for(counter = 0; counter < numOfValues; counter ++) { //You can use the number of method exposed by DictEnum class Info(strFmt('%1',dictEnum.index2Value(counter))); Info(strFmt('%1',dictEnum.index2Symbol(counter))); … Continue reading AX / D365FO – How to get values of base enums using code in x++

AX / D365FO – How to Hide Enum values on a Form Lookup x++

Suppose you have a Form with an enum control ABC which contains values A,B,C. you want to hide last value of enum "C" while displaying it on the form. You have 2 ways to reach the result : Override the "Run" method in your Form (Preferred solution) public void run() { super(); YourEnumControl.delete(enum2str(ABC::C)); } Override … Continue reading AX / D365FO – How to Hide Enum values on a Form Lookup x++

AX / D365FO – FIlter an AOT Query by multiple Enum types fields

Are you creating an AOT Query and want to create a filter condition by multiple ENUM types field? In the AOT query you can do it by using a data source Range object and separate value by comma In the value field property just insert the numeric or string value of the the ENUM fields. In this example I … Continue reading AX / D365FO – FIlter an AOT Query by multiple Enum types fields

AX / D365FO – How to get a Base enum integer internal value with a SQL Server query or a Job

Are you like me going crazy to figure out how to find the integer value of an enum type? No problem, the solution is around the corner. In this case you have 2 options : Open SSMS SQL session and run a query.Create a job / Runnable class SQL Query select t1.NAME,t2.ENUMID,t2.ENUMVALUE,t2.NAME EnumValueName from ENUMIDTABLE … Continue reading AX / D365FO – How to get a Base enum integer internal value with a SQL Server query or a Job

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