web
You’re offline. This is a read only version of the page.
close
Skip to main content
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 214

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.

I have the same question (0)
  • Victor123 Profile Picture
    Victor123 214 on at
    RE: Data migration AX2012 -> D365

    Any ideas?

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,160 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.

  • Henrik Nordlöf Profile Picture
    Henrik Nordlöf 249 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,160 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 249 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,160 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. 

  • 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,

  • 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

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 750

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 222 Super User 2025 Season 2

#3
Sagar Suman Profile Picture

Sagar Suman 194 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans