General Ledger & Intercompany

Get Involved. Join the Conversation.

Topic

    Jim Van Tongerloo
    Account Monitor: Parent values not showingAnswered
    Topic posted November 14, 2019 by Jim Van TongerlooGold Trophy: 10,000+ Points, tagged Financials, General Ledger 
    30 Views, 2 Comments
    Title:
    Account Monitor: Parent values not showing
    Summary:
    Parent values not showing in the dropdowns in Account Monitor
    Content:

    Hi,

    We have a rather straightforward setup:

    COA 01 -> Ledger 01 -> Data Access Set 01
    COA 03 -> Ledger 03 -> Data Access Set 03
    COA 04 -> Ledger 04 -> Data Access Set 04
    COA 20/21 -> Ledger 20 & Ledger 21 -> Data Access Set 20 & Data Access Set 21

    When creating an Accounting Group in the Account Monitor for 01/03 or 04, I see all the values for the natural accounts just fine (including parent values like '6' which groups all expense accounts).

    When creating an Accounting Group for the shared COA 20/21, opening the dropdown for natural account, only the child values are there, not the parent values.

    The account hierarchy is built, active, audited and flattened, published.

    Any idea why these parent values don't show in the natural account dropdown?

    Thanks.
    Jim

    Version:
    R13 19C

    Best Comment

    David Zachar

    Hi Jim..

    If you haven't already, please try running the "Publish Chart of Accounts Dimension Members and Hierarchies" scheduled process

    Cheers

    David

    Comment

     

    • David Zachar

      Hi Jim..

      If you haven't already, please try running the "Publish Chart of Accounts Dimension Members and Hierarchies" scheduled process

      Cheers

      David

      • Jim Van Tongerloo

        Hi David,

        Awesome, this fixed it!

        The entire name of the ESS Job is longer though: Publish Chart of Account Dimension Members and Hierarchies to Balances Cubes

        Thanks for the quick response!

        Jim