Book Image

Microsoft Dynamics GP 2013 Cookbook

Book Image

Microsoft Dynamics GP 2013 Cookbook

Overview of this book

Microsoft Dynamics GP is an enterprise resource planning system, essentially an accounting system on steroids, designed for mid-sized organizations. The implementation of Dynamics GP is usually considered to be complex, and people often realize there must be more efficient ways of working with the system. This book will show readers how to improve their use of Dynamics GP and get the most out of this tool quickly and effectively. "Microsoft Dynamics GP 2013 Cookbook" picks up where implementation training leaves off. Whether you are new or experienced you will find useful recipes for improving the way you use and work with Dynamics GP. The clear recipe steps and screenshots make implementing these solutions easy for users of any level and will be sure to improve your efficiency with the Dynamics GP 2013 system. 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 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, harnessing the power of SmartLists to leverage both simplicity and power, connecting Dynamics GP to Microsoft Office 2013, exposing hidden features in Dynamics GP, and much more! Through the final chapters, the book covers system maintenance and extending Dynamics GP with the Support Debugging Tool and Professional Services Tools Library.
Table of Contents (22 chapters)
Microsoft Dynamics GP 2013 Cookbook
Credits
About the Author
Acknowledgment
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
Index

Managing personal reports with My Reports


My Reports is a section of the Dynamics GP Home page designed to provide fast access to reporting options in Dynamics GP. Similar to Quick Links functionality, My Reports provides single click access to reports, replacing multiple clicks and drill downs with a direct connection.

In Dynamics GP, every prebuilt report (also known as a Report Writer report) requires an option. An option is simply a named group of settings for a particular report. For example, a user may have a Receivables Aged Trial Balance report with date and selection criteria designed for month end reporting. The report name is always Receivables Aged Trial Balance but the option name to describe those particular month end settings might be Month End.

The My Reports feature provides one click access to reports with saved options. In this recipe we'll look at how to add a report to My Reports.

How to do it...

To add a report to My Reports, we will need to complete the following steps:

  1. Select the Sales button from the Navigation Pane on the left side. In the list on the left select Report List.

  2. In the center section, scroll down to the report named Aged Trial Balance with the Option column value of demo and check the box to the left.

    Demo is a prebuilt, saved report option. Report options are saved report settings for items like dates and restrictions.

  3. Click on the Add to button to add this to the My Reports section of the Home page. Accept the default name for the report by clicking on OK.

  4. Click on the Home button on the Navigation Pane to return to the Home page. The Aged Trial Balance-demo report now appears on the Home page under My Reports.

  5. Clicking on the Aged Trial Balance-demo link under My Reports now runs the report automatically.

There's more...

Other features and options are available to assist with managing reporting in Dynamics GP.

Reports without options

Reports without options cannot be added to the My Reports section of the Home page. Consequently, users need to create and save report options to make those reports available to the Home page.

Better dates in report options

A technique for setting up report dates for automatic reporting is covered in detail in the Controlling reporting dates with Beginning and Ending Periods recipe in Chapter 4, Automating Dynamics GP.

See also

  • The Personalizing the Home Page by selecting the right role recipe

  • The Speeding access to data with Quick Links recipe

  • The Viewing open items with the Task List recipe

  • The Controlling reporting dates with beginning and ending periods recipe in Chapter 4, Automating Dynamics GP