Migrating data from AX2012 to D365F&SCM – Enums

When upgrading from AX2012 to D365F&SCM you need to bring data from your old system to the new environment. If you are not using the full migration path, and just extracting data and importing via the data management system (DIXF), then you will need to ensure you handle the data of the enums correctly.

Enum data in AX is typically stored as an integer, with each integer value being mapped to a string for the user interface.

In D365F&SCM some enums are setup the same way, but some are different. Enums are recommended to use reference rather than values. This makes extensions and maintainability easier. There is a parameter on each Enum called “UseEmumValue”. If set to ‘yes’ then the enum will store the integer in the database, but when set to ‘no’ it will store the enum value’s name.

When migrating data to D365F&SCM you will need to ensure you check each enum to determine two things. First, is the destination using the enum value or name, and do the values between the system match? If either is different, then a translation will need to be completed as part of the migration.

Leave a comment