Archive for May, 2014


Recently, I added some X++ code related to MS hotfix in AX 2012 R2 environment to resolve an issue with Sales order invoicing. After adding the hotfix code, when I was clicking on Invoice button for a Sales order I was getting the below error:

“Removal of suspension of recid allocation for SalesParmLine has failed”.

I tried to do full CIL, AOS restart, delete  *.auc files, but it didn’t resolve the issue. So, I went to Tools -> options -> Development tab under development workspace and then uncheck the ‘Execute business operation in CIL” checkbox. After doing this, I clicked on the Invoice button and then I got the below error in addition to the above error:

“RecordInsertList object not initialized”

Then I looked at the code I added as part of the hotfix and found that the object was infact not initialized. So, I corrected that error and then all went fine after that. The conclusion is, whenever you get this error this might not always be related to CIL generation, so turn off the option in development workspace which I mentioned and then run the scenario again to find out if there are any runtime error in your modified X++ code.


Recently, I was trying to process the out of the box Production order cube available in AX 2012 R2 and got the below error:

The conversion of nvarchar data type to a datetime data type resulted in an out of range value.

I was getting this error due to the DaysDelayed column in ProdTableExpanded View in AX. I found this when I run the following select statement in SQL server management studio:

select DaysDelayed from ProdTableExpanded;

After running the above query, I got the same conversion error which I mentioned above. The resolution is to install the hotfix KB2859489. Here is the lifecycle services link from where you can download and install the hotfix:

After applying the hotfix code in ProdTableExpanded view, the cube successfully processed and deployed in SSAS database.





Recently, I had an issue in AX 2012 feature pack version where posting from AR or AP module resulted in Trial balance update process stuck in InProcess state. The checkbox ‘Update balance during the posting process’ greyed out in Financial dimension sets form and you cannot uncheck or check it again. The resolution for all the trial balance issues is to install the hotfix KB 2864076. This hotfix has lot of other dependent objects, so extra care is required if you are installing the hotfix directly because it may affect your customized objects in current AX implementation.