Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL forum / Management Reporter 2012
Microsoft Dynamics SL forum
Suggested answer

Management Reporter 2012

(0) ShareShare
ReportReport
Posted on by Tom R. B. 55

I am trying to understand the difference between Units, as defined in the Reporting Tree Definitions screen, within the dimension column that relates a Unit to a Dynamics SL range of accounts and subaccounts, AND the "Link to Financial Dimensions" column within the Row Definitions screen.  How do those two areas of Management Reporter interact, and which one is key to defining the range of account and subaccount numbers to draw data from when the report is refreshed?  Thanks for any help offered.

  • Butler_B Profile Picture
    Butler_B 5 on at
    RE: Management Reporter 2012

    Thanks for the information, and thanks for the clearing difference between this two targetpayandbenefits

  • John_Joyce Profile Picture
    John_Joyce 1,040 on at
    RE: Management Reporter 2012

    Yes, subaccounts can indeed be linked in the Row Definition and Reporting Tree. Linking to the Subaccount in both the Row and the Tree can often be tricky, as the risk of duplicated data becomes very high.

    John

  • Tom R. B. Profile Picture
    Tom R. B. 55 on at
    RE: Management Reporter 2012

    Thanks John.  The report I am looking at as an example, uses the Unit concept of the Reporting Tree to define subaccount linkages, but in that same report, I am also seeing the Link to Financial Dimensions within the Row Definition section used to define account linkage, and in some case subaccount linkage.  So I guess my example shows me two different ways to define the linkage of subaccounts to the MR report format.  That was confusing to me.  I just wanted to be clear that my thought of having two different methods of defining subaccount linkage was valid.  Is my thinking correct?

  • Suggested answer
    John_Joyce Profile Picture
    John_Joyce 1,040 on at
    RE: Management Reporter 2012

    Hi Tom, in a simple report format, the Row Definition would be used to report on your Natural Chart of Accounts,. Typically, the Link to Financial Dimensions" in the Row Definition would be used to link to the GL Account Number(s) for that particular Row.

    The Reporting Tree would be "typically" used used to report by Company and/or Subaccount. Let's say you have 3 companies. The Tree would be used to list each company as a separate "Unit", with no specific Financial Dimensions (thus, it will report on the entire company as a whole).

    Or, let's say you have 1 company with 5 subaccounts. You could have report for each Subaccount. Each one would be a "Unit" in the Tree, and you would use the Financial Dimensions column in the Tree to specify the Subaccount segments for each of the 5 Units.

    Hope this helps.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans