Skip to content
Microsoft Dynamics 365 Blog


DIXF – Importing data using Excel and ODBC 

Consider a scenario where you are running AX 2012 R3 and you want to import data from Excel files using ODBC. Having recently worked a case on this topic, I thought I’d share some of the details on how this can be set up. 1. Background The main reason we were looking into this way...Read more

DIXF – Cannot Preview source file – CommunicationException – An error occurred while receiving the HTTP response from DMFServiceHelper.svc 

Consider a scenario where you are importing data using DIXF, and you get an error when you try to “Preview source file”. 1. The error The error you see looks something like this: System.ServiceModel.CommunicationException: An error occurred while receiving the HTTP response to http://servernamehere:7000/DMFService/DMFServiceHelper.svc. This could be due to the service endpoint binding not using the...Read more

Calling the BudgetTransactionService on AX 2012 

We recently had a request for an example of how to call the BudgetTransactionService AIF create operation which allows you to created budget register entries. Setup: Create an inbound AIF port using the first 10 steps (Setup with AX) from the Budget entries import in AX2012 ( to create a NetTcp AIF inbound port. Create...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 (… The document services framework “..replaces a surrogate foreign key (SFK) with the natural key for a specific table relationship.”...Read more