Skip to content
Dynamics 365 Blog

New import/export tool and updated guidance! 

We are pleased to announce the release of the Microsoft Dynamics AX 2012 Test Data Transfer Tool (beta) on InformationSource!This command-line tool exports data from a Microsoft Dynamics AX 2012 business database, and imports it into a Microsoft Dynamics AX 2012 business database ina non-production environment. Internally, we’ve called this the Dataport tool, and we...

Read more

Budget entries import in AX2012 

In AX 2012 Budget entries can be inserted using the Office Add-ins. This functionality is helpful also to copy an existing budget into a new one, since the “copy-budget” functionality, avaialble in AX2009, is no more available in AX2012 due to the major re-design of the budget module and functionalities.   Below, all the steps...

Read more

Data Imports in AX 2012 

We have had many, many questions around importing data in AX 2012. Until recentlythe best way to do imports has been through the use of services. Services arestill a great way to import data but you have more choices now. Fairly recentlythe Data Migration Framework tool (DMF) became available as a public beta. The DMF...

Read more

Surrogate foreign keys in AIF 

Although the use of “natural keys” in place of surrogate foreign keys in AIF is a documented design change in AX 2012, it seems there are still some questions around this functionality. Per the documentation (http://msdn.microsoft.com/en-us/library/gg879708.aspx)… The document services framework “..replaces a surrogate foreign key (SFK) with the natural key for a specific table relationship.”...

Read more

How to import default site and warehouse locations for a product using services (AIF) 

I have recently had questions around how to import default site and warehouse locations for products when using AIF, so I thought an explanation and an example here might be helpful. Three tables need to have the correct Dimension ID relationships setup in order for the item todefault the correct Site/Warehouse combination. Within AX, you can set these...

Read more

Importing Products into AX 2012 

We have had several questions on how to import items/products into AX 2012.  There is a blog the development team created around calling the services needed to import those items.  In the example below we used the same code the development team used and re-wrote it so that it might look more familiar to you.  That is to say,...

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

Importing zip codes into AX via AIF 

If you are importing addresses into AX you will discover that the zip codes in your addresses need to exist in AX before you can successfully import the addresses.  This is true regardless of the tool you are using to perform the imports.  If you are using AIF there isn’t an out-of-the-box service within AX form zip code imports.  The existing DirAddressService...

Read more

Importing Employees in AX 2009 

To import employees via Excel use a concept similar to the import of customers and vendors but add additional tricks to get the Name and Search name fields from the DirPartyTable populated.  (If you are unfamiliar with importing customers and vendors see KB article #960729.) When defining your Excel import choose to import into the EmplTable...

Read more