Total Pageviews

Search This Blog


Tuesday, September 20, 2016

Quick tip - How to acivate demo data for Fleet Management in AX 7


Fleet Management is a custom module introduced in AX 7 for demo and training purpose and we have some tutorials around fleet management.

The other day I was putting up a quick demo around reservation management workspace and found the workspace empty with no data in it.

A quick way to activate Fleet Management with demo data is to go to

Fleet Management > Setup > Fleet Setup > Create sample customers, rentals and vehicles

Happy Daxing!

LCS - Monthly Updates

A core component to the new Dynamics AX is LCS and it's recommended to keep an eye on the monthly updates:

In August, the following key features were updated:
  • Database Refresh Request - You can request that sandbox environments to be refreshed with DB backups directly from LCS.
  • Methodology Update - Now, you can attach documents to methodology tasks
  • Issue Search - View additional status details for active bugs and subscribe to email notifications when an issue is resolved. View detailed info about the line number and code changes

Thursday, August 25, 2016

New Developer Courses in Microsoft Dynamics Learning Portal

Microsoft Dynamics Learning Portal is a great resource to get started and acquire knowledge on the new Dynamics AX.You will need a partner account or PartnerSource Login to ign into the portal. Some new courses added recently in last few weeks in Dynamics Learning Portal and maybe some interest to developer community:

Wednesday, August 10, 2016

Dynamics AX 2012 and SQL 2016 Support

Greetings Friends!

A quick post!

Microsoft has recently announced the support for AX 2012 with SQL Server 2016. This is exciting news as we have more possibilities integrating Dynamics AX 2012 with Power BI and Entity Store

Announcing support for Office 2016 and SQL Server 2016 with AX 2012 R3 and R2

Monday, May 30, 2016

Troubleshooting Illegal data conversion from original field synchronization Errors Dynamics AX 2012

Hi All,

Recently, I encountered this synchronization error in AX 2012


I got this error on opening Customer form after I did a update of my local AX with a copy from UAT AX.


Illegal data conversion from original field CustTable.ServiceRegionsDN to CustTable.ServiceOrderDN: unable to convert data types to anything but character field type (14 to 49)

Note: ServiceRegionsDN and ServiceOrderDN are custom VAR fields.


Note - Please be careful while doing any SQL update from database. I did this in my local sandbox, Not recommended to do it in Production AX.

Check the field id in AOT and compare it with SQLDictionary table in SQL with the following query

select * from sqldictionary where TABLEID in (select TABLEID from sqldictionary where name = 'CustTable')
and name = 'ServiceRegionsDN '

Update SQLDictoniary table with the correct fieldid
update SQLDICTIONARY set fieldid = 60080 where TABLEID in 
(select TABLEID from sqldictionary where name = 'CustTable'
and name = 'ServiceRegionsDN '

Reference -