Microsoft Dynamics GP 2010 reporting : create and manage business reports with Dynamics GP / David Duncan, Christopher Liley.

Format:

Book

Author/Creator:

Duncan, David.

Contributor:

Liley, Christopher.

Series:

Professional expertise distilled

Language:

English

Subjects (All):

Accounting--Computer programs.

Accounting.

Corporation reports--Data processing.

Corporation reports.

Business enterprises--Finance--Data processing.

Business enterprises.

Physical Description:

1 online resource (360 p.)

Edition:

1st ed.

Place of Publication:

Olton, Birmingham : Packt Pub., 2011.

Language Note:

English

Summary:

Create and manage business reports with Dynamics GP with this book and eBook

Contents:

Cover; Copyright; Credits; Foreword; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; 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 KitUsing 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 reportsMaintaining 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 BuildersSummary; 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

Notes:

Includes index.

ISBN:

9786613376855

9781283376853

1283376857

9781849682190

1849682194

OCLC:

780490081