web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

steps to migrated necessary data to go-live in ax 2012

(0) ShareShare
ReportReport
Posted on by 46

Hi all,

this is a very important question, I have been speding lots of time undestanding, configurating, customizing and migrating data. and now comes the real deal.

the plan is to migrate one small company from AX3.0 to AX2012 lets say on december if possible. Everything is set up, all master data (vendors, clients, products, Routes, COA , etc) is migrated as well. but I still missing the financial ( transactions ).

since the AX3.0 will still be running for historial view. We only need just the neccesary to go-live and fresh without historicals. So the question is:

besides the Master data and parameters, what are the steps to follow in oders to get just the necessary data to go-live (or to make a real production enviroment test).

please any easy detailed tutorials how to make it , will be very appreciated as well.

thanks a lot for your time! 

I have the same question (0)
  • Gunjan Bhattachayya Profile Picture
    35,423 on at

    Hi Nestor,

    Looks like you just want to bring over the balances. Please check this post if you haven't already.

  • CBNestor Profile Picture
    46 on at

    Hi Gunjan,

    Have you tried already?. Yeah I have looked. But I little bit complex for me, since I havent done it before

  • CBNestor Profile Picture
    46 on at

    Here is a list That I got long ago from Microsoft.

    I would like to have maybe more detailed ax2012 guide for moving the GL open balances

    GL Open balances – you need to export current trial balance from old system general ledger and perform mapping to new chart of accounts / dimensions, then import it as a daily journal to new system and post it.

    • Inventory open balnaces – you need to take extract these from old system and import them as counting journal to inventory and post the journal.

    • AR AP open orders – make sure to close / invoice all orders that are in process. Extract and import open sales and purchase orders to new system

    • Porduction orders – same as above, only open and not started orders can be exported and imported to new system.

  • Gunjan Bhattachayya Profile Picture
    35,423 on at

    Hi Nestor,

    We have done this before, but we had a finance consultant take care of this part. I worked with him for importing the transactions.

    Do you have a finance consultant with you who can guide you through the process?

  • André Arnaud de Calavon Profile Picture
    303,988 Super User 2026 Season 1 on at

    Moved to the Dynamics AX forum.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    303,988 Super User 2026 Season 1 on at

    Hi Nestor,

    The GL balances consist of subledgers and direct postings. The link provided by Gunjan is a good start for understanding. Apart from this list, you could have open production orders or open projects.

    Agree with Gunjan that probably involving a finance consultant on the migration job would be beneficial here as you don't have experience yourself.

  • CBNestor Profile Picture
    46 on at

    Hi André,

    Thanks for the answer. I'll try to get someone,

    sorry my question but you think this consultant should be also experienced in AX or can be just a general fanancial consultant. I dont know if it might sound silly, but as I told, I know little on the financial issue.

  • Verified answer
    Gunjan Bhattachayya Profile Picture
    35,423 on at

    Hi Nestor,

    Ideally he/she should have experience with AX as you have to go through the modules and check the balances to be brought over.

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Nestor C.,

    If your finance & accounting team is working with AX3.0 already for a couple of years then they should be able to do the data migration of the financial data.

    That's something your financial people should be familiar with.

    AX2012 is more powerful of course but the general finance transaction balance transfer should not be a problem for your finance team.

    Best regards,

    Ludwig

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 653

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 493 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 317 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans