Skip to main content
Dynamics 365 Community / Forums / Microsoft Dynamics GP forum / Management Reporter: R...
Microsoft Dynamics GP forum
Suggested answer

Management Reporter: Range of Accounts Show in Detail

editSubscribe (0) ShareShare
ReportReport
Posted on by RJarrell 277

Hi, I am not sure if this is possible, just wanted to get some ideas.

We have a few clients that have struggled with keeping their MR up to date as they enter new accounts. 

For reports that pull a summary amount, this isn't a problem. Something like Cash will be a line that pulls in account 1000-1999.

But on a detail report, they will have cash and underneath it they will list each account out individually. They struggle to keep these updated as they are adding new accounts as they have several different types of reports and how they like to reflect the data, so each one has to be individually updated if it shows the accounts by line. Is there any way to have a line that pulls in a range of account like 1000-1999 but breaks it down in the report so that any account that appears shows as an individual line. I know that you can click on the cash line and see the detail but they want a full detail report, not to have to click into each line.

Just seeing if there is any way to make this easier on them. 

Categories:
Management Reporter
Reporting and BI
Attachments
  • jenny s Profile Picture
    jenny s 2 on at
    Management Reporter: Range of Accounts Show in Detail
    MR viewer can't. But when Export to Excel, choose Report type - Account Detail.  In Excel, it will show as you expected. 
  • RJarrell Profile Picture
    RJarrell 277 on at
    RE: Management Reporter: Range of Accounts Show in Detail

    Thanks for your responses. I have some ideas to go back tot our clients with. I appreciate your input!

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 2,965 on at
    RE: Management Reporter: Range of Accounts Show in Detail

    For our clients we encourage them to include updating rows as part of their new account procedure.  They have a matrix where if it is a Balance Sheet account they update their Balance Sheet, Cash Flow, and Trial Balance rows.  If it is a P&L account, they update their P&L and Trial Balance rows.  There are usually a subset of special accounts that are handled differently based on Cash Flow or other reporting.

    As a double-check, at month-end we recommend they include reviewing new accounts as part of their close.  SmartList > Financial > Accounts with a favorite that is sorted in descending order based on Created Date is very useful as they know they only have to review the accounts created that month.

    What we do NOT recommend is waiting until an account has posting activity to deal with it.  (We often see months separating when an account is created and when it is first used.  Those are the hardest to track down.)

    Finally, we build a reconciliation report in MR so that they have all their control totals (Total Assets, Total Liability, Total Equity, P&L by Department, etc.) that shows the Balance Sheet in balance and tied out to all departmental control totals.  They use it to verify each and every report ties to that overall reconciliation report.

    For a few clients who only use the Trial Balance reports for the auditors at year-end, we just build them a new row each year where we automatically add all accounts through the built-in MR Edit > Add feature in the row.  Copying/Pasting between MR and Excel works great for adding needed subtotals if you want to get fancy.


    Side note:  There is a very funky default row titled Trial Balance - Default that has a single line (+Account = [*]) that can be used to view the detail (sans any totals).  When you the top-level report appears useless but if you drill into it you'll see the account-level report is quite nice. 

  • Greg Byer Profile Picture
    Greg Byer 2,586 on at
    RE: Management Reporter: Range of Accounts Show in Detail

    There's not a way to do this.  If they want a line for each account, they'd need to manually add it to the row definition.  You could do a range, like you mentioned, or use a wildcard but that would summarize the data on that line.  They'd then need to drill down to see the account detail.  If they want one line for each account, they'd have to manually add it.  There's not a way for MR to automatically do that.  

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Demystifying Copilot with Sundar Raghavan

Sundar explains how Copilot for Service is meant to function separately...

Business Process Guidance Badges and New…

The Microsoft Success by Design is the framework for implementing Dynamics 365…

more Community News

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,266 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,978 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans