Announcements
I know this is depends on a lot of variables, but does anyone know what the practical limit on the number of dimensions in an account structure is? Client has a total of 14 dimensions, of which 10 could be used with the Main account in one account structure. The accounts in this structure will have a significant general journal transaction volume (10's of thousands) at the end of each month and quarter. Is this transaction volume, considering integration and posting, inquiry and reporting, enough to bring the system to its knees if each transaction has 10 dimensions on it? This is the most recent version of D365F&O.
Thanks, Frank
Thank you all for the responses. It sounds like we might be in uncharted territory with this project. I forgot to mention in my initial post that the transaction volume is coming from an integration and that the majority of transactions will be general journals. The Account structure rules are limited, basically dictating which dimensions are required and which are not. We'll find out during integration testing if any performance issues arise. I'll update this thread with our findings at that time. Thanks again, Frank
Hello Frank,
So far, I have not experienced performance issues. Yet, we do not have a single customer with more than 10 FinDims. I think what might be a problem is not performance per se but the standard reports and inquiry forms that cannot display more than 10 FinDims. Meaning you have to find a way how users can actually analyze their data.
Best regards,
Ludwig
If you increase a lot of condition in the accounts structure and also have a lot of accounting rules then the system might take time in evaluating the allowable criteria during posting.
While technically a number of financial dimensions could be added and used, emphasis should be in consolidating and keeping the count to a manageable one.
Hi Frank,
We do have a customer with about 9 dimensions. There are different account structures for several combinations of dimensions to be used at posting. This customer has retail transactions and also journals end of the month with more than 10000 lines. Until now, we didn't encounter performance issues due to the number of dimensions and values. I do think compared to your scenario, this customer would have a bit less transactions each month.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,807 Super User 2024 Season 2
Martin Dráb 229,133 Most Valuable Professional
nmaenpaa 101,154