Args is your companion in the world of X++ especially when passing parameters in Microsoft Dynamics AX. Args is an abbreviation for arguments. It allows you to pass information from one object to another newly created object. I utilize it frequently to pass the objects, records, strings, etc that I need to have in scope while accessing the…
Data Import/Export Framework (DIXF) entities
This topic lists the entities that can be imported by using the Data Import/Export Framework, the application module that each entity is associated with, and the class, staging table, and target table for each entity. Entity(Entity type) Application module Entity class Staging table Target table Customer(Master data) Customer DMFCustomerEntityClass DMFCustomerEntity DMFCustomerTargetEntity Customer address(Master data) Customer…
Tutorial: refresh, reread, research, executeQuery – which one to use?
X++ developers seem to be having a lot of trouble with these 4 datasource methods, no matter how senior they are in AX.So I decided to make a small hands-on tutorial, demonstrating the common usage scenario for each of the methods. I have ordered the methods based on the impact on the rows being displayed…
How to Write Efficient Queries in Dynamics AX
One of the things an AX developer commonly does is fetch data from tables. In Dynamics AX, irrespective of we are working on AX 2009, 2012 or 365, we can do that by writing a select statement or by building a Query object. Every Dynamics AX developer is fairly familiar with that, but is everyone…
Passing Arg from MenuItem to JOB/Class
To pass args from MenuItem to desired Class/Job : On MenuItem Button properties give the Datasource Name of which your desired arguments have Write Below code on MenuItem Clicked() Below code in class/Job 1 sampleTable = _args.record();
D365/AX7/SQL: ColumnStore VS Index
In older version of Microsoft Dynamics AX , there is no option to use concept of ‘Column Store’.But in Microsoft Dynamics 365 Finance & Operations you can set the “IndexType” property of a index in a table.There are 2 values available – 1) Index 2)ColumnStore. A columnstore index stores data in a column-wise or in…