D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Ledger account vs accounts structure

  • 1.  Ledger account vs accounts structure

    Posted 15 days ago
    From General ledger > Chart of accounts > Accounts > Main accounts, does someone know if we can see in which account structure a main account is part of?

    ------------------------------
    Annie Poulin
    Boa-Franc S.E.N.C.
    Saint-Georges QC
    ------------------------------
    Conference-AXUG_200x200


  • 2.  RE: Ledger account vs accounts structure

    GOLD CONTRIBUTOR
    Posted 14 days ago
    Unfortunately no, that would be very nice though.

    ------------------------------
    Ryan Sorenson
    Sunrise Technologies
    Riverton UT
    ------------------------------

    Conference-AXUG_200x200


  • 3.  RE: Ledger account vs accounts structure

    Posted 13 days ago
    Yes you can, just double click on one of the accounts, and on the Main Accounts 0 chart of accounst screen, there is a fast tab for Advanced Rules, where you can see the rules that are applied to that account.

    Thanks,

    ------------------------------
    Nobuko Lima
    Milton CAT
    Milton
    ------------------------------

    Conference-AXUG_200x200


  • 4.  RE: Ledger account vs accounts structure

    TOP CONTRIBUTOR
    Posted 11 days ago
    Nobuko, I believe the OP asked about account structures, not advanced account rules/structures.

    ------------------------------
    Zvika Rimalt
    Functional Consultant
    Vancouver BC
    ------------------------------

    Conference-AXUG_200x200


  • 5.  RE: Ledger account vs accounts structure

    Posted 14 days ago
    Edited by Andrew Russell 14 days ago
    If you have SQL access to the database it may be possible - some sample SQL below, although it may need a fair bit of tweaking to match your setup.

    Caveats:
    - This was written against AX2012 R3, but it probably works on other versions
    - Our Chart of Accounts is called "COA", and every AccountStructure starts with "COA" e.g. "COA BS Cost Centre"
    - We don't use advanced rules

    select
    ma.mainaccountid,
    dh.name
    from DIMENSIONHIERARCHY dh
    left join DIMENSIONHIERARCHYLEVEL dhl on dhl.DIMENSIONHIERARCHY = dh.RECID
    left join DIMENSIONCONSTRAINTNODE dcn on dcn.DIMENSIONHIERARCHYLEVEL = dhl.RECID
    left join DIMENSIONCONSTRAINTNODECRITERIA dcnc on dcnc.DIMENSIONCONSTRAINTNODE = dcn.RECID
    left join
    (
    select ma.mainaccountid, ma.name
    from MAINACCOUNT ma
    left join LedgerChartOfAccounts lcoa on lcoa.RECID = ma.LEDGERCHARTOFACCOUNTS
    where lcoa.name = 'COA'
    ) ma on ma.MAINACCOUNTID >= dcnc.RANGEFROM and ma.MAINACCOUNTID <= dcnc.RANGETO
    where dh.name like 'COA%'
    and level_ = 1
    and ma.mainaccountid is not null

    ------------------------------
    Andrew Russell
    Direct Wines
    Reading, UK
    ------------------------------

    Conference-AXUG_200x200


  • 6.  RE: Ledger account vs accounts structure

    Posted 13 days ago
    One way to at least see all the accounts without having to open each account structure is to export the Account structure allowed vales entity  from Data management.

    ACCOUNTSTRUCTURE STATUS SEGMENTCRITERIA01 SEGMENTCRITERIA02 SEGMENTCRITERIA03
    Main Active 11101..12900;14100..14150;14250..15100;15200;15300..15700;17100..18200;18300
    Main Active 18400..21200;21300..22340;23370;23390..23450;23500..23540;23560..23590;24100..25200
    Main Active 26100..26200;26400..30400;61110;99999
    Main-Cust-CustG Active 23000..23210;62340..62350;62370..62380 * *
    Main-Cust-CustG-ItemG Active 40400;62100..62140;63110..63120 * *
    Main-Cust-CustG-Item-ItemG Active 23250..23260;40300;41100..41600 * *
    Main-ItemG Active 23550;40500..40700;50400;64010..64130 *
    Main-Item-ItemG Active 23280;63200..63300 * *
    Main-Site Active 14200;15150;15250;18250;18350;21250;23380 *
    Main-Site Active 23470..23490;23600..23610;25300;26300 *
    Main-Site-Cust-CustG Active 62310..62330;62360 * *
    Main-Site-Cust-CustG-Item-ItemG Active 40100..40200;50100..50300 * *
    Main-Site-Dept Active 16100..16210;16510..16610;61389;64510;64530..73550;74110..90350 * *
    Main-Site-Dept-Cust-CustG-Item-ItemG Active 64520 "";* "";*
    Main-Site-Dept-Cust-CustG-Item-ItemG Active 73600 * *
    Main-Site-ItemG Active 61400..61550;62150..62190 * *
    Main-Site-Item-ItemG Active 13100..13450;61101..61108;61197..61299;61399;64210..64350 * *
    Main-Site-Proj Active 16220 * *


    ------------------------------
    Ken Lasseter
    MCA Connect
    Greenwood Village CO
    ------------------------------

    Conference-AXUG_200x200


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