Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

GP Reports

(0) ShareShare
ReportReport
Posted on by Microsoft Employee
We haven't bought GP yet so I am still learning my way around with the sample data, so this might be a noob question. I know that GP comes with hundreds of stock reports. However, what they seem to be are print outs. In my experience as a report writer for several companies, I would say 80% or higher of report requests are for Excel, so that the user can sort and filter the data. I haven't seen any reports yet in GP that are data sheets in Excel format. Am I wrong in my assumption? Thanks

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Re: GP Reports

    Hi!

    In addition to SmartList mentioned here, GP has a couple of hundred reports already written in Excel that are fully integrated with GP and linked to the database so they are 'refreshable' (you are pulling live data). You have to 'deploy' them so you most likely do not have them installed in the sample company. Go to the Administration area page in the Setup Content Pane. Under the System menu go down to Reporting Tools Setup and select it. When the Reporting Tools Setup window opens hit F1 and read the help screens about the Data Connections and Reports Library tab. The reports work beautifully with Excel 2007..

    You will also see in this window that there is an SSRS report setup. There are also pre-built SSRS reports that come with Dynamics, but that is a different setup from the Excel Reports.

    Also, version 10 has something called 'Navigation Lists'. Navigation Lists are available from the Navigation Pane. If you hit the Financial Series button on the Navigation Pane, several items will be listed at the top. 'Financial' is first, this brings up the Financial Area Page. The second item in the Navigation Pane is 'Accounts'. Select Accounts and the Accounts Navigation List will open. Navigation Lists have tons of other functionality, but you can also select items (all items or specific items) and export it to Excel. To export to Excel, select a few items and click on the Go To button in the upper RH corner of the toolbar. A menu will drop down, one of the options is 'Send to Excel'. You can also put an unlimited number of filters on these lists to zoom in on just the data you want.

    While the old canned reports are mostly text reports, you can use the built-in Report Writer to make them 'Excel friendly'. Kind of a pain, but sometimes easier because of the table relationships.

    Whew, there are TONS of reporting options available, and the list continues to grow in GP 2010 (the next version). So, take a closer look and I think you will be very pleased at what you find.

    Sorry for the run-on reply, but I would hate for you to turn away from GP without exploring all of the options.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: GP Reports

    You can also of course customise the reports themselves to lay them out better for Excel

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: GP Reports
    I figured I could make custom reports with GP. I'm just a bit disappointed that all of these hundreds of reports aren't Excel friendly.
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: GP Reports

    Look at Smartlists and/or customising your own with Crystal Reports or SQL Reporting Services.

    Stu

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…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans