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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Database upgrade: finance dimension remapping

(0) ShareShare
ReportReport
Posted on by 150

Hi,

Although, I think this is not possible via some standard approach, I just wanted to confirm this anyways. Is it possible to switch from custom to entity-backed financial dimensions during database upgrade from AX2012 to D365? Dimensions have already been used on transactions. I know that dimensions are off-limits once they are used on any transactions. For example, dimensions cannot be deleted when the following conditions are true.

  • Has the financial dimension been used on any posted or unposted transactions, or in any type of dimension value combination?
  • Is the financial dimension used in any active account structure, advanced rule structure, or financial dimension set?
  • Is the financial dimension part of a default financial dimension integration format?
  • Has the financial dimension been set up as a default dimension?

Thank you

I have the same question (0)
  • Suggested answer
    Lucas Boewood Profile Picture
    on at

    Hi silentsquirrel,

    This does not sound like it would be possible. Perhaps the upgrade documentation and tools will help determine this for sure.

    docs.microsoft.com/.../upgrade-overview-2012

    Another option would be to open a ticket with our tech team that handles upgrade issues.

    docs.microsoft.com/.../lcs-support

    I hope that helps!

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi silentsquirrel,

    Can't your finance people change their account structures and findims used after the upgrade?

    What would stop them from doing that in D365FO?

    Best regards,

    Ludwig

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    301,020 Super User 2025 Season 2 on at

    Hi silentsquirrel,

    When you do a full DB upgrade, you can't change the dimensions, only create new dimensions and adjust the account structures to use the new ones.

    You can also consider another upgrade procedure by only moving setup and master data. Then make changes to the dimensions and load opening balances. In that case, you will have the full history in AX2012 and start with a clean environment in Dynamics 365.

  • silentsquirrel Profile Picture
    150 on at

    Thanks everyone for your input! I will evaluate different option and their pros/cons.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
Martin Dráb Profile Picture

Martin Dráb 646 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans