On of my most popular posts is Cleaning up the AIF document log, but this is not the only table that could benefit from a regular cleanup. For some of these standard tables there are little or no cleanup jobs, as an example the cleanup for the AIF document log only runs online in the client… Continue reading Dynamics Ax 2012 History cleanup
Dynamics Ax 2012 my ideal Azure VM setup
Introduction This is just a quick note on how I setup an Ax 2012 on an Azure machine to get the most bang for my buck. The example I’m using is a DEV machine where I keep the sample code for this blog. But you could apply the principles for every environment. Sizing & disks… Continue reading Dynamics Ax 2012 my ideal Azure VM setup
Dynamics Ax 2012 fill factor
Database synchronize We all know that Dynamics Ax constructs its tables and indexes during a DB synchronize, and if we would make changes directly in SQL these could be overridden by Ax when installing model updates and syncing those to the database. But there’s more to creating an index then the defaults Ax does and… Continue reading Dynamics Ax 2012 fill factor
Dynamics Ax 2012 Trace parser with ETW
Hi All, The following subject already exists for a while but I found it so useful that I want to get it out there once more! Lets consider the following scenario: There’s a performance issue in production and no other environment around where the customer or the partner is able to reproduce it or the… Continue reading Dynamics Ax 2012 Trace parser with ETW
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
Enterprise portal: work items for Purchase orders
Hi all, Those of you who work with workflow in the Procurement flow might have encountered the following problem. The client wants to approve Purchase Orders through the Enterprise Portal, but for some reason the work items are not visible, while they are visible in AX Client. Fair enough, you’d say, there actually is an… Continue reading Enterprise portal: work items for Purchase orders
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