Skip to main content

Notifications

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

How to get an overview of available financial dimension values for each legal entity

Posted on by 22,300 Most Valuable Professional

Hello,

We need a help from you.

We have a financial dimension called 'BU' (Business Unit), it has loads of values, and these values are depends on the legal entity overrides and can be used according to the setup for legal entities.

However, our budgeting team wants what are the BU is applicable for which Legal entity (note- we have around 20 LEs), and not all the BU is setup with overrides, hence where those are not setup with overrides, those BU should be applicable for LEs.

My question, is there any way or any data entity we have, which can tell us which BU (fin dim values) are available for which LEs?

Its hard to determine from the overrides package, because existing setup of overrides of BUs works, however those are not setup, we need to work manually.

Regards,

Ramit

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,240 Super User 2024 Season 2 on at
    RE: How to get an overview of available financial dimension values for each legal entity

    Hi Ramit,

    When I read your question, I think to understand that you need an overview per legal entity which BUs are allowed. Some are restricted and some are valid for all legal entities. Is this correct?

    If so, you need to create a customization to get this report or export. The standard application is catering for a validation on postings only. Your challenge would be creating a list where in fact there is a "not exists" of suspended business unit per legal entity. Probably, you need to create a (temporary) table to store the exploded results of which business units are valid per legal entity. If it would be a persistent table, you need to ensure this table would be updated accordingly to changes done in the BU setup.

  • SouravDam Profile Picture
    SouravDam 11,721 on at
    RE: How to get an overview of available financial dimension values for each legal entity

    Hello Ramit Paul,

    Have you checked what Ludwig suggested on this?

    Best regards,
    Sourav Dam

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: How to get an overview of available financial dimension values for each legal entity

    Hello Ramit Paul,

    There is the MainAccountLegalEntityOverride entity that you can use to specify fixed findims on a company by company level.

    Have you tried extracting the data by making use of this entity?

    Best regards,

    Ludwig

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans