Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Migration - Transfer o...
Finance forum
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by AS-30070427-0 2
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
Categories:
Administration and Setup
Go-Live
Other
Financial Management
  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 10,928 Super User on at
    Migration - Transfer of closing balance from AX 2012 to d365 F&O as an opening balance
    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.
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 3,726 Super User on at
    Migration - Transfer of closing balance from AX 2012 to d365 F&O as an opening balance
    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.
  • Suggested answer
    Ramit Paul Profile Picture
    Ramit Paul 19,086 Super User on at
    Migration - Transfer of closing balance from AX 2012 to d365 F&O as an opening balance
    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.
     
     

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,955 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,987 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans