Home » Listing Details
Top Websites
  1. Dynamics GP Help
    Over 6300 resources listed.
  2. Mark Polino's DynamicAccounting.net
    Over 5100 resources listed.
  3. Rose Business Solutions Blog New
    Over 2200 resources listed.
  4. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 1100 resources listed.
  5. Mariano Gomez at The Dynamics GP Blogster
    Over 1000 resources listed.
  6. Microsoft Dynamics Partner Community Blog
    Over 900 resources listed.
  7. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 700 resources listed.
  8. Mohammad Daoud's Dynamics GP Blog
    Over 600 resources listed.
  9. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 500 resources listed.
  10. Inside Microsoft Dynamics GP Official Blog
    Over 500 resources listed.
  11. eOne Business Solutions Blog
    Over 400 resources listed.
  12. About Dynamics, Development and Life
    Over 300 resources listed.
  13. Frank Hamelly at GP2theMax
    Over 300 resources listed.
  14. Dynamics CPM
    Over 300 resources listed.
  15. BKD Dynamics GP Insights Blog
    Over 200 resources listed.
  16. Leslie Vail at Dynamics Confessor Blogspot
    Over 200 resources listed.
  17. Victoria Yudin's Dynamics GP Website
    Over 200 resources listed.
    Victoria Yudin
  18. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  19. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  20. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  21. US Dynamics GP Field Team Blog
    Over 100 resources listed.
  22. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  23. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  24. Dynamics Small Business
    Over 100 resources listed.
  25. Belinda, The GP CSI
    Over 100 resources listed.

Title:Excel Report-o-rama
Description:I recognize that much of what I am about to say may be common knowledge to many of you out there. But as my story below outlines, sometimes we all need a little continued reinforcement :)

There are always underutilized features in new releases, but I think that Excel Reports has to top the list in Dynamics GP 10.0. I deploy them and train on them, but haven't found clients adopting them as I thought they would. Little did I know, I just had to be patient.

I remember when I was first learning Great Plains, and I would routinely look for a report whenever someone asked me for information. My coworker would constantly remind me that I could look in Smartlist, too, and that maybe it would have the information that was needed. So, eventually, I learned to adjust my thinking. So now when someone asks for information, I tend to look at Smartlist first, then Reports, and then the myriad of tools available to develop custom reports. I think a lot of users go through the same process of adjusting their thinking, and need to be reminded of the new functionality when the opportunity arises for them to practically apply it.

Excel Reports is a great example of this. Just in the past two weeks, I have had more than a couple situations arise where Excel Reports were the answer. It just took the reminder that they were there. We didn't have to build something custom, worry about licensing and training, set up a data connection ourselves, or use a static Smartlist.

And, here is the other bonus of Excel Reports...views. As the basis of Excel Reports, there are a great many views available (like AccountTransactions) which can be used for SQL reports as well. So, now I have another tool to add to my toolbox. Why reinvent the wheel? Just today I was able to leverage an existing view, and save the client time and money.

Same can be said of security, with the security roles that are created you can control access to the views for SQL reports as well as the Excel Reports. Because, remember, the Excel Reports can be accessed and refreshed by non-Dynamics users as well.

Here is an excellent FAQ on Excel Reports. Include in the FAQ is a link to the SQL security roles that are created, and how they map to the views and excel reports.

Happy weekend everyone, today is my Friday! :)
Category:OFFICE INTEGRATION: Excel with GP
Link Owner:
Date Added:June 17, 2010 06:15:06 PM
Number Hits:6
RatingsAverage rating: (0 votes)

No Reviews Yet.


Thank you for your support for GPWindow. It helps us cover part of the hosting costs for GPWindow.