Shashi's Ax.Net Space

If you ever get a error where the RecId being inserted into the table already exists then the SystemSequences table is to be blamed for this In some of my previous blog posts, i update the system sequence table’s NextVal record, which determines the RecId to be given. However, this is tricky. ...

So i had created a UI for the license generator. To create a license in 2012 this was the command: axutil genlicense /file:c:\licenses\MyLicense.txt /certificatepath:c:\certificates\MyCertificate.pfx /licenseCode:MyModule /customer:MyCustomer /serialnumber:1231232123 /password:MySecretPassword123 /e...

A lot of changes have taken place in the X++ language and to align it close to the C# model which is where we want to be. There is no longer any p-code compilation, everything is run from the CIL. This my compilation of what has changed and some examples for them as well. Editing Experience: Visual ...

Embed from Getty Images //embed.gettyimages.com/embed/77745844?et=uLRy2Q1zT_5KouzHVQo-Vw&viewMoreLink=on&sig=AA1hozxGOl6xSM3fN2ltILquIIOVx-GEyY5zye8iYvc= Moving a project to a different model causes Ax to move all the objects inside it to that model as well. You could instead creat...

Coming from my previous blog post Get list of security roles with name , I extracted the label via SQL. I had to break up the Label ID into the Module and then the number. This allowed me to then query the table ModelElementLabel to get the label value Following code can get the Label via SQL NOTE: ...

To get export the security roles along with the AOT name of the security will need you to either write something in X++ or go into SQL I went the SQL route and this is my code: select S.AOTNAME, L.Text as AOTNAME, LD.Text as DESCRIPTION from SECURITYROLE S Left outer join ModelElementLabel L on L.M...

Embed from Getty Images Power BI for desktop is a very powerful tool and can be used to mash up data from different sources. It is definitely one up to the Excel plugins and so far seems to be more lightweight and processes things faster I will go through my findings with PowerBI and Ax to come up w...

Embed from Getty Images This is a checklist I follow to install Models Provided for a installed site Stop the AOS Backup the Database Install models (follow guidelines, you may be told to use the overwrite option) Merge Code (optional) Start AOS Merge Code Stop AOS Compile X++ Option 1 – ...

via Tamás Mészáros So you got updated Model(s) or hotfix(es) and need to make sure your ISV or VAR or CUS / USR layer code has been merged. Lets see what your options are: Create a project for each model and then compare then to the upper layers for changes. — You spend a lot of time giving y...

Moral of the story: NEVER KILL A COMPILER WORKER WINDOW EVER There was a time I “accidentally” closed a compiler widow of a 10 worker process in the 2nd run. Even though the main window notified that a worker terminated without any reason code, it still continued the process and reported...

SQL Makes everything better When ever adding a new hot-fix or a new model from another source we need to compare the code touch points between that and existing code. Ax makes that easy using the compare layers tool, however that only compares layers So the other way is to go code upgrade and us...

One of the errors received when running Print from a Form in AX 2012 (File > Print > Print, Or Ctrl + P) is the following: The AXRDCE extension caught an unexpected exception for report AutoReport. With the following message in the infolog The error message was: Unable to find appropriate se...