Some table fields in Microsoft Dynamics AX 2009 were moved to different tables in AX 2012. During Upgrade from AX 2009 to AX 2012 it can be helpful to know about some of these field moves.

Helpful Excel File

A Microsoft Excel file is available to help you glean some details of field moves between AX 2009 and AX 2012 R2. The Excel file can be obtained from the Download center at either of the following Http URLs:

http://www.microsoft.com/en-us/download/details.aspx?id=42264

http://go.microsoft.com/fwlink/?LinkID=393737

The name of the Excel workbook file is:

AX5DiffAX6-TableField-AX62-GM.xlsx

The Excel workbook contains several tabbed worksheets. One of the two primary worksheets lists all the TableName+FieldName combination values that are in AX 2009 but not in AX 2012 R2. The other primary worksheet looks in the other direction, as it lists the combination values that are in AX 2012 R2 but not in AX 2009.

Other worksheets are derived from this primary information.

Example Usage

On the tab labeled '5-AX5-Field-RemOrMovInAX6-NoDup', I notice that the AX 2009 field 'AmountPurchaseOrder' occurs only one time in the AX 2009 system, and only one time in the AX 2012 R2 system. Given the description of the primary information, I know the field is on tables of different names between the two versions of AX:

 

 

Next I go to tab ‘1-AX5-TableField-NotInAX6’ and perform a simple Ctrl+F to find the ‘AmountPurchaseOrder’ field. The find reveals that in AX 2009 the field is on the ‘VendParameters’ table:

 

 

 

Next I go to tab ‘2-AX6-TableField-NotInAX5’, find field ‘AmountPurchaseOrder’, and see that it is in the ‘PurchConfirmationRequestJour’ table for AX 2012 R2:

 

 

Now I can narrowly focus on whether there is a significant relationship between this field on AX 2009 and AX 2012 R2. Maybe the field was moved, or maybe the reuse of the name ‘AmountPurchaseOrder’ is a meaningless coincidence.

By the way, I can use the Excel file to easily determine that the ‘PurchConfirmationRequestJour’ table in AX 2012 R2 does not exist in AX 2009.

More Information

In the Excel file, the tab labeled '0-File-Info' provides more information about the contents of the other tabs, and about how to use them to get the particular answers that you seek.

The Excel file was created in response to a request from a customer who was planning to upgrade from AX 2009 to AX 2012.

Please send any feedback you have to our email address - adocs at microsoft dot com. Thank you.

Gene Milener, 2014/March/18