Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

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

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: What is the table for Legal Entity and Financial Dimension relation?

    No problem, thanks for your help anyway.

  • syed baber Profile Picture
    syed baber 11,627 on at
    RE: What is the table for Legal Entity and Financial Dimension relation?

    Hi Eros,

    Sorry I misunderstood your question. I don't know the procedure to create financial dimension from X++. I was just trying to propose you the solution to create LegalEntity financial dimension from financial dimension form and then later on you can disble it using X++.

    If you need further help, please let me know.

    Thanks,

    Baber

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: What is the table for Legal Entity and Financial Dimension relation?

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

  • syed baber Profile Picture
    syed baber 11,627 on at
    RE: What is the table for Legal Entity and Financial Dimension relation?

    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 Microsoft Employee on at
    RE: What is the table for Legal Entity and Financial Dimension relation?

    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?

  • Suggested answer
    syed baber Profile Picture
    syed baber 11,627 on at
    RE: What is the table for Legal Entity and Financial Dimension relation?

    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 Microsoft Employee on at
    RE: What is the table for Legal Entity and Financial Dimension relation?

    Thank you, I'm reading that!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: What is the table for Legal Entity and Financial Dimension relation?

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

  • Suggested answer
    syed baber Profile Picture
    syed baber 11,627 on at
    RE: What is the table for Legal Entity and Financial Dimension relation?

    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.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,996 Super User 2025 Season 1 on at
    RE: What is the table for Legal Entity and Financial Dimension relation?

    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.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,996 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,853 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans