Microsoft Dynamics AX Support

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

Dynamics 365 for Finance and Operations – Things to consider when exporting data to BYOD

I’ve worked on some cases related to Data Management exports to BYOD recently and I thought I would share some observations on things you should consider when exporting data to BYOD. This blog post is not meant to serve as a comprehensive document outlining how the process works, but rather to raise awareness of the… Read more

DIXF on SQL 2014 – 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” and you are running SQL Server 2014 SP2 CU10 or CU11. 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… Read more

Technical reference reports have been released for 7.3

Updated technical reference reports have been released for Finance and Operations version 7.3: https://mbs.microsoft.com/customersource/northamerica/AX/downloads/reports/axtechrefrep The reports included in the download are: Aggregate measures​ Aggregate data entities​ Configuration key groups Configuration keys Data entities Data entity fields Key performance indicators (KPIs) License codes Menu items Menu items, license codes, and configuration keys SQL Server Reporting Services… Read more

Dynamics AX 2012 – DIXF Performance Benchmark Results

The Dynamics AX InMarket team has provided the following benchmarking results for DIXF imports based on numerous requests for this information. If there are any questions or requests for additional entity coverage please let me know! Problem Statement: Customer is importing around 500K records and the need for some form of benchmarking the performance expected… Read more

Data Import/Export Framework “Group By” condition added

This post was written by David Cao Importing data using the Data Import/Export Framework by default bundles records into equal groups for processing by each thread. This leads to issues like update conflicts for similar grouped records like journals, sales orders etc. The change is required to allow bundling to be based on a specified… Read more

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

Data Management Import Performance Issue with Cursor Fetch

I recently have a data import slowness issue reported taking days to process without finishing even in batch run in parallel.  This issue could occur with any entity import especially for new company go-living or with no data in the target entity.  The impact is exponentially worse when more data is imported, so I would like to share… Read more

How to use DIXF to import an Inventory counting journal into AX 2012 from an Excel source file

I have recently worked with customers whom are using DIXF to import Inventory counting journals into AX 2012 as part of their monthly Inventory counts. As a result of this, I documented an example of how you can use DIXF to import an Inventory counting journal into AX 2012. NOTE:  In this example, the items… 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