Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Microsoft Dynamics GP 2010 Reporting
  • Table Of Contents Toc
  • Feedback & Rating feedback
Microsoft Dynamics GP 2010 Reporting

Microsoft Dynamics GP 2010 Reporting

4.5 (6)
close
close
Microsoft Dynamics GP 2010 Reporting

Microsoft Dynamics GP 2010 Reporting

4.5 (6)

Overview of this book

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.
Table of Contents (21 chapters)
close
close
Microsoft Dynamics GP 2010 Reporting
Credits
Foreword
About the Authors
Acknowledgement
Acknowledgement
About the Reviewers
www.PacktPub.com
Preface
2
Index

Chapter 7. Utilizing Analysis Cubes for Excel for Dynamic Reporting

We are in the home stretch with only two reporting tools left in our toolset and we have saved the best ones for last! Until now, we have covered reporting tools that allow us to extract data sets from Dynamics GP or write reports by accessing the Dynamics GP data directly. In all of these tools, any type of summation or grouping that needed to be done, we had to create ourselves and know what tables to join together and where to find this data. In the last chapter, we learned that Analysis Cubes for Excel is an out-of-the-box data warehouse that does all of this summation and grouping for us.

Now that we have learned the backbone of the Analysis Cubes for Excel product, we will explore connecting to this data and creating reports with every accountant's favorite tool, Microsoft Excel.

In this chapter, we'll discuss some of the following topics:

  • Creating a connection to individual cubes via Microsoft Excel

  • Exploring the Excel...

Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Microsoft Dynamics GP 2010 Reporting
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon