Book Image

Microsoft Dynamics GP 2016 Cookbook

By : Mark Polino, Ian Grieve
Book Image

Microsoft Dynamics GP 2016 Cookbook

By: Mark Polino, Ian Grieve

Overview of this book

The latest release of Dynamics GP 2016 offers a powerful, adaptable, and cloud enabled enterprise accounting software solution. The new version has experienced changes in serviced-based architecture, workflow, existing functionalities, and the introduction of plenty of new features. This book will help you get the most out of Dynamics GP quickly and effectively. This book picks up where implementation training leaves off. Whether you are new or experienced, you will find useful recipes to improve the way you use and work with Dynamics GP. The book starts with recipes designed to enhance the usefulness of Microsoft Dynamics GP by personalizing the look and feel of the application. Most of the recipes are designed to give you tips for a typical installation of Dynamics GP, including core financials and distribution modules. The book then moves through recipes that include automating Dynamics GP to allow users or administrators to focus on value adding tasks, connecting Dynamics GP to Microsoft Office, exposing hidden features in Dynamics GP, PowerBI, and much more!
Table of Contents (20 chapters)
Microsoft Dynamics GP 2016 Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Speeding up Navigation lists by disabling Business Analyzer


Reporting Services reports can be of great benefit to users of Dynamics GP by presenting relevant information to them on the home page and also in the Navigation lists. However, loading Business Analyzer in the Navigation Pane Fact Box can cause the lists to load slowly, so some customers want to disable Fact Box.

Unfortunately, Dynamics GP only allows Fact Box to be hidden manually by individual users, and needs to be hidden on each of the Navigation lists separately. Fortunately, Dynamics GP databases are stored in SQL Server and can be updated with a simple SQL Trigger, which runs each time a user opens a Navigation list for the first time; this recipe will show you how to add this SQL Trigger.

How to do it…

To hide Business Analyzer Fact Boxes in Navigation lists:

  1. Open Microsoft SQL Server Management Studio and connect to the SQL Server used for Dynamics GP. Enter a username and password or use Windows authentication to connect...