Book Image

Microsoft Dynamics GP 2010 Cookbook

By : Mark Polino
Book Image

Microsoft Dynamics GP 2010 Cookbook

By: Mark Polino

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.This book 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 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 2007, exposing hidden features in Dynamics GP, and much more!By following the clear recipe steps and screenshots in this book, you will learn what is required to improve your efficiency with the Dynamics GP system
Table of Contents (17 chapters)
Microsoft Dynamics GP 2010 Cookbook
Credits
About the Author
Acknowledgement
About the Reviewers
Preface
Index

Logging transactions for troubleshooting


In the Chapter 9 recipe, Troubleshooting issues with a DexSQL log, we looked at creating a DexSQL log file for use in troubleshooting. That recipe didn't require any special software, but it did take a lot of back and forth to limit the contents of the file to the specific process to be logged. The free Support Debugging Tool from Microsoft not only makes this much easier, but it also adds a host of features and logging options to get more information for support.

How to do it...

To create a DexSQL log:

  1. In Microsoft Dynamics GP select Tools | Support Debugging Tool from the Microsoft Dynamics GP menu.

  2. In the center of the screen in the SQL Logging section, click on Turn On:

  3. Select Financial from the Navigation Pane. Select General under Transactions.

  4. Reopen the Support Debugging Tool window from the Windows Taskbar and click on Turn Off. The DexSQL log file now exists under the Data folder where Dynamics GP is installed.

That's it. That is the minimum...