D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Management Reporter and unlinking main accounts from main account categories

Jump to Best Answer
  • 1.  Management Reporter and unlinking main accounts from main account categories

    SILVER CONTRIBUTOR
    Posted Dec 18, 2020 05:29 PM

    We have a report in Management Reporter that has a row definition in which a link to Financial Dimensions uses the OTHERINC main account category. This main account category is linked to 4 main accounts. We want to unlink two of these main accounts from OTHERINC and link them to a new different main account category for displaying elsewhere in the report. However, after unlinking the two main accounts from main account category, the balances of the two main accounts that were unlinked are still included when generating the report. I tried creating two new main account categories and linking the main accounts how we wish them to be grouped for the row definition, but neither of the new main account categories includes the balances (all zero when generating the report).

    Are there other steps to take when modifying main account categories and linked main accounts, like some type of data refresh?



    ------------------------------
    Jack Ogle
    DFW Heavy Duty
    Forth Worth TX
    ------------------------------
    Digital Acceleration Binge Day.  January 28th 2021 | 11:00 AM - 2:00 PM EST


  • 2.  RE: Management Reporter and unlinking main accounts from main account categories

    TOP CONTRIBUTOR
    Posted Dec 21, 2020 08:14 AM
    Edited by Steve Latta Dec 21, 2020 08:17 AM

    The easiest way to do it is to add additional lines to your row definition subtracting the 2 accounts individually from that row. On the row definition you want to add them to, just change the operator back to a plus and add the main accounts.

    This allows you to move accounts around on the report without having to fiddle with your account categories.



    ------------------------------
    Steve Latta
    Accountant
    Ortec, Inc.
    Easley SC
    ------------------------------

    Digital Acceleration Binge Day.  January 28th 2021 | 11:00 AM - 2:00 PM EST


  • 3.  RE: Management Reporter and unlinking main accounts from main account categories
    Best Answer

    Posted Dec 21, 2020 08:57 AM

    Yes, there is a refresh that you need to do when you create and change Main accounts and Dimensions. It is in MR.  Go to Tools then Refresh Data Mart.  You will likely see some % lower than 100 on the right.  Click in the Reset Data mart box to the right choose a reason - any will do.  Then click OK.  

    Best done in off hours when nobody is online. 



    ------------------------------
    Wendy Muar
    Lead Functional Consultant
    GraVoc; Peabody, MA
    www.gravoc.com
    ------------------------------

    Digital Acceleration Binge Day.  January 28th 2021 | 11:00 AM - 2:00 PM EST


  • 4.  RE: Management Reporter and unlinking main accounts from main account categories

    SILVER CONTRIBUTOR
    Posted Dec 21, 2020 05:05 PM

    Thanks Wendy, the data mart reset worked.



    ------------------------------
    Jack Ogle
    DFW Heavy Duty
    Forth Worth TX
    ------------------------------

    Digital Acceleration Binge Day.  January 28th 2021 | 11:00 AM - 2:00 PM EST


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