web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / What is the table for ...
Microsoft Dynamics AX (Archived)

What is the table for Legal Entity and Financial Dimension relation?

(0) ShareShare
ReportReport
Posted on by Community Member

I need to create a new financial dimension for a legal entity using X++.

I'm creating a record in DimensionFinancialTag, but I can't find where to link a financial dimension and a legal entity. I did some research and found that MainAccountLegalEntity has a DefaultDimension field, but it's linked to DimensionAttributeValueSet that in turn seems to have no other realtion. I'm really confused on this one. Any ideas on how to create a new financial dimension for a legal entity?

EDIT: 

Not sure I'm on the right path, but so far I got this:

Ledger links to entity

GeneralJournalAccountEntry has LedgerDimension that links to DimensionAttributeValueCombination

*This post is locked for comments

I have the same question (0)
  • dekaasboer Profile Picture
    dekaasboer 1,530 on at

    I am not shure if I have understood your question correctly.

    Do you want to create a new financial dimension in a legal entity\ belonging to a legal entity?

    Or do you want to create a financial dimension of the type legal entity?

    When a dimension is set up to contain values stored in a table that target table contains the dimension values. So creating a new legal entity dimension would mean creating a new legal entity.


    This blogpost explains it better : http://meritsolutions.com/meritmatters/archives/585-Financial-Dimensions-in-Microsoft-Dynamics-AX-2012.html

  • Community Member Profile Picture
    Community Member on at

    Thank you for your answer. Could I check before creating the new financial dimension if the legal entity alread exists and then create a FD for that entity or every legal entity is already created with a FD?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,165 Super User 2026 Season 1 on at

    Hi Eros,

    You can read about the dimensions framework in the next whitepaper: go.microsoft.com/fwlink.

    It also contains code explanaition and data models.

  • Suggested answer
    syed baber Profile Picture
    syed baber 11,633 on at

    Hi Eros,

    To add a new financial dimension based on LegalEntity, you need to go to the following form,

    General Ledger -> Setup -> Financial dimensions -> Financial dimensions form. Create new financial dimension and select LegalEntity dimension name from Dimension name drop down on this form. I can't understand why you are trying to create new financial dimension using X++ code. Can you please further elaborate your requirement and the reason you are trying to create it using X++?

    Thanks,

    Baber.

  • Community Member Profile Picture
    Community Member on at

    Well, it's just a requirement. I need to create the financial dimension when a company accepts the pro forma.

  • Community Member Profile Picture
    Community Member on at

    Thank you, I'm reading that!

  • Suggested answer
    syed baber Profile Picture
    syed baber 11,633 on at

    Hi Eros,

    You can create the LegalEntity financial dimension from Financial dimensions form. You can enable/disable this financial dimension based on the condition you specified using X++ code.

    Let me know if you want to know further details related to this.

    Thanks,

    Baber.

  • Community Member Profile Picture
    Community Member on at

    Thanks Baber, but I need to know how to do that on X++. Would you know the tables I need to insert data to create the financial dimension for the legal entity?

  • syed baber Profile Picture
    syed baber 11,633 on at

    Hi Eros,

    Check my first reply on this post above. I have explained this.

    Please let me know if you have further queries.

    Thanks,

    Baber.

  • Community Member Profile Picture
    Community Member on at

    Ok, but there you only mention the GUI insertion, right? Am I mistaken? Anyway, thanks for your help.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Sagar Suman Profile Picture

Sagar Suman 2 Super User 2026 Season 1

#1
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#1
Pratik Bhosle Profile Picture

Pratik Bhosle 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans