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
Monday, July 16, 2018
Create a Simple Report with AX Query
+10 years of experience with hands-on lead-level background in the full life cycle of software development with demonstrated cross-functional team leadership skills.
Programming:
• ERP :Microsoft Dynamics AX 2012
• Language :X++, C#, C++, XAML, Asp.Net, Html, VB.Net, Android
• Environment : Windows XP, Windows 8, Windows 10, Windows Server
• DataBase : Oracle 9i,10g,11g and SqlServer and SQLlite
Subscribe to:
Post Comments (Atom)
Configure the Firewall on the Enterprise Portal Server
After you install Enterprise Portal, enable Web Server (HTTP) in Windows Firewall. If you do not enable the web server in Windows Firewall...
-
In Reporting Services, reports and resources are processed under the security identity of the user who is running the report. If the report ...
-
The below select query will give the both the Sales Line record count and the sum of sales quantity. static void Test_Data(Args _args) ...
-
To integrate Microsoft Dynamics AX and Analysis Services, you must connect Analysis Services to the Application Object Server (AOS). To do s...
No comments:
Post a Comment