Migration - Transfer of closing balance from AX 2012 to d365 F&O as an opening balance

(1) Share

Report

Posted on by AS-30070427-0

Hi Everyone,

We're currently working on one of the migration projects from AX 2012 to D365 F&O, which is also my first time.

However, I don't have any exact knowledge of how to transfer the closing balances of Ax 2012 to D365 as an opening balance. So, looking for detailed knowledge.

Also, wanted to know, during the transfer, do we have to generate the closing balance for all the mentioned financial dimension sets?

It would be really great if anyone can help on it or provide the link for detailed knowledge.

Thank you

All responses (3)

Answers (3)

Sort by

Verified answer

Ramit Paul 22,809 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi,

I am not familier with the AX anymore since it has been many years I have not touched, however to transfer OB from any system, you need to upload via data management/excel add-in D365, whether to take the Financial dimension wise OB or not, this is upto the organization and their MIS reporting.

Example- if the current structure of the org is they maintain reporting PL+ CC+ DP+ BU then you need to take the balance based on these financial dimensions.
Verified answer

Frank Hamelly | MVP... 46,633 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hello, you'll need to export the year end balances for all accounts from AX, then import them using Data Management Framework (DMF) in D365FO. For instance, you would export balances as of 12/31/2023 from AX, then import those balances and post them as on 12/31/2023 in D365FO. Then, you close the year in D365FO, which creates your 2024 opening balances.

As Ramit said whether you export all financial dimension-level detail is up to the business and their reporting requirements. I would think they'd want all financial dimension detail as well.
Verified answer

Alireza Eshaghzadeh 15,225 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi,
In addition to the provided feedback, please consider Chart of Accounts (COT) and financial dimensions on the exported year-end balance. If you use the same COT and financial dimension values in D365FO as in AX, there will be no issue. If not, you will need to create a mapping table to properly map the exported balance from AX with the correct COT and financial dimensions for import into D365FO.