Microsoft Dynamics 365 and Power Platform Library

To import demo data into AX 2012 R3 version, Test Data Transfer Tool was put in place. The Test Data Transfer Tool (beta) has been moved. It is now available from the Downloadable tools section of Microsoft Dynamics Lifecycle Services. Download the test data transfer tool from the below link; https://lcs.dynamics.com/v2/LocalTools/ Steps to import data are well described here https://community.dynamics.com/ax/b/alirazatechblog/archive/2014/05/03/how-to-import-contoso-demo-data-to-dynamics-ax-2012-r3 Test Data Transfer Tool - Video Microsoft Dynamics AX 2012 Test Data Transfer Tool (Beta) Updated 7th Jan 2014 Video

I got a requirement to upload free text invoices into AX 2012 from one excel file. All the header and lines information was in one excel sheet so I had to came up with different solution than the import process described on many blogs or can be done through built in AX classes. However, those import process work perfectly if you have data into seperate files or only for one record. Here is the  job which I used to import free text invoices into AX 2012. In this job I used a table CustomerInvoices (new created table) which contains the data of all excel file. You can easily find out how to import data from excel then instead of using this table you can directly use the excel rows to get the data and insert into Free Text Invoice tables. static void CreateFTInvoicesFromTable(Args _args) {     CustInvoiceTable    custInvoiceTable;     CustInvoiceLine     custInvoiceLine;     CustTable ...

The are many code snippets which you can find easily over the internet to import sales orders from a text file or from excel. The purpose of this post is to share my experience of uploading data into sales order form from two different text files. void ImportSalesOrders() {     Container                  con;     CustTable                 custTable;     SalesTable                salesTable;     SalesLine                  salesLine;     Headers                    headers;     Stock                        details;     num                           newSalesI...

It’s perfectly correct that we always learn when we want to or when we are in need of achieving goals. This happened to me for last couple of weeks when I was looking for different ways to import data in Dynamics AX 2009. I came to know that we can use data definition groups under Administration > Periodic > Data export/import > Definition groups to import data from excel or csv files. Here you can find the complete information to import data using data definition group. Any questions and comments will highly be appreciated!