Microsoft Dynamics GP 2010 reporting [[electronic resource] ] : create and manage business reports with Dynamics GP / / David Duncan, Christopher Liley

• Record Nr.: UNINA9910790081403321
• Autore: Duncan David
• Pubbl/distr/stampa: Olton, Birmingham, : Packt Pub., 2011
• ISBN: 1-283-37685-7; 9786613376855; 1-84968-219-4
• Descrizione fisica: 1 online resource (360 p.)
• Collana: Professional expertise distilled
• Altri autori (Persone): LileyChristopher
• Disciplina: 657.0285536
• Soggetti: Accounting - Computer programs; Corporation reports - Data processing; Business enterprises - Finance - Data processing
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: Includes index.
• Nota di contenuto: 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
• Sommario/riassunto: Create and manage business reports with Dynamics GP with this book and eBook