Finance | Project Operations, Human Resources, ...

Limitation of financial dimensions quantity

(0) Share

Report

Posted on by Borys Bayramukov

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

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,037 Super User 2025 Season 2 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Borys Bayramukov 130 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,037 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees on at

Like (0)

Report

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.

Was this reply helpful? Yes No