Shashi's Ax.Net Space

Financial reporter “Yet another post if this doesnt open up” If you get a message from the click once installer saying : “Your security settings do not allow this application to be run on your computer” Start with running this from IE. Chrome gives some other issues 1. Add the...

To get an email address for a Customer or vendor, you can use the following statement static void DEL_SS_emailStmtjob(Args _args) { CustTable cust; //Replace with vendTable for Vendors DirPartyLocation dirPartyLocation; LogisticsElectronicAddress elecAddress; LogisticsElectronicAddressRole elecAd...

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 – ...