Microsoft Dynamics GP 2010 Reporting


There is a newer version of this book available - Microsoft Dynamics GP 2013 Reporting - Second Edition
Microsoft Dynamics GP 2010 Reporting
eBook: $35.99
Formats: PDF, PacktLib, ePub and Mobi formats
$30.59
save 15%!
Print + free eBook + free PacktLib access to the book: $95.98    Print cover: $59.99
$59.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Reviews
Support
Sample Chapters
  • 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

Book Details

Language : English
Paperback : 360 pages [ 235mm x 191mm ]
Release Date : April 2011
ISBN : 1849682186
ISBN 13 : 9781849682183
Author(s) : Christopher Liley , David Duncan
Topics and Technologies : All Books, Enterprise Products and Platforms, Microsoft Dynamics, Enterprise, Microsoft

Table of Contents

Preface
Chapter 1: Meeting the Reporting Challenge
Chapter 2: Where Is My Data and How Do I Get to It?
Chapter 3: Working with the Builders: SmartList and Excel Reports
Chapter 4: Report Writer
Chapter 5: SSRS Report Library
Chapter 6: Designing Your Analysis Cubes for Excel Environment
Chapter 7: Utilizing Analysis Cubes for Excel for Dynamic Reporting
Chapter 8: Designing Financial Reports in Management Reporter
Chapter 9: Viewing Financial Reports in Management Reporter
Chapter 10: Bringing it all Together
Appendix: Comparing the Dynamics GP Reporting Tools Against Different Reporting Challenges
Index
  • Chapter 1: Meeting the Reporting Challenge
    • Trends in reporting
      • Increased flexibility
      • Reporting through all levels of an organization
      • Increased access to report generation process
    • Challenges in developing and writing reports
      • Intended audience
      • Data sources
      • Latency
      • Formatting and presentation
      • Ad hoc queries versus traditional reports
      • Security
      • Network access and general IT infrastructure
      • Developer resources
    • Summary
    • Chapter 2: Where Is My Data and How Do I Get to It?
      • DYNAMICS database versus company database
        • What is the DYNAMICS database?
        • Company database
      • Dynamics GP table naming/numbering conventions
        • Tables versus table groups
        • Physical table naming/numbering conventions
          • Alpha code
          • Table type
          • Sequence
          • Variant
        • Locating Dynamics GP data using the Resource Descriptions windows
        • Tables
        • Fields
        • Windows
      • Table Import
      • Accessing data at the table level using SQL Management Studio
      • Locating Dynamics GP data with additional tools
        • Dynamics GP 2010 Software Development Kit
          • Downloading the Software Development Kit
          • Using the Software Development Kit
        • Support Debugging Tool
          • Downloading the Support Debugging Tool
          • Using the Support Debugging Tool
      • Summary
      • Chapter 3: Working with the Builders: SmartList and Excel Reports
        • Satisfying basic reporting needs with canned SmartLists
          • Structure of SmartList
          • Basic SmartList tools
            • Narrowing our result list with search criteria
            • Adding new columns
            • Changing the number of records returned
            • Achieving faster export to Excel with a simple dex.ini switch
        • Extending SmartList data to Excel by deploying Excel reports
          • Deploying Excel reports
          • Maintaining security for Excel reports
            • Shared network folder permissions
            • Database level permissions
          • Accessing and using Excel Reports
            • Connecting to Excel Reports via Windows Explorer
            • Connecting to Excel Reports via GP 2010
        • Creating and publishing new SmartLists by using SmartList Builder
          • Understanding the SmartList Builder window
          • Creating a new SmartList via SmartList Builder
        • Creating and publishing new Excel Report formats using Excel Report Builder
          • Understanding the Excel Reports Builder window
          • Creating a new Excel Report via Excel Reports Builder
        • Additional tips and tricks for using the Builders
        • Summary
        • Chapter 4: Report Writer
          • Understanding the reports dictionaries and how Dynamics GP treats original versus modified reports
            • Storing Report Writer reports
              • Storing reports dictionaries locally
              • Storing reports dictionaries on a network share
            • Accessing Report Writer reports
              • Setting the Dynamics GP launch file
              • Setting security to custom/modified reports
          • Opening and navigating the Report Writer windows
            • Setting security permissions for using Report Writer
            • Opening Report Writer
            • Report Writer Resource windows
              • Fields
              • Data types
              • Formats
              • Pictures
              • Strings
            • Report Modification windows
              • Report Definition
              • Report Table Relationships
              • Sorting Definition
              • Report Restrictions
              • Layout
          • Modifying all reports in the application by using global modifications
            • Data types
            • Formats
            • Pictures
            • Strings
          • Modifying an existing Dynamics GP report
            • Common modifications
            • Modifying a report: Adding aging buckets to Payables Trial Balance Report
          • Importing and exporting customized reports
            • Exporting customized reports
            • Importing customized reports
            • Using modified reports from the Reports Library
          • Rendering reports in Microsoft Word by utilizing the new Dynamics GP 2010 Word template feature
            • Enabling Word templates
            • Installing the Dynamics GP add-in for Microsoft Word
            • Understanding the Word template modification process
            • Modifying the presentation of a default Word template
              • Applying simple formatting changes to an existing template
              • Setting the default Word template for a company database
            • Adding fields to an existing Word template
              • Adding new fields to the Check Remittance template
          • Summary
          • Chapter 5: SSRS Report Library
            • Getting started with SQL Server Reporting Services
              • Deployment configurations
                • Standard model
                • Scale-out model
              • Prerequisites for installing SQL Reporting Services
              • Configuring IIS for Reporting Services
                • Configuring IIS for Windows Server 2003
                • Configuring IIS for Windows Server 2008
              • Installing and configuring Reporting Services
                • Installing Reporting Services
                • Configuring Reporting Services
              • Starting Report Manager
            • Deploying SQL Reporting Services reports and metrics
              • Installing the SQL Server Reporting Services Wizard
              • Deploying predefined Reporting Services Reports and metrics for Dynamics GP
              • Listing SQL Server Reporting Services reports in the Dynamics GP Report List
              • Using the predefined SSRS reports
              • Viewing the charts and KPIs from within GP
              • Configuring security for Reporting Services
                • Assigning access to the Reporting Services website
                • Setting up database security for predefined SSRS reports
            • Modifying the canned reports with Visual Studio
            • Creating a new reporting metric via Report Builder
            • Summary
            • Chapter 6: Designing Your Analysis Cubes for Excel Environment
              • Understanding the components of the Analysis Cubes environment
                • SQL Server Database Engine (data warehouse)
                  • Connecting to the data warehouse
                  • Understanding the tables in the data warehouse
                • SQL Server Analysis Services database
                • SQL Server Integration Services packages
                • SQL Server Agent job
                • Multiple tier installations
              • Installing Analysis Cubes
                • Pre-installation checklist
                • Installing the Server Configuration Wizard
                • Using the Server Configuration Wizard to deploy the cubes
                • Populating the data warehouse and processing the cubes
                • Granting security access to the cubes
              • Exploring the Analysis Services database
                • Objects in the Analysis Services database
                  • Data source view
                  • Dimensions
                  • Measure groups
                  • Cubes
                  • Security roles
                  • Advanced objects (KPIs, Translations, Perspectives, Partitions, and so on)
              • Modifying our Analysis Cubes environment
                • Renaming existing attributes in a dimension
                • Adding new attributes to a dimension
                • Modifying the Account Category hierarchy by editing the GLAccountCategory table
                • Adding GP budgets and forecasts to the cubes
                  • Modifying the GLBudgetSetup table
                  • Adding the Budget Measure to the Financials cube
              • Summary
              • Chapter 7: Utilizing Analysis Cubes for Excel for Dynamic Reporting
                • Using an OLAP viewer to connect to the SSAS database
                • Creating a connection to the cubes
                  • Creating a new connection
                  • Storing connection files on network share or locally
                  • Repointing to a different data source
                    • Changing data source for a single pivot table
                    • Changing data sources for an entire workbook
                  • Using an existing connection to connect to a cube
                • Excel Pivot Table-Analysis Cubes Interface
                  • PivotTable pane
                  • PivotTable Field List
                    • Fields Section
                    • Areas Section
                • Creating ad-hoc reports
                  • Using PivotTable design features to change report appearances
                    • Changing the Report Layout
                    • Applying styles to PivotTables
                    • Using slicers to filter PivotTable data
                • Utilizing the Excel cube formulas
                  • Basic cube formulas
                    • CUBEMEMBER
                    • CUBEVALUE
                    • Combining the CUBEVALUE and CUBEMEMBER formulas
                  • Building a "Top Ten" table
                    • CUBESET
                    • CUBERANKEDMEMBER
                    • Creating the table
                    • Adding a chart for visual effect
                • Creating dashboards from Analysis Cubes data—a few thoughts
                • The seven default cubes
                  • Financials cube
                  • Accounts Receivable cube
                  • Accounts Payable cube
                  • Sales cube
                  • Purchases cube
                  • Inventory cube
                  • Analytical Accounting cube
                • Summary
                • Chapter 8: Designing Financial Reports in Management Reporter
                  • Management Reporter architecture
                  • Installing and configuring Management Reporter
                    • Installation overview
                    • Registering Management Reporter
                    • Configuring a data provider
                  • Management Reporter security
                    • Users
                    • Groups
                    • Companies
                  • Navigating the Management Reporter report designer interface
                    • Menu bar
                      • File
                      • Edit
                      • View
                      • Format
                      • Company
                      • XBRL
                      • Go
                      • Tools
                      • Window
                      • Help
                    • Navigation Pane
                  • Working with the Management Reporter building blocks
                    • Row definitions
                    • Column definitions
                    • Reporting Tree definitions
                    • Report Definitions
                      • Report
                      • Output and Distribution
                      • Headers and Footers
                      • Settings
                  • Tools for reducing building block sprawl
                    • Group building blocks in the Navigation Pane with the use of folders
                    • Creating building block groups in environments with multiple entities
                    • Finding and eliminating unused building blocks by using building block associations
                  • Management Reporter Feature Pack 1
                  • Summary
                  • Chapter 9: Viewing Financial Reports in Management Reporter
                    • Overview of Report Viewer for Management Reporter
                    • Report Library permissions
                    • Generating reports to the Report Library via Report Designer
                    • Navigating the Report Viewer for Management Reporter interface
                      • Overview of Report Viewer interface
                        • Menu bar
                        • Navigation Pane
                      • Inserting external files to create report packages
                      • Understanding Version Control
                    • Differences between Management Reporter and FRx
                      • 64-bit compatibility
                      • Enhanced stability and performance
                      • SQL Server
                      • User experience
                    • Summary
                    • Chapter 10: Bringing it all Together
                      • Looking back at what we've covered
                        • Chapter 1: Reporting trends and challenges
                        • Chapters 2-9: Reporting tools for Dynamics GP
                      • Viewing our reporting tools in light of reporting challenges
                        • Intended audience
                        • Data sources
                        • Latency
                        • Formatting and presentation
                        • Ad hoc queries versus traditional reports
                        • Security
                        • Network access and general IT infrastructure
                        • Developer resources
                      • The future of reporting for Dynamics GP
                      • Summary

                        Christopher Liley

                        Chris Liley is a Principal Consultant with Microsoft Partner I.B.I.S., Inc.in 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.

                        Code Downloads

                        Download the code and support files for this book.


                        Submit Errata

                        Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.


                        Errata

                        - 9 submitted: last submission 30 Oct 2013

                        Errata type: Technical | Page number: 88

                        The last sentence in the second paragraph under the heading Storing Report Writer reports should say R309.dic instead of F309.dic.

                         

                        "

                        Errata type: Others | Page number: 89

                        The sentence in the second bullet pont before the end of the page
                        "all users are affected until a restored copy of the reports dictionary is restored"
                        can be rephrased as
                        "all users are affected until an archive copy or backup of the reports dictionary is restored"

                         

                        "

                        Errata type: Others | Page number: 117

                        The last sentence in the first paragraph under the heading Importing and exporting customized reports
                        "It can also be used to transfer customized reports from one company database to another or even from one system to another."
                        can be rephrased as
                        "It can also be used to transfer customized reports from a company database in one environment to a company database in a completely separate environment

                         

                        Errata type: Typo | Page number: 284

                        The last sentence before the endo of the page
                        View: Users with this permission can view contents of any folder, report, report version, and external supporting documents they or their user group is assigned too.
                        should be View: Users with this permission can view contents of any folder, report, report version, and external supporting documents they or their user group is assigned to.

                         

                        Errata type: Typo | Page number: 284

                        The fouth bullet point under Report Library permissions
                        Viewer: Members of this role only have access to view reports that they have been granted access too.
                        should be
                        Viewer: Members of this role only have access to view reports that they have been granted access to.

                         

                        Errata type: Typo | Page number: 285

                        The text athe beginning of the page
                        Create: Users with this permission can create new sub folders and add supporting documents to the Report library or folder they have access too
                        should be
                        Create: Users with this permission can create new sub folders and add supporting documents to the Report library or folder they have access to

                        Edit: Users with this permission can edit folder names, report names, and supporting documentation that they have access too
                        should be
                        Edit: Users with this permission can edit folder names, report names, and supporting documentation that they have access to

                        Delete: Users with this permission can delete folders, reports, report versions, and supporting documents that they have access too
                        should be
                        Delete: Users with this permission can delete folders, reports, report versions, and supporting documents that they have access to

                         

                        Errata type: Typo | Page number: 285

                        The first sentence under the heading Modifying the canned reports with Visual Studio
                        Now that we have learned how to deploy the pre-defned Reports, access them in Dynamics GP 2010 and how to assign security to them, we will now take a look at modifying these reports with Visual Studio to curtail them too our particular organization's needs.
                        should be
                        Now that we have learned how to deploy the pre-defned Reports, access them in Dynamics GP 2010 and how to assign security to them, we will now take a look at modifying these reports with Visual Studio to curtail them to our particular organization's needs.

                         

                        Errata type: Typo | Page number: 302

                        The sentence in second paragraph under the heading Chapter 1: Reporting trends and challenges
                        While some of the challenges may not be relevant to a particular scenario, chances are that atleast one or more challenges will manifest themselves.
                        should be
                        challenges may not be relevant to a particular scenario, chances are that at least one or more challenges will manifest themselves.

                         

                        Errata type: Typo | Page number: 316

                        In the second paragraph
                        As we move forward in this ultra-competitive environment, we look to Microsoft Dynamics GP to continue to provide cutting edge reporting that empower users with the necessary information to stay ahead of the curve and fnd a true competitive advantage for their organization.
                        should be
                        As we move forward in this ultra-competitive environment, we look to Microsoft Dynamics GP to continue to provide cutting edge reporting that empowers users with the necessary information to stay ahead of the curve and fnd a true competitive advantage for their organization.

                         

                        Sample chapters

                        You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                        Frequently bought together

                        Microsoft Dynamics GP 2010 Reporting +    IBM DB2 9.7 Advanced Administration Cookbook =
                        50% Off
                        the second eBook
                        Price for both: $51.15

                        Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                        What you will learn from this book

                        • 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

                        In Detail

                        "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.

                        Create and manage business reports as well as identifying the most appropriate reporting tool for a variety of reporting challenges with Microsoft Dynamics GP

                        Approach

                        Part tutorial, part reference guide, this book will show you how to create and manage reports as well as identify the most appropriate reporting tool for any reporting challenge. In addition, you will learn universal topics such as how to locate data for any given report. Although some of the reporting tools addressed in this book are exclusive to Dynamics GP 2010, many of the topics discussed also apply to older versions of GP.

                        Who this book is for

                        If you are a Microsoft Dynamics GP developer, consultant, or power user who wants to create and manage reports, then this book is for you. A working knowledge of Microsoft Dynamics GP is required. A basic understanding of business management systems and reporting applications such as Microsoft Excel and SQL Reporting Services is highly recommended.

                        Code Download and Errata
                        Packt Anytime, Anywhere
                        Register Books
                        Print Upgrades
                        eBook Downloads
                        Video Support
                        Contact Us
                        Awards Voting Nominations Previous Winners
                        Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                        Resources
                        Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software