Sumit Potbhare

Microsoft Dynamics AX for Retail

Retail Configuration | Copy from Source to Destination environment in AX 2012 R3

Hi Guys,

In this blog, we are going to see, how can we copy different setups from one environment to another, without any development. You might have come across the different tool to transfer the data from Test to PROD environment, but here we will have a look at the most simple tool i.e “Definition group”.

With “Definition groups”, you can export a single table or group of tables (for a particular set of configuration), that can be directly imported in the destination environment. The “Definition groups” when exported create DAT and DEF file which is required at the time of import. However during import you only select the DAT file.

Export single table in a definition group

Here we will take example of Retail Language Text. This table is legal entity specific and sometimes , if you are dealing with multiple legal entity using same language, you wont be creating the same language text manually again Or if you want to migrate this data to another environment. This can be very time consuming.

Follow below steps:

In your source environment, navigate to System administration >> Common >> Data export/import >> Definition groups.

DefinitionGroup2.png

Click New.

DefinitionGroup3.png

In General tab, enter Definition group as “LanText” and Description as “Language Text”.

DefinitionGroup1.png

In Options tab, un-check everything.

DefinitionGroup4.png

In Include table groups, un-check everything.

DefinitionGroup5.png

Click OK.

DefinitionGroup5.png

Click Select tables.

DefinitionGroup5.png

Add RetailLanguageText table and click Close.

DefinitionGroup5.png

Click “Export to

DefinitionGroup5.png

Enter the File name and click OK.

This will create 2 files .dat and .def. Copy these files to destination environment.

In destination environment, navigate to System administration >> Common >> Data export/import >> import.

DefinitionGroup5.png

In File name, select the .dat file and click OK.

DefinitionGroup5.png

You can perform the above steps for Receipt formats as well (RetailFormLayout).

Export multiple tables in a definition group

Here we will take example of Screen layouts. Screen layout comprises of multiple tables and unless you import all data, the screen layout is not complete.

Follow below steps:

In your source environment, navigate to System administration >> Common >> Data export/import >> Definition groups.

DefinitionGroup2.png

Click New.

DefinitionGroup3.png

In General tab, enter Definition group and Description.

In Options tab, un-check everything.

DefinitionGroup4.png

In Include table groups, un-check everything.

DefinitionGroup5.png

Click OK.

DefinitionGroup5.png

Click Select tables.

DefinitionGroup5.png

Add tables shown in above screenhot and click Close.

Click “Export to

Enter the File name and click OK.

This will create 2 files .dat and .def. Copy these files to destination environment.

In destination environment, navigate to System administration >> Common >> Data export/import >> import.

DefinitionGroup5.png

In File name, select the .dat file and click OK.

DefinitionGroup5.png

Check the screen layouts.

Feel free to reach out for any clarifications. If you like my blog posts then comment and subscribe to the blogs.

You can connect with me on- Facebook | Google+ | Twitter | Skype (sumit0417)

Enjoy RetailDAXing.

Disclaimer: The information in the weblog is provided “AS IS”; with no warranties, and confers no rights. All blog entries and editorial comments are the opinions of the author.
Advertisements

Single Post Navigation

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: