Microsoft Dynamics AX Blog

Today I will demonstrate you that How to create matrix reports in AX 2012. Define a query In the Microsoft Dynamics AX development workspace, open the AOT. In the AOT, right-click the Queries node, and then click New Query. Right-click the node for the query, click Rename, and then type CustTransactions. Expand the CustTransactions query. In the AOT, right-click the Data Dictionary node, and then click Open New Window. In the new window, expand the Tables node. Locate the CustTable table and drag it onto the Data Sources node for the query. Expand the node for the CustTable_1 data source. Select the Fields node, in the Properties window, set the Dynamic property to Yes. Locate the CustTrans table and drag it onto the Data Sources node located within the CustTable_1 data source. Expand the node for the CustTrans_1 data source. Select the Fields node, in the Properties window, set the Dynami...

Today i will provide you document in which i mentioned how to use Map in AX 2012. https://drive.google.com/file/d/0B2QCT01u3M0nRERTVFlTVlEwOFE/edit?usp=sharing

Today i will provide you document in which i mentioned how to use Fixed Field Relation in AX 2012. https://drive.google.com/file/d/0B2QCT01u3M0nWENnQmE2dF9IYU0/edit?usp=sharing

Today I will demonstrate you that How to secure forms in AX 2012.             Create a Form and a Menu Item You can create a form and a menu item by following these steps: Under AOT > Forms, create a form that is named NewForm. Under AOT > Menu Items, create a menu item named NewMenuItem for above form. Add the menu item you created to one of the existing Menus. For example, you can add it to AOT > Menus > Home > Common. Create a Privilege and an Entry Point You can create a privilege and an entry point for NewMenuItem by following these steps: Create a privilege that is named NewPrivilege. Expand AOT > Security > Privileges > NewPrivilege. Add an entry point that is named NewEntryPoint. You do this by right-clicking the Entry Points node, and then clicking New Entry Point. In the Properties window for the new entry point, do the following: Set the N...

Today I will demonstrate you that How to use full text index with AOT tables  in AX 2012. Create a Full Text Index This section describes how to create a full text index on a table by using the AOT. Create a table named FtiTable with two string fields named Field1 and Field2 For better testing, increase the StringSize property from its default value to 64 on both fields. Set the TableGroup property to Main on the FriTable table. Note:- A table can have a full text index only if the TableGroup property is set to Main or Group on the table. Expand the FtiTable node, right-click the Full Text Indexes node, and then click New Full Text Index. This creates a node named FullTextIndex1. Right-click the FullTextIndex1 node, and then click New Field. Click the new index field node so that you can see its properties in the Properties window. In the Properties window for the new index field, set the Dat...

Today i will provide you project (.xpo) file in which i mentioned how to use Group by and Having with AOT Queries in AX 2012. https://drive.google.com/file/d/0B2QCT01u3M0nWE9wU1huVzRrcjA/edit?usp=sharing

Today i will provide you project (.xpo) file in which i mentioned how to filter data of grid control in one form through another form in AX 2012. https://drive.google.com/file/d/0B2QCT01u3M0nOG9fTHZxVGZZNHM/edit?usp=sharing

Today i will provide you project (.xpo) file in which i mentioned how to filter data of one form through another form in AX 2012. https://drive.google.com/file/d/0B2QCT01u3M0nVzlSU1QtbmMxcFE/edit?usp=sharing

Today I will demonstrate you that How to Filter records in form by using Combo Box in AX 2012. 1) Create a Table Named “FilterDemo” and add some fields like Name, Eid, Salary and Add one Base    Enum Like Gender. 2) Enter some Data into  the Table. 3) Create a form Name “FiletrDemoForm”.Drag the FilterDemo Table to the DataSource of the form. 4) Under the Design node of the Form.Create  a New Control à Tab à Tab Page.     Change the properties of the TabPage Like this Name:- General Caption:-General 5) Now Add a new control à Grid to the TabPage.Now Drag the Fields Which should Appear in the Form    to the Grid control from DataSource. 6) Under the Same Tab Page Add a NewGroup. Under the NewGroup add a new control called ComboBox. Change the property AutoDeclaration of the comboBox to YES and BaseEnum to Gender. 7) Now the form creation is complete. Now We need to see the filtering the Record. 8) Now Dec...

Click on link to check ERD or architecture of AX 2012. http://www.microsoft.com/dynamics/ax/erd/ax2012r2/

Today I will demonstrate you that How to create Drill Through reports in AX 2012. Defining a Query To define a query In Microsoft Dynamics AX, open a New Development Workspace. In the AOT, right-click the Queries node, and then click New Query. Right-click the node for the query, click Rename, and then type Assets. Expand the node for the Assets query. Right-click the Data Dictionary node, and then click Open New Window. In the new window, expand the Tables node. Locate the AssetTable table and drag it onto the Data Sources node for the Assets query. In the Assets query node, expand the Data Sources node, expand the AssetTable_1 node, select the Fields node, in the Properties window, set the Dynamic property to Yes. Save the query. Creating a Reporting Project To create a reporting project Open Microsoft Visual Studio. On the File menu, point to New, and then click Project. The New...