Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support Teams Worldwide

DIXF – AX 2012 R3 – KB3216243 – Assume service is on active SQL Server node

We recently released a DIXF Application Hotfix for AX 2012 R3 that you may want to take a look at if you are running a Clustered configuration / AlwaysOn configuration: The changes in the hotfix introduce a new option of “Assume service is on active SQL Server node” on the “Data import/export framework parameters” form…. Read more

EntityStore – AX 2012 R3 – DMFIsInEntityDBPublishAndPublishAll object not initialized

I’ve seen this error a couple of times in the past month or so, and I’ve also noted that some people have asked about it on the Internet, too. I’ve just finished working on a case with a customer where we were able to reproduce this issue on a VM. We found that patching the… Read more

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 – Compare Entities – SQL Server replication tool is not installed

Consider a scenario where you are running AX 2012 R3 and you want to compare entities between AX companies using DIXF, but you get an error telling you that the SQL Server replication tool is not installed. 1. The DIXF functionality On a CONTOSO Demo Data TEST environment, you can find the functionality by navigating… Read more

DIXF – How to manually add a missing mapping to the DMFASSETENTITY entity

I recently worked on a case with a Partner that reported that the ‘Name’ field for the DMFASSETENTITY entity did not get imported as expected into their AX 2012 R3 CU9 environment, so I thought I would share how we resolved that by manually adding the mapping, and how we tested the solution. 1. Repro… Read more

DIXF – AX 2012 R3 KB3061216 – Support for new DIXF entities

We released a useful DIXF Application Hotfix in October 2015 which you may not be familiar with, and as I’ve recently been looking into this for a customer, I thought I would share some details on this topic. If you are running AX 2012 R3, then you can install KB3061216 and add a large number… 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

DIXF – Importing Data – How to use Auto-generated to import PartyNumber

Consider a scenario where you want to import data into AX 2012 R3 using DIXF, but you want a particular value to be auto-generated by the system rather than input from a text file. The following blog post aims to show how this can be done for a specific DIXF entity, so you have an… Read more

DIXF – Importing Data – How to establish which rows you need to look at when you aren’t able to import every row in your input file

Consider a scenario where you are importing a lot of data using DIXF, but one or more of the rows in the input file contain “bad data” that result in some rows not being imported OK into your staging table. How do you establish which rows are the problem, so that you can correct them?… Read more

Importing a General Journal using Data Import/Export Framework AX 2012

Here is a tutorial on how to configure Dynamics AX 2012 to import a general journal from a CSV file. The steps below are using Contoso demo data. Create a new folder on the root of the C: Drive and name it “DIEF”: Navigate to Data import export framework | Setup | Data import export… Read more