Microsoft Dynamics AX Support

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

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 – 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

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 (http://blogs.msdn.com/b/axsupport/archive/2012/11/16/budget-entries-import-in-ax2012.aspx) to create a NetTcp AIF inbound port. Create… 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

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