To enable/disable buttons on PurchTable/SalesTable form, you can customize their respective interaction classes: 1. Classes\PurchTableInteraction 2. Classes\PurchTableInteractionHelper 3. Classes\SalesTableInteraction 4. Classes\SalesTableInteractionHelper Let's say, for example, I want to enable the Configure line button under Product and Supply menu: All you need to do is to find and customize the right method which controls the enabling/disabling... Continue Reading →
AX 2012: Multi-Select Lookup for SSRS Report Dialog
Overview: In this post we'll learn how to build multi-select lookup for SSRS report dialog. We'll create an RDP report with an AutoDesign layout. Controller will be used to run the report. An output menu item will be created to point to the controller class. Each AOT element involved will be described in detail. You... Continue Reading →
AX 2012: Add Report Parameter to SSRS Query Report
In this post we'll learn how to add report parameter and show it in the report dialog for a Query based SSRS report. Please follow the development steps below to achieve it: 1. Create an AOT Query MAKCustTable. 2. Drag CustTable table to the Data Sources node of the query. 3. Set Dynamic property to... Continue Reading →
AX 2012: Chart in SSRS Report
Prerequisites: 1. Reporting services extensions must be installed 2. Visual Studio tools must be installed 3. Dynamics AX should be connected to Reporting services instance In this post we'll learn how to create data visualization in SSRS report using Pie or Doughnut chart. We'll be creating a query based AutoDesign report. This is how our report will... Continue Reading →
AX 2012: Client sessions connected to AOS server
System administrators often need to know how many AX client sessions are connected to AOS server for multiple reasons: 1. View all the existing client sessions to AOS server 2. End existing client sessions to AOS server 3. Reject new client sessions 4. Accept new client sessions To perform such jobs, navigate to System administration >>... Continue Reading →
AX 2012: Creating enhanced inbound port
Prerequisites: 1. Full compile has been performed revealing no errors 2. Full CIL has been performed successfully 3. Incremental CIL has been performed after compiling the new service class To create an enhanced inbound port for your custom service, please follow the steps below: 1. Right click on the service node, CustomerService in this case,... Continue Reading →
AX 2012: Creating parm methods automatically
It is often a tedious task to create parm methods for a class having many data members. Use the following AOT job to create parm methods automatically instantaneously! All you need to do is to declare data members in the class declaration. Make sure the data type and variable is separated by a single space... Continue Reading →
AX 2012: Auto increment a field using LineNum
Do you want a line number field for your table just like we see the line numbers on SalesLine table on the Sales Order? if so then follow the steps below the achieve this functionality. 1. Drag LineNum EDT to the fields node of your table. 2. Create an index on your table and drag... Continue Reading →
AX 2012: Get SID of Logged-In User – whoami
Open command prompt and run the following command to get the SID of the current logged-in user:
AX 2012: Using Temporary Table as Form’s Datasource
First add a method on the form to populate records in the temporary table: public LabelsTable populateRecords() { SysDictTable dictTable = new SysDictTable(tableNum(PurchLine)); SysDictField dictField; TreeNode treeNode; LabelsTable labelsTableLocal; // Temporary table (InMemory) FieldId fieldId = dictTable.fieldNext(0); while (fieldId) { dictField = dictTable.fieldObject(fieldId); if (dictField.isSql() && !dictField.isSystem() && dictField.name() != "Modified") { treeNode = dictField.treeNode();... Continue Reading →