Skip to content
Microsoft Dynamics 365

Dynamics AX Table Caching: Basic Rules 

This post provides some basic general guidance to get you started on setting table caching for custom tables, bearing in mind there will be exceptions. This should generally be defined at design time to avoid costly round trips to the database. As explained by Bertrand Caillet from our PFE (Premier Field Engineering) team: “This is...

Read more

Managing general performance issues in Microsoft Dynamics AX 

Updated on 09/09/16 for DynamicsPerf v2.0. Intended for versions up to AX 2012. This post is primarily aimed at non technical readers and those responsible for coordinating or managing these issues, but with links drilling through to more in depth blogs containing further details. By ‘general performance’, I mean a set of unidentified performance issues...

Read more

How to perform a data center change (change of the physical location) where a SQL server 2008 R 2 cluster installation and MS Dynamics AX 4.0 is involved? 

Basically you have 3 possibilities to proceed with the physical change of the data center locations: 1) You shut down the existing servers in the old data center in a controlled manner, transport these servers physically to the new data center and start them up there in a controlled manner again. 2) You leave the...

Read more

Standard sales tax (IVA) percentage increases from 21% to 22% in Italy – possible setup 

Starting from October 1st 2013, in Italy the standard sales tax percentage increases from 21% to 22%  (blog written on September 30th 2013. Any possible adjournment by the government should be verified before applying the setup proposed below). Important notes: a) please refer to the fiscal law for additional details on services, goods and transaction...

Read more

Overview of Microsoft Dynamics AX build numbers 

For newer versions click here -> Microsoft Dynamics 365 for Finance and Operations builds Microsoft Dynamics AX 2012 R3     (Roadmap survey) Version Build Availability Download link Recent kernel build 6.3.6000.8144 28 Feb 2019 KB4492767 February 2019 Update 6.3.6000.8149 20 Apr 2019 Feb 2019 Release Cumulative Update 13 6.3.6000.149* 13 Sep 2017 KB4032175 Cumulative Update 12 6.3.5000.138*...

Read more

Error in upgrade readiness check when upgrading to AX 2012 

Recently we ran into an issue where the “Check Upgrade Readiness” step in upgrading from Dynamics AX 2009 to Dynamics AX 2012 failed with the error/stack below Error executing code: ReleaseUpdateTransformDB50_UnitOfMeasure (object) has no valid runnable code in method ‘initTransformationJobs’. (S)\Classes\ReleaseUpdateTransformDB50_UnitOfMeasure\initTransformationJobs(C)\Classes\SysCheckListItem_CreateShadowTables\populateScripts – line 20(C)\Classes\SysCheckListItem_CreateShadowTables\main – line 38(C)\Classes\MenuFunction\run(C)\Classes\SysHelp\processMenuFunction – line 85(C)\Classes\SysHelp\processStandardLink – line 26(C)\Classes\SysHelp\processOnEventNavigate – line 40(C)\Classes\SysHelp\onEvent_BeforeNavigate2 –...

Read more

Using skipDeleteActions with doDelete still calls the delete actions 

Recently we came across an issue where running code like this:     Unit unit;    ;    select firstonly forupdate unit where unit.UnitId == ‘cl’;    unit.skipDeleteActions(true);    unit.doDelete(); This results in the delete still being called on Tables\UnitConvert (via the cascaded delete action on Tables\Unit). This is because SkipDeleteActions() only works when using a set based operation (like...

Read more