#TipADay: Copying Data Between Companies using Excel Add-in

Hello everyone Here is little tip on how to migrate data through Excel Add-In  . Through Excel Add-in you have the option of selecting what instance, partition, and company that you want to upload and publish to. Let us work on how we can use the Excel Add-In to copy data between entities. I have not […]

read more

AX2012 R3- How to Import Contoso Data using Test Data Transfer Tool (Beta)

Pre-requisites: 1-      Download the test data transfer tool from the below mentioned link. https://informationsource.dynamics.com//RFPServicesOnline/Rfpservicesonline.aspx?ToolDocName=Microsoft+Dynamics+AX+2012+Test+Data+Transfer+Tool+(Beta)+-+Updated+7th+Jan+2014%7cQJ4JEM76642V-8-1465 2-      Download demo data for AX2012 R3 from partner source site. Steps:  Extract the demo data files from DynamicsAX2012R3DemoData.exe to a specific location. The output folder will contain the files of following extension types: .OUT—– data file that contains metadata for […]

read more

#TipADay: Day 2: Importing Data to Microsoft Dynamics AX 2012 using Excel Add-in

Excel is a great spreadsheet tool and the AX 2012 Add in is even more wonderful. It allows to publish information/data back to Dynamics AX 2012 without any changes in AX 2012  configuration.  In this functioned example, I will show how you can use the Dynamics AX Excel Add-In to update your data.  Before we […]

read more

Pending Vendor Invoice Data Import Utility

Recently, I had to develop a data import utility as a part of one of the projects I was working on. One of the subparts of the data import utility is the Pending Vendor Invoices utility. The architecture of the data import utility is as follows: Staging: Data is first import into staging table, where […]

read more

Troubleshooting Data Import Export Framework Dynamics AX 2012 Error: 0 records have been inserted in Staging Tables

This is one of the errors you get when you are trying to import your Data in AX 2012 through the Data Import Export Framework. It is very frustrating to trace that one record, from a large set of data that is the cause of this error. This error usually arises when your primary key […]

read more

5 ways to import your Data in Microsoft Dynamics AX 2012

A critical phase in any ERP implementation, including Dynamics AX 2012 is the migration of master data. User Acceptance testing is smooth when customer sees their own data and obviously, the system isn’t classified as “functional” unless data is successfully entered as per the desired designs. For beginners and new entrants into ERP, the database […]

read more