More Information
  • Explore major reporting challenges faced by report writers
  • Understand how data is stored in Microsoft Dynamics GP
  • Utilize Excel and SmartLists Builders for basic GP reporting needs
  • Take advantage of the new Word Template functionality in Report Writer
  • Deploy and modify Dynamics GP SQL Reporting Services report library
  • Customize Analysis Cubes for Excel for improved ad hoc data analysis
  • Slice and dice Dynamics GP data with Excel Pivot Tables and Pivot Formulas
  • Design and create various building blocks for Management Reporter
  • Explore advanced concepts for delivering professional-quality financial statements
  • Identify the right tool for any Dynamics GP reporting need

"Resources such as the book you now hold in your hand are critical to taking the extra step in uncovering the trends locked deep within your data. Not only will this book offer insight into the many reporting tools currently available for GP, it will also offer a unique perspective on how each reporting tool can be used to meet specific challenges faced by your organization"

- Errol Schoenfish, a member of the Microsoft Dynamics community for over 24 years

Microsoft Dynamics GP 2010 is a sophisticated Enterprise Resource Planning (ERP) system with a multitude of features and options. Microsoft Dynamics GP enables you to create and manage a variety of reports that help small and mid-size businesses effectively manage their financial and operational data.

This book will show you how to create and manage reports, know what tools to use and when, how to use them and where to find the data based on how it's being entered into the system with Dynamics GP.

This book will empower you with the tools and reports necessary to use Dynamics GP data in making key business decisions. The book addresses the many challenges and frustrations a company may face when preparing to build new reports. Then it moves on to explain how to find your data in the GP system and company databases. The book then dives deep into topics such as SmartLists, SL Builder and Excel Report Builder, Report Writer, SSRS Report Library, and Analysis Cubes Design and Management Reporter amongst others. With this knowledge in hand, you will be capable of selecting the most effective tool for the current reporting environment.

  • Identify the major reporting challenges facing your organization and select the most effective reporting tool to meet those challenges
  • Empower users from top to bottom in your organization to create their own reports
  • Go beyond basic reporting by providing true business intelligence for your organization
  • Discover how to use reporting tools to mine and analyze your Dynamics GP data for maximum competitive advantage
  • Explore new reporting features found only in Dynamics GP 2010
  • Employ real-life step-by-step examples in this part tutorial, part reference guide
  • A foreword by Errol Schoenfish, a member of the Microsoft Dynamics community for over 24 years
Page Count 360
Course Length 10 hours 48 minutes
ISBN 9781849682183
Date Of Publication 25 Apr 2011


Christopher Liley

Chris Liley is a Principal Consultant with Microsoft Partner I.B.I.S., Norcross, GA and a Microsoft Certified Information Technology Professional for Dynamics GP.  He is a graduate of Georgia State University with a B.B.A in Accounting.  Chris has worked with Dynamics GP since 2001.

Chris’ experience ranges from financial analysis, software implementations, data conversions, integrations to designing and developing customizations in both the functional and technical area of consulting for Dynamics GP.  Chris also has extensive experience designing Business Intelligence solutions.

David Duncan

David Duncan has been a consultant and business analyst for over five years. He has driven organizational success through well-defined reporting solutions that provide valuable and insightful information to key stakeholders. He is the co-author of Microsoft Dynamics GP 2010 Reporting and has also served as a technical reviewer for Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013, both by Packt Publishing. David, who holds several certifications for Microsoft Dynamics GP and SQL Server, has extensive experience in designing and providing business intelligence and reporting tools for organizations that use Dynamics GP and many other Microsoft SQL Server-based applications. In his current position as a business analyst, David works with end users at all levels of his organization to provide them with reporting solutions to meet their needs. David enjoys sharing insights gained from these solutions, and he is even happier when he can share these insights using Excel PivotTable and Excel Power Pivot functionality! David holds a degree from Clemson University. He resides in Rocky Mount, N.C. with his wife, Mary Kathleen, and their newborn daughter, Mary Eliza.