Dynamics Financial Reporting

All about financial reporting and consolidations for Microsoft Dynamics ERPs

Why would I use Main Account in a Reporting Tree?

Why would I use Main Account in a Reporting Tree?

Rate This
  • Comments 3

It’s easy to get caught up in the more typical Management Reporter reports and not think about the variety of reports that you can create with Management Reporter to look at your business from different angles.

With the dimension-based approach in Management Reporter, you can easily create many different reports you maybe haven’t thought about. One example is the ability to use the Main or Natural Account as the basis for a Reporting Tree Definition. This allows you to then create a report to analyze General Ledger balances in a variety of ways.

Let’s say that you want to look at account balances by department. First, set up a reporting tree using the Main Account as the dimension. You can use just one account, or a group of accounts, similar to what you would do when creating a Row Definition.

Here’s an example where we’ve set up an “Expense Snapshot” with the various expense accounts listed in the tree.

Then design the report using your other dimensions in the rows and columns, based upon how you ant to layout your repart. In this example, the Department dimension is used for all the report rows and the Cost Center dimension is used for each column.

Let’s take a look at how this report look once it’s generated.

At the summary level, you can see the total of all expenses by department and cost center.

Then, using the reporting tree, you can look at various categories of expenses by department and cost center. For example, here is the Advertising expense.

Or, navigate the tree to look at Office expenses.

Leave a Comment
  • Please add 8 and 3 and type the answer here:
  • Post
  • Char,

    This is a great example.  Thank you for posting it.

  • Really nice post... Great example....

    I have one small doubts... When i use the function "Insert Reporting Unit from Dimension" there is option for split segment... can you explain me how it works or just a small introduction on it...

    Thanks

  • We will work in a blog post about split segments. In the meantime, check the online help for Management Reporter.

Page 1 of 1 (3 items)