Microsoft Dynamics 365 Blog

New import/export tool and updated guidance! 

1 min read

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

0 Comments

Budget entries import in AX2012 

4 min read

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

0 Comments

Data Imports in AX 2012 

1 min read

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

0 Comments

Surrogate foreign keys in AIF 

1 min read

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

0 Comments

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

8 min read

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

0 Comments

Importing Products into AX 2012 

5 min read

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

0 Comments

Error in upgrade readiness check when upgrading to AX 2012 

1 min read

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

0 Comments

Importing zip codes into AX via AIF 

2 min read

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

0 Comments

Importing Employees in AX 2009 

1 min read

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

0 Comments

AD Import Issue AX 2009 

1 min read

Issue Only a few user are returned when using the “AD Import Wizard” in AX 2009 Cause This problem occurs because some settings on the network domain are required for non-domain administrators to view all users on the domain within the Active Directory Import Wizard in Microsoft Dynamics AX. Resolution Here is one possible workaround to resolve…Read more

0 Comments

Long running process switches from one company to another company 

1 min read

Recently we have seen some cases where during a long running process in AX (for example data import/export, company duplication or create absence journals) the process appears to switch companies, so the process begins running in company A but after a point it continues running in company B, this could then create some records in…Read more

0 Comments