Administration

GPUG Academy

Advanced GP Power Tools Tricks and Tips

Monday, October 9
1:00 PM - 5:00 PM
Location: Ryman Studio O located in Ryman Ballroom and Studios (Level 0)

Format: Academy Course
CPE: 4
Preparation: Please bring a Windows PC to class for the Academy’s hands-on training environment from Visilearn called vConnect.

GP Power Tools (earlier versions known as the Support Debugging Tool) is recognized by system administrators and consultants as a valuable tool that eases the task of administering Microsoft Dynamics GP.

In this advanced workshop, we build upon the foundation from the introduction workshop and look further into the administrator level (advanced mode) features of the tools. We will look into the scripting and programming capabilities of the tools, showing how it can be used to customize the system and fix issues. Also, we will explore the Database Validation feature to understand how this will help ensure your system is in “tip top” shape and so avoid upgrade issues.

David Musgrave, the original developer, will guide you through practical, hands-on examples using a variety of scripting languages including SQL, Dexterity and now C# and VB.Net. Don’t worry if you don’t have experience with, we can guide you through.
This session will cover the Database and Developer Modules of GP Power Tools. The System features and Administrator Module of GP Power Tools are covered in the Introduction workshop.

Learning Objectives:
• How to use Database Validation to fix potential upgrade problems before they occur.
• How to export and import data as XML files.
• How to use Advanced Trigger Mode to track down issues.
• How to use triggers to create customizations.
• How to write scripts in a variety of scripting languages.
• How to create user interfaces to your scripts with parameter lists.
• How to create custom report writer functions to retrieve data from any source.

Instructor: David Musgrave

Product: Microsoft Dynamics GP

Audience: Power Users, Administrators, Consultants, Support Engineers and Developers.

Prerequisites:
• Attendance to Introduction workshop preferred.
• Understanding of navigation and administration of Microsoft Dynamics GP.
• Understanding of SQL and some programming experience preferred.




David Musgrave

Managing Director
Winthrop Development Consultants

David Musgrave is Managing Director of his own development and consulting business. Based in the suburb of Winthrop in Perth, Western Australia, Winthrop Development Consultants offers a range of Microsoft Dynamics GP add-on products as well as development, consulting and training services to the ISVs, partners and customers of the Microsoft Dynamics GP community.

David is known for his many products including GP Power Tools (previously the Support Debugging Tool), Visual Studio Integration Toolkit (previously Menus for Visual Studio Tools) and the Batch Posting Service Toolkit. He was also the original author of Named Printers, Omni Tools, Omni Price, Advanced Security, Field Level Security, Business Activity Statement (for Australian GST), and SnapShot. He has also made many contributions to the code of Microsoft Dynamics GP.

David has presented many popular sessions at customer and partner conferences and delivered training around the world. He is active in the Microsoft Dynamics GP community and has contributed to the partner, community and user group forums as well as his Developing for Dynamics GP and Winthrop Development Consultants blogs. He has been recognized with both Microsoft MVP and GPUG All Star status.

Outside of work David enjoys spending time with his family, cycling, DJing for parties, robotics, technology and gadgets (not necessarily in that order).

Presentation(s):

Send Email for David Musgrave


Assets

Advanced GP Power Tools Tricks and Tips



Attendees who have favorited this

Send Email for Advanced GP Power Tools Tricks and Tips