Did you ever wonder what the maximum value of a RecId was? In Ax3.0 it is pritty simple. You know that the RecId was a int value and with the function ‘maxInt()’, you get the value. In Ax4.0 and higher, the RecId is changed from a regular int to in64. There is no such function … Continue Reading
Moving DB-objects to other layers … without losing data
Most of us have already been confronted with the problem of tables being inserted in the wrong layer, and when they already contain data it is very difficult to transfer these objects to the correct layer without losing data. I found the following article on Axaptapedia that helps you with this issue: http://www.axaptapedia.com/Move_DB_objects_to_another_layer
Line Number
When you want to create a table were you want to remain the position of the records you create (like the lineNum field on the SalesLine), you just need to define a field on your new table as a ‘CounterField‘. Step-by-step:
Ax2009 different development licenses
When you want to modify objects in Ax, you have to buy a development license. They are divided in four. Base Package This license gives you access for creating/modifying reports/jobs/queries MorphX This license gives you access tot the Data Dictionary node where tables/Fields/enums/Extended Data Types are maintained. The ability to create forms requires the MorphX … Continue Reading
Ax 6.0 Sneak Preview(s)
If you want a sneak preview into Microsoft Dynamics Ax 6.0 and if you want to know all about the new features, follow the MFP-blog!
Lock on form elements in Dynamics Ax
Some end-users like to make their own modifications on their forms (right-click on the form –> setup). Last week I had a customer that was not able to do this trick any more. After some research and a tip from a colleague, I came to the conclusion that this had something to do with overriding … Continue Reading
Use of ‘like’ in a if-statement
In Ax it is possible to use the ‘like’ keyword in a if-statement. This would look like this: 1 2 3 4 if (purchTable.purchId like ’09*’) { // Do something }if (purchTable.purchId like ’09*’) { // Do something }
Using ‘Not Like’ in Ax X++
When you want to use wild-cards in Ax, you can write a SQL statement with a LIKE keyword 1 2 select firstonly purchTable where purchTable.purchId like ’09*’;select firstonly purchTable where purchTable.purchId like ’09*’; When you want to have all the other records (not like), in X++ SQL-statements you have 3 possibilities: 1.!LIKE : 1 2 … Continue Reading
Microsoft Dynamics Mobile Has Been Discontinued
Microsoft Dynamics Mobile for Microsoft Dynamics AX and Microsoft Dynamics NAV has been discontinued. For more information, please visit PartnerSource at https://mbs.microsoft.com/partnersource/solutions/mobile. In response to questions in the marketplace, we made this strategic decision to discontinue the current development of Microsoft Dynamics Mobile for Microsoft Dynamics AX and Microsoft Dynamics NAV due to the broad … Continue Reading
XML parser namespace error
Today I tried to create the following XML-structure in Ax: 1 2 <?xml version="1.0" encoding="UTF-8"?> <personen xmlns:xdb="http://xmlns.oracle.com/xdb" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="Personeel.xsd"><?xml version="1.0" encoding="UTF-8"?> <personen xmlns:xdb="http://xmlns.oracle.com/xdb" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="Personeel.xsd"> I wrote the following to do so: 1 2 3 4 xmlDoc = WGKFunctions::createXMLDocumentWithDeclaration(#version, #encoding, #standalone); root = xmlDoc.createElement(this.rootNode()); … root.setAttribute("xsi:noNamespaceSchemaLocation", "Personeel.xsd");xmlDoc = WGKFunctions::createXMLDocumentWithDeclaration(#version, #encoding, #standalone); root = xmlDoc.createElement(this.rootNode()); … … Continue Reading
