You’re offline. This is a read only version of the page.
Announcements
130
Hi all!
In D365 for Finance limit of 21 financial dimension for the accounting structure no longer exists.
Our customer preliminary decided to use 69 financial dimensions. We don't have experience of using such number of financial dimensions and we have concerns that it will work without issues. We have 2 options:
1) add all 69 financial dimensions in one active accounting structure (10 in accounting structure + 59 additional rules)
2) divide Chart of accounts into 6-7 active accounting structures and use 10 financial dimensions for each accounting structure (without additional rules).
As we understand recommendation from Microsoft is to use maximum of 10 financial dimensions, but we do not aware if this limit is set for one accounting structure or for legal entity?
Is there any differences between both approaches in terms of performance impact and database size?
Is there any differences between both approaches at all?
How it is possible to define database capacity required to generate and store transactions with 69 financial dimensions? Any recommendations?
Kind regards,
Boris
Hi Borys Bayramukov,
It's not only about DB size/capacity requirement/posting transactions/Create reporting. Andre already mentioned you couple of the issues that you will face if you will go with creating 69 dimensions. I will add one more in the list which is most critical and vital important in any organization and that is "Year End Closing" activity. If you will try to close fiscal year with 69 dimensions, the process will stuck or might take several days in performe closing which is more critical because that can cause serious issues in your Trial balance numbers. That's the reason why microsoft recomended to keep max 10 financial dimensions.
Hi Borys,
There is no white paper with best practices. There are some limitations on certain forms and reports where data is collected for a maximum number of dimensions. Not sure which exact number.
Initially, it will be pretty much OK to post and report on these transactions, but what happens if there will be millions of transactions with then also even more financial dimension set combinations?
Hi,
Microsoft Dynamics FO has default dimension up to 39, hence there should not be an issue.
However, please note- Extra dimensions means extra values and hence extra data, you should consider with Microsoft product team with your env capabilities.
Also, this should be an issue with some reports, example, vendor accounts statement, reports will clip your value because more values in one line,
I see, some maintenance issue from the change management point if view, because organizational change in group accounting can bring more changes and this will need lots of time to adjust the account structure and advanced rules.
This is a big question to your customer why they need this and how they will keep this.
Hi all!
I know that 69 dimensions is too much - this list definitely will be reviewed to reduce the number. But question is - what is targeted number?
We have made projects with 13 dimensions in 1 dimension set - and it works well.
Is there any difference between 60 and 13 active financial dimensions?
We've tested on Demo environment - there we no slow downs during posting of transactions with 50 dimensions. But we have concerns that it will not slow down when there will be a lot of transactions.
Currently, we have situation when client knows that limitation in financial dimension number does not exist and there is no restrictions to use 69 financial dimensions. Also, client not plan to use more than 10 dimensions for a single main account.
Is there a white paper from MS regarding this question?
Hi Boris,
69 financial dimensions in one legal entity is insane. What are these dimensions about? How would they like to report on this? The recommendation of 10 is related to the number of dimensions that can be used out of the box on certain reports.
But more important, how would the data entry experience look like? How many dimensions do you have at a maximum for one single main account?
I have seen an environment with over 300 dimensions, but then it was limited with only a few dimensions per legal entity.
For sure try to find out if all these dimension requirements can be solved in a different way.
Hi,
Why do you need 69 Fin Dim ?
I think this will impact on the below
1: Maintenance and change management, because if something needs change, it will require more effort
2: This will surely impact reporting such as OOB reports and MR reports
3: You need to create more Fin Dim sets for trail balance reporting.
#1
André Arnaud de Cal...
294,233
Super User 2025 Season 1
#2
Martin Dráb
232,982
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
