Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Integrating GP Reports and Management Reporter - publish to Web

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi Everyone,

New user to this site! Thanks to anyone that is able to assist.

My query is in relation to month end reporting processes - using both Microsoft GP reports and Management Reporter.

Below is the background for your understanding:

OUR CURRENT PROCESS

  • We have approximately 27 people that are responsible for budgets
  • Each month I download into Excel:
  1. A transaction listing per activity – using a detailed trial balance from GP (I change the fields and have to download each activity separately)
  2. An actual by month summary – downloaded from Management Reporter
  3. A P&L – downloaded from Management Reporter
  • I then manually combine each of the 3 reports into 1 Excel file, and email to the appropriate person 

WHAT I’D LIKE TO BE ABLE TO DO

  • Each budget manager is given a log on to be able to click into a web browser and view all these reports, at any time, with live data
  • There are security levels, so each budget manager can only view their assigned reports

There is a “drill down” capability to go from a high level P&L down to the transactions.

QUESTION: Does anyone have a similar reporting process that can share their solution?

Many thanks!

*This post is locked for comments

  • mm123 Profile Picture
    mm123 2,535 on at
    RE: Integrating GP Reports and Management Reporter - publish to Web

    Brammer,

    We have received a similar web P & L  & Budgeting reporting request from our customer, currently planning to go with custom web reporting portal solution to address this. FYI- Already we have developed & successfully implemented  a similar financial dashboard web portal reporting solution for other items like - Sales, AR, Income statements, invoice & orders. If you are interested please drop an email to learn, we could help you for this automated reporting solution. Please see the below image.

    Regards,

    sam

    samr (at) expsoltech.com

    www.expsoltech.com

    Expert_5F00_Board_2D00_1.jpg 

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,356 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans