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 – Compare an XPO file with an AOT Object

To compare an XPO file with an AOT Object follow these instructions : Apen AOT, choose the object you want to compare and click Import button Choose the XPO file, click on Show Details checkbox, expand the tree, and click Compare button Choose the layout (cus, usr, etc..) you want to compare with XPO and … Continue reading AX – D365FO – Compare an XPO file with an AOT Object

AX / D365FO – Editable table browser with XppTools utility

XppTools is a very useful custom package that contains facilities to manage D365FO environments like : -Display system field name in the query filter-Display table relation fields-Editable table browser-List of Values to Range-Execute direct SQL in D365FO database-SQL reports-D365FO Infolog call stack-DEVDimensionHelper class-Read Excel and CSV files-Blocking in D365FO-Create ledger journals using X++-Create ledger journal … Continue reading AX / D365FO – Editable table browser with XppTools utility

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 – 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 – 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