Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Data migration AX2012 ...
Supply chain | Supply Chain Management, Commerce
Suggested answer

Data migration AX2012 -> D365

(0) ShareShare
ReportReport
Posted on by Victor123 212

Hi,

We are migrating data from AX2012 R3 to D365 Finance/SCM.

As we didn't want to bring all the data, we are doing more like a re-implementation and migrating data using data entities (DMF).

I have noticed a strange thing with this:

- I have generated source sample file in AX2012 using DIXF.

- Then I have exported data to CSV using DIXF (e.g. Main Acounts).

- Now I have created an import project in D365 and uploaded the generated file - half of the fields have different names and can't be automatically mapped. 

e.g. in AX2012 for Main Accounts there is a field called "CurrencyCode", in D365 entity this field is called "DefaultCurrency".

Anybody knows how to address this differences?

I wouldn't want to manually do all the mapping for all entities.

  • Community member Profile Picture
    Community member 2 on at
    Data migration AX2012 -> D365
    Did anyone get an answer to this question?  I'm happy with manual intervention but would like a spreadsheet or two with field mappings, if anyone has any.
     
    Barry
  • Suggested answer
    Jonnix Profile Picture
    Jonnix 167 on at
    RE: Data migration AX2012 -> D365

    Hello Victor123,

    If you wouldn't want to manually do mapping for all entities i think the best approach is to extract your data with X++ jobs and not from DIXF. In the X++ jobs, use the entity column name as header.

    That's we have done to migrate from AX2009 to D365.

    Jonnix,

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 Moderator on at
    RE: Data migration AX2012 -> D365

    The supported upgrade path is to upgrade the whole database wit LCS tools. Then you don't need to worry about entity mapping. I think it was just the same also with previous upgrades (4.0 to 2009, 2009 to 2012). But if you want to bring only some data then it's a custom process, most likely a bit different for every such customer.

    The entity based master data migration is definetely doable, and in many cases even a better approach, though. 

  • Henrik Nordlöf Profile Picture
    Henrik Nordlöf 243 User Group Leader on at
    RE: Data migration AX2012 -> D365

    Eventually all AX 2012 customers will upgrade. I'd say most of the customers will upgrade to D365. Why shouldn't Microsoft have a tool to make this process easier and more secure. It would be better for all if we knew the mapping and therefore migration was 100% correct.

    When reading about upgrading from AX2012 to D365 in this article, docs.microsoft.com/.../upgrade-overview-2012. I get the impression there is a tool taking care of the data migration. As far as I can see you take a backup of the database upload to LCS and  "Execute data upgrade". It's not very clear how much manual work is involved but the LCS is obviously doing something with the data. Wouldn't it be great if that tool could be available even you don't run the whole upgrade process?

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 Moderator on at
    RE: Data migration AX2012 -> D365

    I'm not aware of such tool or table.

    If you're migrating data manually with data entities, then it's just like migrating from any system to D365. Some manual work (including mapping) is expected.

  • Henrik Nordlöf Profile Picture
    Henrik Nordlöf 243 User Group Leader on at
    RE: Data migration AX2012 -> D365

    We are in the same situation, trying to migrate master data from AX2012 to D365. There must be some tool or translation table mapping AX field names to D365 field name, isn't it?

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 Moderator on at
    RE: Data migration AX2012 -> D365

    The automatic mapping only works if the field names match exactly. I don't see any solution where you would not need to do some manual work either in export or import mapping.

  • Victor123 Profile Picture
    Victor123 212 on at
    RE: Data migration AX2012 -> D365

    Any ideas?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,278 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,011 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans