Publications

RF Interface. Useful links.

Microsoft Dynamics AX 2012 Warehouse Management RF Interface https://community.dynamics.com/ax/b/microsoftdynamicsaxmanufacturing/archive/2014/06/14/microsoft-dynamics-ax-2012-warehouse-management-rf-interface.aspx…

Trace queries with SQL Server Profiler

Launch SQL Profiler and connect to the SQL server Go to Events Sections and check "Show all columns" Click "Column Filters" button On DatabaseName, put your database name or %DBName% for wildcards On TextData and put in " %TableName%"…

FK_ModelElementData_HasModelId_LayerId error

Given Error: SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ModelElementData_HasModelId_LayerId". The conflict occurred in database…

AX model information

Get list of models in a Model Store Microsoft Dynamics AX 2012 Management Shell AXUtil View the contents of a model manifest Microsoft Dynamics AX 2012 Management Shell AXUtil Change model manifest property Microsoft Dynamics AX 2012…

Status bar customization

Personalizing status bar To personalize the status bar, navigate to File > Tools > Options > Status Bar. Select checkboxes for the information that you want to appear on your status bar. Change status bar color Add following line to init…

Custom Text in Status Bar

static void StatusLineText(Args _args) { str msg; msg = "License expires: "+date2str(xinfo::expireDate(),123,2,4,2,4,2); xUserInfo::statusLine_CustomText(true); infolog.writeCustomStatlineItem(msg); }

Deploying AX SSRS report & Security

Security settings 1. Assign the user who is deploying the reports to the System Administrator role on the Report Manager website. By default, the URL is http://<ComputerName>/reports. AX -> System Administration -> Setup -> Business…

Ignore best practice errors

Temporary to check in object 1. Set break point at the end of method And in debugger change return value from false to true. 2. Set Accept in Version Control -> General -> Best practice settings -> Best practice errors. Check object in and…

refresh, reread, research and executeQuery

Refresh This method basically refreshes the data displayed in the form controls with whatever is stored in the form cache for that particular datasource record. Calling refresh() method will NOT reread the record from the database. So if…

Infolog message actions

There is how you can attach action to any infolog line on mouse double click: Same is walid for error and warning infolog global methods. Available actions you can find in AOT:

Update questionnaire answers from X++ code

Change \Classes\KMQuestionnaireAnswerControl_Win32\getControlValue methods from private to protected Create new class which looks like: How to save questionnaire answers from X++ code

Map, MapEnumerator, pack/unpack using XML

static void testMapXml(Args _args) { Map map = new Map(Types::String, Types::Record); MapEnumerator me; CustAccount custAccount = '1001'; CustTable custTable = CustTable::find(custAccount); container cnt; str xml; XmlDocument xmlDocument;…

Convert date to/from User's format

static void testDateConversion(Args _args) { str usrDate = date2StrUsr(systemDateGet()); date dt = str2Date(usrDate, -1); abs(1); }

DataSource findRecord performance issue

Is running on client side and to find the record it have to go though all records one by one starting from the first and ends when it finds correct record. Which is something like table scan in SQL but much more worse. It gives a lot of…

How to debug AX X++ code using Visual Studio

1. Create shortcut at VS PC to load VS using AX AXC file "C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe" /AxConfig "\\servername\c$\AXConfigs\ENV-CUS.axc" 2. Install visual studio remote debug service at AOS PC…

Modify form design at runtime

FormGroupControl formContainer, callCenterContainer; int controllCount, a, lastControl = 0; FormBuildControl control; formContainer = formRun.form().design().addControl(FormControlType::Group, #FormContainer); formContainer.columns(3);…

Search

About

DaxOnline.org is free platform that allows you to quickly store and reuse snippets, notes, articles related to Dynamics 365 FO.

Authors are allowed to set their own "buy me a coffee" link.
Join us.

Blog Tags