Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Management Reporter: R...
Finance | Project Operations, Human Resources, ...
Suggested answer

Management Reporter: Range of Accounts Show in Detail

(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:
Microsoft Dynamics GP
  • 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 3,141 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.  

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans