Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Account and financial ...
Finance | Project Operations, Human Resources, ...
Suggested answer

Account and financial dimension details - How does it find segment and value for old account structure?

(0) ShareShare
ReportReport
Posted on by Mike C. 5

I would like to understand how the "Account and financial dimension details" form (pop-up) gets the segment,  name and value for an account no longer associated with the displayed structure. Below you can see account 20126 was used at a time when it had the structure below. Presently the account was moved to a different structure, yet this control still knows how to get the original structure.

pastedimage1600117846488v1.png

My ultimate goal is to get this data: segments,  names and values using SQL, but ran into a snag here with "old" account structures.
I believe if I can drill into how this control pulls this data, I can port it over to SQL.

Thanks for any help and direction!!

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Account and financial dimension details - How does it find segment and value for old account structure?

    Good morning Mike C.,

    Do you need any other information / help from the community or can we get this thread closed by verifying the answers?

    Many thanks and best regards,

    Ludwig

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Account and financial dimension details - How does it find segment and value for old account structure?

    Good morning Mike C,

    Have you found what you were looking for or do you need any other help / information from the community?

    Best regards,

    Ludwig

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Account and financial dimension details - How does it find segment and value for old account structure?

    Hi Mike C,

    At the end of the following page, you can find a MS whitepaper with some technical details on this.

    docs.microsoft.com/.../what-s-new-financial-dimensions-framework

    Some other tips and tricks can be found here:

    dynamicsaxworld.wordpress.com/.../

    Best regards,

    Ludwig

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Account and financial dimension details - How does it find segment and value for old account structure?

    Hi Mike,

    The entire combination is stored in DimensionAttributeVaueCombination table. The field DisplayValue stores the account plus the dimensions. You can query this table for all the segments

    Is this what you are looking for?

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans