Dynamics Ax: X++ what’s new

Hi All! As you’ve probably already heard the new major release of Dynamics Ax is out and it’s called Microsoft Dynamics Ax! I have been to the Ax7 technical preview conference so I’ve already prepared some content for you and now that the release is official I can share it all. Dynamics Ax comes along with… Continue reading Dynamics Ax: X++ what’s new

MS SQL Server index maintence

Hi, As we all know index maintenance is important especially on large Dynamics Ax databases, but often I see installations where there are little or no maintenance plans or all kinds of exotic scripts. Therefor I want to show you guys the SQL Server Maintenance Solution by Ola Hallengren, this does not only contain stored procedures for… Continue reading MS SQL Server index maintence

Dynamics Ax Management Shell powershell tips

Hi all, When Dynamics Ax 2012 came out it was shipped with 2 tools AxUtil.exe and the Management shell. In my experience most of the Dynamics Ax developers are already familiar with AxUtil.exe but don’t have much experience in powershell yet. Therefor I decided to write some examples to get you guys going. If you… Continue reading Dynamics Ax Management Shell powershell tips

Dynamics Ax custom WCF service with paging support

Hi all, Lately I’ve been busy developing WCF services to communicate with .NET web applications. All of these web services are custom-made and are using .NET data contracts so that every application uses the same contracts. Due to the high amount of data and performance we had to implement some kind of paging. I had… Continue reading Dynamics Ax custom WCF service with paging support

Dynamics Ax Implementing an InventDim form control

Hi All, Yesterday I was struggling a bit with an InventDim form control on a custom-made form. The problem was that the product dimension look ups were returning none or too much results like example 1. While the correct result should look like example 2. The problem was that I’ve named the item field ServiceItemId instead of ItemId. This… Continue reading Dynamics Ax Implementing an InventDim form control

Dynamics Ax composite queries

Hi all, Currently I’m working on a new Dynamics Ax 2012 project and for that I’m developing a lot of list pages and forms. For these I had to make multiple menu items that open a list page with different filters, you can do this by setting the menu item query property or calling a class which calls the form with… Continue reading Dynamics Ax composite queries

MS SQL Server performance with Dynamics Ax

Hi, Lately I’m working on some projects who experience a bad performance in Dynamics Ax. This can have multiple causes but one of the most important is maintaining the SQL Server. In my humble opinion every Dynamics Ax developer should have a basic knowledge on how SQL Server works and is maintained because it is… Continue reading MS SQL Server performance with Dynamics Ax

Dynamics Ax RunBase overriding dialog with a Form

Hi, Some time ago I’ve found out that you can implement a form into a RunBase dialog, this has the advantage that you can easily use a grid control, etc… or use modified field methods without using controlMethodOverload() method. You can do this by overriding the dialog method and adding the following code. DialogRunbase dialogRunbase… Continue reading Dynamics Ax RunBase overriding dialog with a Form

Dynamics Ax printing logo’s from batch

Hi, Edit Microsoft has released a fix for this problem contact support for this As all of you know the Image class in Dynamics Ax 4.0 and 2009 can only run on client. This poses a problem when you want to print for example invoices with your company logo on it. Having this found out… Continue reading Dynamics Ax printing logo’s from batch

Dynamics Ax Reports with Calibri font

Hi, A customer of mine asked me to change the font of some reports to Calibri. It all went well until we saved a report as PDF, there was way too much spacing between characters. After some days of investigating and contact with Microsoft I’ve found out that it worked on a Windows Server 2008… Continue reading Dynamics Ax Reports with Calibri font

Dynamics ax take screenshots from FormControls

Hi all, Here is a little code snippet for you to take screen shots within a Dynamics Ax client. public void run(FormControl _control) { str SaveToFileName; System.Drawing.Bitmap bitmap; System.Drawing.Graphics graphics; System.Windows.Forms.Screen primaryScreen; System.Drawing.Rectangle bounds;   int x, y, k, l; System.Int32 width; System.Int32 height;   #define.FileName(’DynamicsAx_Screenshot.png’) ;   try { // 5 for the My… Continue reading Dynamics ax take screenshots from FormControls

Dynamics Ax printing from the AOS

Hello, This post will be all about printing from printers that are connected on the AOS instead of the client. First up is installing a printer on the server thats hosts the AOS services. Next is configuring the client and server as shown in the next screenshots: In the printer setup you should now be… Continue reading Dynamics Ax printing from the AOS

Dynamics ax unknown software exception

Hi, Ever had this error “The exception unknown software exception (0xc0000417) occurred in the application at 0x00a13c18”. Solving it is easy, just erase the .AUC files in the folder: C:\Documents and Settings\Current user\Local Settings\Application Data Or for Windows 7 / Windows server 2008 users: C:\Users\Current user\AppData\Local

Dynamics Ax SQL Trace

Hi there, here is a simple job to enable SQL tracing for all your users, this quite handy for optimizing queries. (The macro’s for modifying other fields on the UserInfo table can be found on the ClassDeclaration of the SysUserSetup form.) boolean enable = true; UserInfo userInfo;   #LOCALMACRO.FLAG_SQLTrace ( 1 << 8 ) #ENDMACRO… Continue reading Dynamics Ax SQL Trace

Dynamics Ax RunBaseBatch multithreading

Hi, Next post will be a little tutorial on how the RunBaseBatch framework can work multithreaded. For example in the SalesFormLetter class on the method run, the following code will be found before the query iteration: if (this.canMultiThread()) { batchHeader = BatchHeader::construct(this.parmCurrentBatch().BatchJobId); salesFormLetterEndMultiThread = SalesFormLetterEndMultiThread::newFormLetter(this, salesParmUpdate.ParmId, salesParmUpdate.Proforma); batchHeader.addRuntimeTask(salesFormLetterEndMultiThread,this.parmCurrentBatch().RecId); } The SalesFormLetterEndMultiThread that is being created… Continue reading Dynamics Ax RunBaseBatch multithreading