Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Adding a new financial dimension to shared account structure in a production environment

(1) ShareShare
ReportReport
Posted on by 8
Hello,
 
I need to add a new financial dimension to an existing account structure in a production environment. The production environment has multiple legal entities, and has many transactions posted already.
 
The current account structure:
(a) includes all main accounts (both income statement and balance sheet)
(b) is used by all legal entities (companies) in the environment
(c) is selected in the budget control configuration (Budget control is only active on the income statement range of main accounts)
 
The new financial dimension:
(d) is only applicable to some of the legal entities, not all
(e) is only applicable to income statement main accounts
(f) cannot be used in an advanced rule as the financial dimension will be used in budget control configuration
 
The two options that I see are:
1. Amend the existing account structure to include the new financial dimension, and set to allow blanks in the account structure
2. Create a new account structure that includes the new financial dimension, remove the current account structure from the ledger and budget control configuration for the legal entities that require the new dimension, and add the new account structure instead.
 
Are these two options feasible, and is one higher risk than the other?
A main concern is data corruption, and errors due to open items using the old account structure. As all legal entities currently use the same account structure, these are key concerns.
 
Advice would be appreciated, Thank you!
  • D365 Adding a new financial dimension to shared account structure in a production environment
    Hi Frank,  
     
    Thank you for your reply. By define effective dates, are you referring to "Active from" and "Active to" dates in the account structure itself?
    My concern is the current account structure must remain active for the other legal entities in the environment. Is it possible to define the dates per legal entity (company)?
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,226 Super User 2024 Season 2 on at
    D365 Adding a new financial dimension to shared account structure in a production environment
    Option 2 seems preferable to me.  You can define an effective end date on the existing structure(s) and an effective start date on the new structures to provide a buffer for posting of any existing transactions.  Test it thoroughly in a sandbox environment, of course.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,883 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,569 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans