Tag Archives: using

How to make an optimized query using direct SQL statements in X++.

In this post we are going  to show you how to achieve this. As a first step we are going to create a new class and  we will proceed as always declaring the variables we are going to use.

Microsoft Dynamics AX 2012 connection using the method LogonAs.

First, we are going to add Business Connector .NET reference, explain in the following block.

Block data insert using RecordSortedList in AX 2012.

For this example, we are going to create a “job”, it will be used to load blocks of data by using RecordSortedList

Warning using loops on temporary Tables on AX.

When you are creating reports that use temporary tables inside of Ax, you should take into account the following: