PWC

Assign Default Values Automatically During the importing process through DIXF During the preparation to import data, we often find ourselves having to fill a lot of values that are often the default values. For example, language, currency, customer group or group of suppliers etc.... In this article i will show you how we can assign default values during the importing process through DIXF. The following example illustrate how to automatically assign default values for  vendor currency  and  vendor group  during the importing process. However we can use the same approach to assign default values for any other fields.   Note: This example assume that you know how to set up the  DIXF Parameters , S ource file  and  Processing Group,  So if you don't know how to configure any of these please read any of my previous articles about the  DIXF .   To...

Convert Field Values During The Importing Process Through DIXF In the last two articles we discussed how to: Configure DIXF To Automatically Generate Unique Key Using Number Sequence. Assign Default Values Automatically During the importing process through DIXF . Today we will discuss how we can convert the field values during the importing process. Sometimes we may need to convert some of the master data values, especially when we planing to import data from a legacy to new system. For example, assume that one of your clients request to reclassify the vendors from a business line to a new one. in this case you can set up DIXF to convert the old business line value to the new value instead of change the business line for these vendors manually. The following example we'll show how to convert the Vendor Line of Business during data import process. However we can use the same approach to change the values for any other fiel...

Import Financial Dimension using Data Import framework | AX 2012 R3 This post illustrate how to import the financial dimension using the data import framework in Dynamics AX 2012 R3.  Follow the steps bellow to import the  financial dimension values to Dynamics AX 2012. If you prefer to watch Video rather than reading the following steps, please visit my YouTube Channel . 1- Go to Data import export framework --> Setup --> Data import / export framework Parameters 2- Click browse to select shared working directory then click Valitate button then close the form 3- Go to Data import export framework --> Setup --> Source Data format, Create new source name and make sure to chose File in the Type then Change the Column delimiter if needed 4- Go to Data import export framework --> Common --> Processing Group, Create New Group then Click the Entities Button. 5- in the entities form select the Dimension Enti...