Showing posts with label SALES ORDER IMPORT/EXPORT FRAMEWORK BY DMF. Show all posts
Showing posts with label SALES ORDER IMPORT/EXPORT FRAMEWORK BY DMF. Show all posts

Monday, 16 March 2015

SALES ORDER IMPORT/EXPORT FRAMEWORK BY DMF IN AX 2012

IMPORTING SALES ORDER HISTORY THROUGH THE DATA IMPORT/EXPORT FRAMEWORK
When you implement Dynamics AX the last thing that you want to do is keep the old system around just so that you can access the historical information.  One example of this is the sales history which is useful for reporting and trending, and also important when a customer calls up and asks about an order from a year ago.  You may think that it is too much work to move all of that information over to your new system, but it’s not so.  Using the Data Import Export Framework you can bring all of your historical sales orders over and be able to access them from within Dynamics AX.
You’re one step closer to cutting the cord on your old ERP system.

How To Do It…

  1. To set up the import, click on the Processing Group menu item within the Common group of the Data Import Export Framework area page.
  2. When the Processing Groups maintenance form is displayed, click on the New button in the menu bar to create a new record.
  3. Then give your new record a Group Name and Description.
  4. After you have done that, click on the Entities button in the menu bar.
  5. When the Entities Processing Group maintenance form is displayed, click on the New button in the menu bar to create a new record for the Sales Order Headers.
  6. From the Entity drop down, select the Sales Order Headers entity.
  7. Then select the Data Source Format that you want to use – in this case CSV will work fine.
  8. Then click on the Generate Source File button on the menu bar to start formatting the data source fields.
  9. When the wizard is displayed, click on the Next button to continue through the splash page.
  10. When the Display Data page is displayed, you can add any additional fields that you may need, but in this case we have enough information.
  11. Then click on the Generate Sample File button on the right hand side of the form.
  12. This will create the sample CSV file for us that we can save away in the Data Import Export working folder.
  13. After you have saved the sample file, just click on the Finish button to exit from the wizard.
  14. When you return back to the Select Entities For Processing Group maintenance form, click on the folder icon to the right of the Sample Path File field.
  15. When the explorer window is displayed, point it towards the SalesOrderHeader.csv file that you just created and click the Open button.
  16. Finally, click on the Generate Source Mapping button on the menu bar to create the mapping to the file.
  17. If everything is fine, then you should get an infolog box that tells you that everything matches up.
  18. Now that we have the format for the header configured, we need to do the same for the order lines.  To do that, click on the New button in the menu bar to create a new Entity record.
  19. From the Entity dropdown, select the Sales Order Line entity.
  20. Then select the Source Data Format that you want to use – again, we will just use a CSV file.
  21. Click the Generate Source File button in the menu bar again to open up the wizard, and click on the Nextbutton to skip the splash page.
  22. For the lines we need to add a couple more fields to the standard template.
  23. Search through the standard fields, and find the ItemId field and click on the Present In Source checkbox to add it to the mapping.
  24. After you have done that you will be able to see the ItemId field in the list.
  25. Add SalesQtyInventSiteID, and InventLocationID as well.
  26. Then click on the Generate Source File button to generate the template.
  27. When the CSV file is displayed, save the SalesOrderLine.csv file to the working directory.
  28. After you have done that you can click on the Finish button to exit from the wizard.
  29. When you return to the Select Entities For Processing Group form, click on the folder icon to the right of the Source File Path field.
  30. Then find the SalesOrderLine.csv file and click the Open button.
  31. All that is left to do is to click on the Generate Source Mapping button in the menu bar.
  32. If everything is connected correctly then you will get a non-descript InfoLog box.
  33. Now we can start populating the import files with our history.  To do this navigate to the working directory and Open up the Sales Order Header template within Excel.
  34. You will be able to see all of the fields that you need to populate.
  35. Just paste in all of the header details into the spreadsheet and save the file.
  36. Then open up the SalesOrderLine.csv file the same way, paste in all of the line details and save the file.
  37. If you want to test the data file, just click on the Preview Source File button within the menu bar of theSelect Entities For Processing Group form.
  38. You will see that the header information is correctly loading.
  39. And you can do the same for the lines as well.
  40. Once you are done, just click on the Close button to exit from the form.
  41. When you return to the Processing Group form, click on the Get Staging Data button in the menu bar.
  42. Then the Job dialog is displayed, click on the OK button.
  43. This will open up the Staging Data Execution form and all you need to do here is click on the Run button.
  44. Then click on the OK button to kick of the staging of the data.
  45. You will then get an InfoLog box telling you how many records were imported.
  46. Finally, click on the Copy Data To Target button in the menu bar and select the Job ID that you just created and click on the OK button.
  47. When the Target Data Execution form is displayed, click on the Run button in the menu bar.
  48. And the last step is to click the OK button to start the import running.

After it has completed, you can look at the Sales Orders, and you will see all of the history is now loaded and available for you to review.
How easy is that?

Labels

#veryusefulcode (1) AIF (8) AOT Maps (1) Args (1) Ax 2009 Reports (2) AX 2012 navigation (1) Ax 2012 Interview Questions (1) AX 7 (2) AX Architecture (1) Ax Backup (1) AX Workflow (2) AX2012 (1) AX2012 R2 (1) Ax2012R3 (1) AX2012R3 Dynamics Connector Step by Step Installation and Configuration (1) AX2012R3 EP Step by Step Installation and Configuration EP R3 (1) AX2012R3 HelpServer Step by Step Installation and Configuration (1) AX2012R3 Rapid Start Connector Step by Step Installation and Configuration (1) AX2012R3 Report Server and Analysis Server Step by Step Installation and Configuration (1) AX7 (1) Best practices (1) Blocking user to enter (1) Collection Classes (1) Container (1) D365FO (3) Data Migration Frame Work ax 2012R3 (1) Deleting duplicate Record from Table – Ax2012 (1) Delivery due date notification workflow in Ax 2012 (1) Development Steps EP (1) Dimensions (1) DIXF (1) DMF in Ax 2012 R3 (1) Dynamics Ax 2012 Interview Questions (1) DYNAMICS AX 2012 INTERVIEW QUESTIONS PART 2 (1) DYNAMICS AX 7 (1) EDT relation Migration Tool (1) EP AX 2012 (1) Ep Lookup (1) Error (1) Event Handler (1) F5 (1) File Handling (4) Filter on AX2012 Listpage (1) filtering (2) financial dimensions in AX 2012 (3) form (1) images (1) Installation and Configration (4) Installation and Configuration (11) Installation of Management Reporter 2012 for AX 2012 (1) Interaction class in ax 2012 (1) Interview Question (1) Interview Questions For Ax 2012 (1) Invent DIm (1) Jobs (2) license (1) List page and form menuitem enable code (1) Methods (1) microsoft Dynamics AX 365FO (1) Number Sequence Generation – AX 2012 (5) Number Sequence2012 (1) OLTP-OLAP (1) Passing Args (1) Passing form caller and menu item caller in ax 2012 (1) Passing Multiple Records Args (1) Posting in Ax 2012 (1) POSTING PURCHASE ORDER (1) Query (1) Query Filter Form (2) Query Ranges in X++ (1) Question and Answer (1) Report (1) Reports Controller class (1) RLS in ax 2009 (1) SALES ORDER IMPORT/EXPORT FRAMEWORK BY DMF (1) Security (1) security roles (1) Security Sysqueryrangeutil (1) Sharepoint 2016 (1) SQL SERVER (1) SSRS (2) SSRS Reports Controller class (2) Table collections & Virtual company (1) Time (1) TIPS AND TRICKS (1) Web service AIF (3) Web Services on IIS (AIF) Step by Step Installation and Configuration (1) workflow ax2012 (1) Workflow installation (1) Workflow Method (3) X++ (1)