Book Image

Developing Microsoft Dynamics GP Business Applications

By : Leslie Vail
Book Image

Developing Microsoft Dynamics GP Business Applications

By: Leslie Vail

Overview of this book

Microsoft Dynamics GP is a sophisticated Enterprise Resource Planning (ERP) application with a multitude of features and options. Microsoft Dynamics GP can also be used to develop dynamic, mission critical applications. In "Developing Microsoft Dynamics GP Business Applications" you will learn how to create and customize Dynamics GP Applications. This hands-on guide will take you through the initial steps of setting up a development environment through to customizing and developing an example application using tools such as Dexterity, VSTools and sanScript. "Developing Microsoft Dynamics GP Business Applications" will take you through the complex steps of creating and customizing Microsoft Dynamics GP applications. Starting with an overview of Microsoft Dynamics GP architecture you'll then move onto setting up your development environment. You will learn how to make your application come to life with Dexterity and sanScript. You will create table operations and ranges as well as object triggers to make powerful and practical business applications. You will deploy your Dexterity solution before moving onto customization with Modifier and VBA. This book will also take you through ways of enhancing and extending your application without code using the SmartList Builder and Excel Report Builder. Using these highly flexible tools you'll be able to create data connections that will increase the usability and functionality of your ERP applications.
Table of Contents (15 chapters)
Developing Microsoft Dynamics GP Business Applications
Credits
About the Author
Index

Drill Down Builder


Drill Down Builder can take Excel Report Builder to the next level. Excel Report Builder provides a way for you to create Excel spreadsheets that are linked to the live databases. Drill Down Builder provides you with a way to create URLs that can be used by your Excel report, or any other external program, to drill down into the Dynamics GP application.

Open Drill Down Builder using the following navigation: Microsoft Dynamics GP | Tools | SmartList Builder | Drill Down Builder.

On the Drill Down Builder window, you can create three different types of drill-downs.

  • Form: A Form drill-down opens a Dynamics GP window and sets the value(s) in the window.

  • SmartList: A SmartList drill-down opens a SmartList object and sets search parameters.

  • Extender: An Extender drill-down opens an Extender form or Detail form and sets the value(s) of the ID fields.

Drill-downs are comparable to the Go Tos you created for a SmartList object.

For this project, you will create a Form drill-down that...