0

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Microsoft Dynamics GP 2016 Cookbook

You're reading from Microsoft Dynamics GP 2016 Cookbook Over 100 powerful and effective recipes to help you solve real-world Dynamics GP problems

Product type Paperback

Published in Aug 2016

Publisher

ISBN-13 9781786463401

Length 376 pages

Edition 1st Edition

Tools

Dynamics GP

Concepts

Enterprise Resource Planning

Authors (2):

Ian Grieve

Mark Polino

View More author details

Table of Contents (15) Chapters

Preface

1. Personalizing Dynamics GP FREE CHAPTER

2. Organizing Dynamics GP

3. Automating Dynamics GP

4. Leveraging New and Updated Features in Dynamics GP

5. Exposing Hidden Features in Dynamics GP

6. Improving Dynamics GP with Hacks

7. Preventing Errors in Dynamics GP

8. Harnessing the Power of SmartLists

9. SmartList Designer

10. Connecting Dynamics GP to Microsoft Office 2016

11. Maintaining Dynamics GP

12. Extending Dynamics GP Professional Services Tools Library

13. Modern Business Intelligence for Dynamics GP

Index

Reporting on any Dynamics GP data with direct Excel connections

In an earlier recipe, we looked at deploying and using the Excel reports contained in Dynamics GP. For all of the power of those dynamic reports, one thing is missing, the ability to modify the type of data being returned from within Excel. Excel reports allow filtering. However, if a user only needs a subset of data, using filters can make it difficult to work with only the filtered data. Also, Excel reports bring in all of the available rows, creating a much larger data set to work with and possibly overwhelming Excel.

Fortunately, there is another option. The MS Query tool included with Excel can work with Open Database Connectivity (ODBC) to connect to live data in Dynamics GP. This process is as fast as Excel reports, allows user-changeable parameters from Excel, and can be refreshed just like Excel reports. However, there are no pre-built reports that use ODBC connections, so users have to build these from scratch.

To demonstrate...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at €18.99/month. Cancel anytime

Authors (2)

Grieve

Grieve

Ian Grieve is a Microsoft Most Valuable Professional for Microsoft Dynamics GP. He is also a certified Dynamics CRM consultant, specializing in the delivery of Microsoft Dynamics GP. He is the ERP Practice Manager at Perfect Image Ltd., a Microsoft partner, and VAR in the North-East of England, where he is responsible for the delivery, by his team, of all Dynamics GP projects. Ian has worked with Microsoft Dynamics GP since 2003, and over the years, he has dealt with all aspects of the product's life cycle, ranging from presales, implementation, technical, and functional training post go-live support to subsequent upgrades and process reviews. Ian is the author of Microsoft Dynamics GP 2013 Financial Management by Packt Publisihing and Microsoft Dynamics GP Workflow 2.0 and Implementing the Microsoft Dynamics GP Web Client by azurecurve Publishing. He is also the co-author of Microsoft Dynamics GP 2013 Cookbook by Packt Publisihing. Additionally, he has produced the Microsoft Dynamics GP Techniques online learning course and was the technical reviewer for several books on Microsoft Dynamics CRM published by Packt Publishing, including Microsoft Dynamics CRM 2011 Cookbook. In his spare time, Ian runs the azurecurve blog, Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk), which is dedicated to Microsoft Dynamics GP and related products. The most recent offshoot of running his blog is that Ian has started writing plugins to extend the functionality of the blogging platform, WordPress. A new site, azurecurve Development (http://development.azurecurve.co.uk), contains information about his plugins.

See other products by Grieve

Polino

Polino

Mark Polino is CPA, with additional certifications in financial forensics (CFF) and information technology (CITP). He is a Microsoft MVP for Business Solutions and a GPUG All Star who has worked with Dynamics GP and its predecessors since 1999. He works as the Director of Client Services for Fastpath, and he runs the DynamicAccounting.net website dedicated to all things Dynamics GP. He is a regularly featured speaker at Dynamics GP related events. This is Mark's tenth book, and his seventh GP related book with Packt Publishing. His work includes eight technology-focused books and two novels. He is also the author of the best-selling Microsoft Dynamics GP 2010 Cookbook, the spin off Lite edition, and a co-author for updated GP 2013 and 2016 editions, all from Packt Publishing.

See other products by Polino

Personalised recommendations for you

Based on your interests and search pattern

Mastering Customer Success

Mastering Customer Success

This guide unveils strategies to cultivate enduring customer relationships. Grounded in effective communication and problem-solving, it shows you how to harness cross-functional collaboration for competitive advantage.

May 2024 5h 40m

Architecting Salesforce Success

Architecting Salesforce Success

This book provides you with a roadmap to becoming a successful Salesforce Architect. Covering common pitfalls and valuable insights, this book prepares you to transition to the role of a Salesforce Architect.

The SketchUp Handbook for Interior Design

The SketchUp Handbook for Interior Design

The SketchUp Handbook for Interior Design walks interior designers and architects through SketchUp Pro and Studio at an intermediate+ level, covering topics and tools specific to the world of design.

Jun 2024 19h 56m

Power Platform and the AI Revolution

Power Platform and the AI Revolution

Learn how to integrate cutting-edge AI technology into business operations and tap into AI services within Power Platform to enable automation and develop apps and chatbots to achieve heightened productivity and efficiency.

May 2024 11h 52m

Mastering Project Management with ClickUp for Work and Home Life Balance

Mastering Project Management with ClickUp for Work and Home Life Balance

This book will guide you in using ClickUp to become a power user of your life. You'll learn practical strategies for setup, project management, and AI integration to optimize workflow, boost productivity, and manage time effectively.

Jun 2024 10h 16m

Mastering UI Development with Unity

Mastering UI Development with Unity

With Unity's robust toolkit, you can create visually appealing UIs to give your games a professional look and feel. This book will help you realize the full potential of the UI systems provided by Unity, so you can create the best UI for your games.

Jun 2024 21h 16m

Autodesk Civil 3D 2025 Unleashed

Autodesk Civil 3D 2025 Unleashed

This book is a comprehensive guide to using Autodesk Civil 3D. You'll progress from design customization with extensions and information management to project extension, preparing you for a successful career in civil engineering.

Jul 2024 10h 28m

Mastering Salesforce Experience Cloud

Mastering Salesforce Experience Cloud

Mastering Salesforce Experience Cloud covers every facet of the platform, from technical reviews to implementation, business transformation, and long-term growth strategies. Learn to maximize the potential of Salesforce Experience Cloud.

Oct 2024 10h 56m

Mastering the Art of Sales Engineering

Mastering the Art of Sales Engineering

This book covers what a sales engineer is and does, and why this is a highly paid and coveted role. The authors share their vast experience to help you learn daily operations and skills to advance your sales career.

Sep 2024 10h 32m

Taking Tinkercad to the Next Level

Taking Tinkercad to the Next Level

Tinkercad users familiar with the basic functionality will learn to create complex shapes and multi-part designs with this book on advanced modeling. It covers strategies and techniques for modeling and designing for production with 3D printers.

Sep 2024 13h 56m