Solution

An example of Query to find InventSerials, when Works Order is known.

An example of achieving same result using While/Select statements.

Class declaration

public class YourClass
{
    // Query objects
    Query                   query;
    QueryRun                queryRun;
    QueryBuildDataSource    qbdsInventTransOrigin;
    QueryBuildDataSource    qbdsInventTrans;
    QueryBuildDataSource    qbdsInventDim;
    QueryBuildDataSource    qbdsInventSerial;
    QueryBuildRange         qbr;

    // Declare a table buffer
    InventTransOrigin       inventTransOrigin ...

There are comments. Feel free to leave your comment.

Using While Select and Ranges in X++ [AX2012]

Solution

An example of While/Select statements to find InventSerials, when Works Order is known. Here I also will use a chance to note the ListEnumerator. No Joins are used in this example.

An example of achieving same result using Queries.

Class declaration

public class YourClass
{
    InventTransOrigin               inventTransOrigin;
    InventTrans                     inventTrans ...

There are comments. Feel free to leave your comment.

Page 1 / 1

Donatas Stonys XYZ

My Online Notebook (Microsoft Dynamics® AX & .NET)

Other articles

Using While Select and Ranges in X++ [AX2012]

Solution

Class declaration

Other articles

Solution

Class declaration

links

social