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, ...
Unanswered

Changing account structure and new financial dimensions

(1) ShareShare
ReportReport
Posted on by 2
Hi,

I have a requirement to change an existing account structure to include a new financial dimension.

All 10 legal entities on the environment have the same account structure in their ledger, but only 2 of the legal entities will be using the new financial dimension.
The other legal entities should not use the new financial dimensions at all, and their account structure should not include it.

The current account structure is for both income statement and balance sheet main accounts and used in budget control configuration.
The new financial dimension is only applicable to income statement main accounts. It will be used in budget control and can therefore not be an advanced rule.

To achieve this, I want to create two new account structures (one income statement and one balance sheet) and remove the old structure from the ledger for the 2 legal entities.
I do not think I can use effective dates to move from the old to the new structures, as the other legal entities will continue to use the old structure.

Any pitfalls or advice on how to proceed from switching to one account structure to another?
I have the same question (0)
  • Morgan Bazin Profile Picture
    95 on at
    Hi,
     
    Based on what you've indicated, creating a new set of account structures with the new financial dimensions added appears to be the right way to manage this.
     
    Pitfalls:
    • It is possible any unposted transactions in the system may evaluate on the old structure - so they may error - this is mitigated by ensuring all trx are posted before activating the new structure.
    • If you change the order of the dimensions, historical transactions may resolve the financial dimension incorrectly for reporting - add the new dimension to the end of the string.
    Basically - create your account structure, make sure everything is posted, then on the Ledger form for the legal entities that are going to be different - remove the existing structures and add the new ones would be the high-level process.
  • André Arnaud de Calavon Profile Picture
    301,109 Super User 2025 Season 2 on at
    Hi EssentialFinance123,
     
    There are some more pitfalls.
    New dimension value sets will be created for the new account structure, having a new reference ID for the same ledger account and dimension combinations. This can result in errors in case you must post tax payments/settlements or reverse transactions. I haven't tested if this was solved already.
     
    Instead of creating new account structures, have you considered using advanced rule structures to add the dimension for the two legal entities?
     
  • CU22040535-0 Profile Picture
    2 on at
    Hi André, to your proposal about Advanced rules. We are now facing the same decision in our project to be implemented and I was also having a think of using the advanced rules, but this fact has questioned it: the Advanced rules are connected with Account structure and when the same AS is used for all LE then these additional new FDs will be also asked in all the LE using the same AS and therefore will not meet the requirement that other LE shouldn´t require them. So, could you please outline in more detail how the solution with Advanced rule might look like according to you? Thank you in advance!
     
    Regards,
    Veronika

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 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans