Create a Simple Report with AX Query

1. Open Microsoft Dynamics AX.

2. Press Ctrl+Shift+W to enter the development environment.

3. In the AOT, right-click the Queries node, and then click New Query.

4. Right-click the node for the query, click Rename, and then type "CustTrans_W1".

5. Expand the CustTrans_W1 node.

6. Right-click the Data Dictionary node, and then click Open New Window.

7. In the new window, expand the Tables node.

8. Locate the CustTrans table and drag it onto the Data Sources node for the CustTrans_W1 query.

9. Expand the CustTrans_1 Data Source node. 

10. Select and drag the following fields from the Fields node under
CustTrans table to the Field node under CustTrans_1 data source:

o AccountNum

o AmountMST

o TransDate

o TransType

o Txt

11. Right-click the Fields node of the query, click Properties.

12. Set the Dynamic property to No so fields can be removed from the view.

13. Save the query. 



Best Regards,
Hossein Karimi