There are two ways through which we can create tile one by personalizing form and another through code. In this example we'll use code The diagram below summarizes the operations we will perform to add a tile to a workspace These are the steps we'll do : Create an AOT Query objectCreate a simple list … Continue reading AX / D365FO – Create a Tile in a D365FO Workspace with X++
Category: X++
AX / D365FO – Debug Production environment on D365FO On-Premise version
If you have an On-premise D365FO installation it is possible to debug production or test environments by using a development VM and remote debugging tool Just follow these steps : Use a D365 developer environment Use a development environment which is on the domain (and of course the network) with the AOS machine The dev … Continue reading AX / D365FO – Debug Production environment on D365FO On-Premise version
AX / D365FO – Use a SQL Server function in an D365FO View
Need to add a SQL Server function to make some smart calculation into a D365FO AOT View based on Query? In this example I will show how to do that. I will use the FORMAT date function to convert a simple date in YYYYMMDD format First of all you must have a view based on … Continue reading AX / D365FO – Use a SQL Server function in an D365FO View
AX / D365FO – Create index with “Included columns”
If you want to create an Index with Included columns just create the index, add the field and set the "Included column" property to YES
AX / D365fo – Filter by Enum value in an AOT Query
Are you creating an AOT Query and want to create a filter condition by an ENUM field? In the AOT query you can do it by using a data source Range object In the value field property just insert the numeric or string value of the the ENUM field. In this example I used the string value … Continue reading AX / D365fo – Filter by Enum value in an AOT Query
AX / D365FO – Use Wildcards (..LIKE SYNTAX..) in AOT Query objects
Are you creating an AOT Query and want to use a wildcard filter? An example could be that you want to filter all the items that starts with a specific word. In an ideal world you would use the SQL keyword "LIKE". In the AOT query you can do it by using a data source … Continue reading AX / D365FO – Use Wildcards (..LIKE SYNTAX..) in AOT Query objects
AX / D365FO – How to test the Query syntax and results of a Query
Have you created an AOT Query and want to check if the syntax is correct and the results are what you expected? You can create a Runnable class like show below class TestQuery { public static void main(Args _args) { /* Example job used to test query results with.: */ QueryRun queryRun; Counter totalRecords; // … Continue reading AX / D365FO – How to test the Query syntax and results of a Query
AX / D365FO – How to create automatic join relationship between tables in an AOT Query
Are you creating an AOT query and want to join 2 or more tables but don't know the relationships between them? No problem! You can use the "Use Relations" property like shown below In this example I want to to use the native relation between InventSerial and InventSum tables (which is InventSerial.ItemId = InventSum.ItemId). By … Continue reading AX / D365FO – How to create automatic join relationship between tables in an AOT Query
AX / D365FO – Auto refresh form grid data after pressing menu item
Want to refresh a Form grid data after pressing a menu item? Just set the Form Menu item Auto refresh data Property to "Yes" like shown below
AX / D365FO – SQL Server password for user “axdbadmin” in locally deployed D365 for Operations environments
By default the password for user axdbadmin is AOSWebSite@123