Migration unit of measure conversions from AX 2009 to Dynamics 365 for Finance and Operations

 In Blog

Here’s an issue that’s come up for us a couple of times while doing AX 2009 to Dynamics 365 for Finance and Operations upgrades.

The DMT toolkit provides an entity to migrate Unit Conversion data from AX2009 to D365. However, an issue is encountered when this data is imported into D365 using the default settings. There seems to be an issue with the entity in D365.

What’s the issue?

Here is the scenario:

In AX2009 the unit conversion is: “From unit” * “Factor” = “To unit”

An example would be FT * 3 = YD

FT to YD conversion in AX 2009

Exporting this using the DMT yields the following in the excel workbook, which looks correct.

Excel file output from AX 2009 data migration toolkit

In Dynamics 365 for Finance and Operations, we use the Unit Conversions entity to load the data. The default mappings look correct:

Default mappings in Dynamics 365 Unit conversions entity

However, upon loading the data, the result we get is unexpected. The factor has switched the “From unit” to the “To unit”. This creates inaccurate conversions.

Results of import in Dynamics 365

Sample results based showing a wrong conversion

Workaround:

Modify the mapping during import by mapping the “From unit” in the Source to the “To unit” in the Staging and vice versa. This will ensure that the conversions are correct.

Workaround mapping

The result looks as expected.

Results after workaround applied

Sample results after workaround applied

The same applies to the Product Specific Unit conversions entity.

 

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Contact Us

Have a question? Want more information? Let us know!

Not readable? Change text. captcha txt