Microsoft Dynamics GP 2013 reporting. (2013)

• Record Type: Book
• Further Information: Note: David Duncan, Christopher J. Liley.
• Other Names: Duncan, David; Liley, Christopher
• Contents: Cover; Copyright; Credits; About the Author; Acknowledgments; About the Author; Acknowledgments; 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 the report generation process; Challenges in 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 database versus company database; System 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 2013 Software Development Kit; Downloading the Software Development Kit. Using the Software Development KitSupport Debugging Tool; Downloading the Support Debugging Tool; Using the Support Debugging Tool; Summary; Chapter 3: Working with the Builders: SmartList and Excel Reports; Utilizing canned 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 ReportsThe shared network folder permissions; The 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 BuildersSummary; 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 to 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.
• Edition: 2nd ed
• Publisher Details: Birmingham : Packt Publishing
• Publication Date: 2013
• Extent: 1 online resource (386 pages), illustrations
• Subjects: 657.0285536; Business report writing; Accounting -- Software; Corporation reports -- Data processing; Business enterprises -- Finance -- Data processing; Electronic data processing; Business report writing; Electronic data processing; BUSINESS & ECONOMICS / Accounting / Financial; Electronic books
• Languages: English
• ISBNs: 9781849688932; 1849688931
• Related ISBNs: 9781849688925; 1849688923
• Notes: Note: Print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.