Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Practical limit on fin...
Finance forum

Practical limit on financial dimensions from a performance perspective

Posted on by 4,014 Super User 2024 Season 2

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

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,014 Super User 2024 Season 2 on at
    RE: Practical limit on financial dimensions from a performance perspective

    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  

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Practical limit on financial dimensions from a performance perspective

    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

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Practical limit on financial dimensions from a performance perspective

    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.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,807 Super User 2024 Season 2 on at
    RE: Practical limit on financial dimensions from a performance perspective

    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.

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

News and Announcements

Give Back to the Community this Month

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,807 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,133 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans