D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

AX2012- Viewing Main Account Structures

Jump to Best Answer
  • 1.  AX2012- Viewing Main Account Structures

    Posted Aug 15, 2019 08:59 AM
    Hi,

    Is there a table that I can connect to with the excel add-in to pull our main account structures? I am hoping to see all the financial dimensions that are linked to each structure.

    Thanks!

    ------------------------------
    Ryan Anderson

    ------------------------------
    Conference-AXUG_200x200


  • 2.  RE: AX2012- Viewing Main Account Structures
    Best Answer

    TOP CONTRIBUTOR
    Posted Aug 15, 2019 09:06 AM
    Ryan,

    I was actually just tasked with doing something similar for one of our clients, unfortunately this data is not stored in just one table but multiple tables that include:

    LedgerStructure
    DimensionHierarchy
    DimensionConstraintTree
    DimensionAttribute
    DimensionAttributeValue
    DimensionAttrituteValueSet

    So while you can get there, you have to determine the SQL join's required between these tables to get the desired result.

    ------------------------------
    Alex Meyer
    Director of Dynamics AX/365 for Finance & Operations Development
    Fastpath
    Des Moines, IA
    ------------------------------

    Conference-AXUG_200x200


  • 3.  RE: AX2012- Viewing Main Account Structures

    Posted Aug 15, 2019 09:12 AM
    Edited by Ryan Anderson Aug 15, 2019 10:38 AM
    Thanks Alex! That was what I was afraid of. One more question, do you know of any documentation around best practices for setting up account structures in AX2012 or D365?

    ------------------------------
    Ryan Anderson

    ------------------------------

    Conference-AXUG_200x200


  • 4.  RE: AX2012- Viewing Main Account Structures

    TOP CONTRIBUTOR
    Posted Aug 15, 2019 09:26 AM
    Ryan,

    Here's what I found:

    https://docs.microsoft.com/en-us/dynamics365/unified-operations/financials/general-ledger/configure-account-structures

    https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/about-the-configure-account-structures-form

    https://www.youtube.com/watch?v=Yv0NeDgiO1U

    https://www.youtube.com/watch?v=uJVFJmziQ8M

    https://www.youtube.com/watch?v=rcFZks1dFI8

    ------------------------------
    Alex Meyer
    Director of Dynamics AX/365 for Finance & Operations Development
    Fastpath
    Des Moines, IA
    ------------------------------

    Conference-AXUG_200x200


  • 5.  RE: AX2012- Viewing Main Account Structures

    Posted Aug 15, 2019 09:38 AM
    Awesome! Thanks for your help Alex!

    ------------------------------
    Ryan Anderson
    System Support Specialist
    DayGlo Color Corp.
    Cleveland OH
    ------------------------------

    Conference-AXUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role