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

Controlling data with SmartList record limits


When running a SmartList, the number of records returned by the SmartList is shown in the bottom left. By default, SmartLists have a record limit of one thousand (1,000) records. When the number of transactions matches the maximum, it's likely that there are more transactions not being shown. If the SmartList shows 1,000 bank transactions returned and the criteria shows first 1000 records, it's unlikely that there are exactly 1,000 bank records. In almost all cases, there are more than 1,000 records and the limit should be raised:

The idea behind this default limit is to prevent long-running SmartList queries from slowing down the system. However, sometimes it makes sense for queries to return more than a thousand records.

There are a few options for increasing or decreasing this record limit, including adjusting it on the fly, adjusting the limit for Favorites, and setting a new default limit. We'll take a look at all of these options in this...