Microsoft Dynamics GP 2013 Reporting - Second Edition


Microsoft Dynamics GP 2013 Reporting - Second Edition
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
Support
Sample Chapters
  • Explore the new reporting features found in GP 2013
  • Add value to your organization by identifying the major reporting challenges facing your organization and selecting 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

Book Details

Language : English
Paperback : 386 pages [ 235mm x 191mm ]
Release Date : October 2013
ISBN : 1849688923
ISBN 13 : 9781849688925
Author(s) : David Duncan, Christopher J Liley
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 and Word Templates
Chapter 5: Utilizing the SSRS Report Library
Chapter 6: Designing Your Analysis Cubes for the 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 the report generation process
    • Challenges to developing and writing reports
      • Intended audience
      • Data sources
      • Latency
      • Formatting and presentation
      • Ad-hoc reports 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?
      • System databases versus company databases
        • System databases
        • Company databases
      • 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
      • The Table Import utility
      • Accessing data at the table level using SQL Management Studio
      • Locating Dynamics GP data with additional tools
        • Dynamics GP 2013 Software Development Kit
          • Downloading the Software Development Kit
          • Using the Software Development Kit
        • The Support Debugging Tool
          • Downloading the Support Debugging Tool
          • Using the Support Debugging Tool
      • Summary
      • Chapter 3: Working with the Builders – SmartList and Excel Reports
        • Utilizing default SmartLists to meet basic reporting needs
          • Structure of SmartList
          • Basic SmartList concepts
            • Narrowing our result list with search criteria
            • Adding new columns
            • Changing the number of records returned
            • Modifying a dex.ini switch for faster export to Excel
        • 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 2013
        • Creating and publishing new SmartLists using SmartList Builder
          • Understanding the SmartList Builder window
          • Creating a new SmartList Object via SmartList Builder
        • Deploying new Excel Reports with Excel Report Builder
          • Understanding the Excel Reports Builder window
          • Creating a new Excel Report via Excel Report Builder
        • Additional tips and tricks for using both Builders
        • Summary
        • Chapter 4: Report Writer and Word Templates
          • Storing and accessing Report Writer reports
            • Storing Report Writer reports
            • Accessing Report Writer reports
              • Setting the Dynamics GP launch file
              • Setting security for custom/modified reports
          • Opening and navigating the Report Writer windows
            • Setting security permissions to use 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 periods to Payables Trial Balance Report
          • Importing and exporting customized reports
            • Exporting customized reports
            • Importing customized reports
          • Rendering reports with the Microsoft 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 and password protection 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
            • Using Word Template Generator to create additional Word templates
              • Create a Word template for Summary GL Trial Balance
          • Summary
          • Chapter 5: Utilizing the SSRS Report Library
            • Getting started with SSRS
              • Prerequisites for SSRS
            • Deploying SSRS reports and metrics
              • Deploying predefined Reporting Services reports and metrics for Dynamics GP
            • Using the predefined SSRS reports
              • Viewing SSRS reports in the Dynamics GP report list
              • Launching predefined SSRS reports directly from Report Manager
              • Assigning and using predefined SSRS reports on GP forms
            • Viewing charts and KPIs using Business Analyzer
              • Installing and configuring Business Analyzer
              • Using the standalone Business Analyzer client
              • Using Business Analyzer from within the Dynamics GP client
            • Configuring security for Reporting Services
              • Assigning access to the Reporting Services website
              • Setting up database security for predefined SSRS reports
            • Modifying default reports with Visual Studio
            • Creating a new reporting metric via Report Builder
            • Summary
            • Chapter 6: Designing Your Analysis Cubes for the 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
                • An SSAS database
                • SSIS packages
                • SQL Server Agent job
                • Multiple tier installations
              • Installing Analysis Cubes
                • Reviewing the preinstallation checklist
                • Installing the Server Configuration Wizard
                • Using the Server Configuration Wizard to deploy cubes
                • Populating the data warehouse and processing cubes
                • Granting security access to cubes
              • Exploring the Analysis Services database
                • Understanding objects in the Analysis Services database
                  • The 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 cubes
                  • Modifying the GLBudgetSetup table
                  • Adding the Budget measure to the Financials cube
              • Considerations for upgrading Analysis Cubes for Excel
              • 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 cubes
                  • Creating a new connection
                  • Storing connection files locally or on a network share
                  • Repointing to a different data source
                    • Changing the data source for a single PivotTable
                    • Changing data sources for an entire workbook
                  • Using an existing connection to connect to a cube
                • Excel PivotTable – the Analysis Cubes interface
                  • The PivotTable pane
                  • The PivotTable Field List
                    • The Fields Section
                    • Areas Section
                • Creating ad-hoc reports
                  • Using PivotTable design features to change report appearances
                    • Changing Report Layout
                    • Applying styles to PivotTables
                    • Using slicers to filter PivotTable data
                • Utilizing Excel CUBE formulas
                  • Basic cube formulas
                    • CUBEMEMBER
                    • CUBEVALUE
                    • Combining the CUBEVALUE and CUBEMEMBER formulas
                  • Building a top-10 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
                  • The Financials cube
                  • The Accounts Receivable cube
                  • The Accounts Payable cube
                  • The Sales cube
                  • The Purchases cube
                  • The Inventory cube
                  • The Analytical Accounting cube
                • Summary
                • Chapter 8: Designing Financial Reports in Management Reporter
                  • Management Reporter architecture
                  • Installing and configuring Management Reporter
                    • Installation overview
                    • Configuring Management Reporter Server components
                    • Importing companies
                    • Registering Management Reporter
                  • Management Reporter security
                    • Users
                    • Groups
                    • Companies
                  • Navigating the Management Reporter Report Designer interface
                    • The Menu bar
                      • File
                      • Edit
                      • View
                      • Format
                      • Company
                      • XBRL
                      • Go
                      • Tools
                      • Window
                      • Help
                    • The 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
                  • Improvements in Management Reporter 2012
                  • Tools for reducing building block sprawl
                    • Grouping 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
                  • Summary
                  • Chapter 9: Viewing Financial Reports in Management Reporter
                    • Overview of Report Viewer for Management Reporter
                    • Report Library permissions
                    • Generating reports via Report Designer
                    • Navigating the Report Viewer interface
                      • Overview of the Report Viewer interface
                        • Menu bar
                        • The Navigation Pane
                      • Inserting external files to create report packages
                      • Understanding version control
                    • Navigating reports via the Web Viewer
                    • Summary
                    • Chapter 10: Bringing it all Together
                      • Looking back at what we've covered
                        • Reporting trends and challenges
                        • Reporting tools for Dynamics GP
                      • Viewing our reporting tools in light of the 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

                      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.

                      Christopher J Liley

                      Chris Liley is a Principal Consultant with I.B.I.S., Inc., which is a Microsoft Gold Certified Partner based in Norcross, GA. Chris holds several certifications for both Microsoft Dynamics GP and SQL Server. He is a graduate of Georgia State University with a B.B.A in Accounting, and has worked with the Dynamics GP product since 2001. Chris has also previously participated in the Dynamics Partner Advisory Board, and is co-author of Microsoft Dynamics GP 2010 Reporting. Chris' experience ranges from financial analysis, software implementation, data conversions and integrations, to designing and developing customizations in both the functional and technical area of consulting for Dynamics GP. In addition, Chris has extensive experience in designing Business Intelligence solutions and has assisted numerous clients in analyzing their business plans with these solutions.
                      Sorry, we don't have any reviews for this title yet.

                      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.

                      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 2013 Reporting - Second Edition +    Oracle 11g R1/R2 Real Application Clusters Essentials =
                      50% Off
                      the second eBook
                      Price for both: $53.70

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

                      What you will learn from this book

                      • Understand how data is stored in Microsoft Dynamics GP
                      • Use Excel and SmartLists Builders for basic GP reporting needs
                      • Take advantage of the new Word Template functionality in Report Writer including the Word Template Generator
                      • Deploy and modify the Dynamics GP SQL Reporting Services report library
                      • Display SSRS reports in dashboard form with Business Analyzer
                      • 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

                      In Detail

                      Microsoft Dynamics GP 2013 is a sophisticated enterprise resource planning system with a multitude of features and options. Microsoft Dynamics GP enables you to create and manage a variety of reports that can help your organization effectively manage its financial and operational data.

                      "Microsoft Dynamics GP 2013 Reporting - Second Edition" will show you how to create and manage reports, know what tools to use and when, how to use these tools, and where to find the data based on how it’s being entered into the system with Dynamics GP.

                      This book addresses the many challenges and frustrations a company may face when preparing to build new reports. You will learn how to find and locate your data in the GP system and company databases. It then dives deep into topics such as SmartLists, SL Builder and Excel Report Builder, Report Writer, Word Template Generator, SSRS Report Library, Business Analyzer, 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.

                      Approach

                      A practical guide to creating and managing reports as well as identifying the most appropriate reporting tool for any reporting challenge, this book employs real-life, step-by-step examples in a part tutorial, part reference manner.

                      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 "Microsoft Dynamics GP 2013 Reporting - Second Edition" 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