Microsoft Dynamics 365 Blog

Posts

DIXF – Importing data using Excel and ODBC 

2 min read

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

0 Comments

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

1 min read

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

0 Comments

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 

2 min read

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

0 Comments

Calling the BudgetTransactionService on AX 2012 

2 min read

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

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