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.

Related Content you might be interested in

Current Title:

Small book image
Developing Microsoft Dynamics GP Business Applications
Leslie Vail
Dec, 2012 | 590 pages
No titles found
Table of Contents (15 chapters)
Developing Microsoft Dynamics GP Business Applications
Developing Microsoft Dynamics GP Business Applications
Credits
Credits
About the Author
About the Author
Free Chapter
1
Microsoft Dynamics GP Architecture
Microsoft Dynamics GP Architecture
The native user interface
Dexterity overview
Components of the Dynamics GP application
SQL table and procedure names
What you see – the user interface (UI)
Additional window elements
Summary
2
Integrating Application Fundamentals
Integrating Application Fundamentals
Defining the project
Overview of available tools
Modifying the user interface
Changing or adding functionality
Adding information not previously collected
Summary
3
Getting Started with Dexterity
Getting Started with Dexterity
Overview of the development process
Preparing the development environment
Overview of Dexterity
Navigating the Resource Explorer
Summary
4
Building the User Interface
Building the User Interface
Overview
Base resources
Creating tables and keys
Creating forms and windows
Scrolling windows
Working with window fields
Summary
5
sanScript – Making It Work
sanScript – Making It Work
Introduction to sanScript
Scrolling windows
Triggers
Summary
6
Deploying a Dexterity Solution
Deploying a Dexterity Solution
System requirements
Minding versions and builds
Table creation routines
Completing the application
Creating the chunk file
Testing in a multi-dictionary environment
Distributing the completed application
Summary
7
Creating Customizations with Modifier
Creating Customizations with Modifier
Overview of Modifier
Modifying windows and window fields
Changing global resources
Summary
8
Creating Customizationswith VBA
Creating Customizationswith VBA
VBA overview
Windows and window fields
Scrolling windows
Fun with dialogs
The Dynamic User Object Store
Deploying a Modifier/VBA customization
Summary
9
Code-free Customization
Code-free Customization
Overview of tools
SmartList Builder
Granting security to a SmartList Builder object
Excel Report Builder
Drill Down Builder
Extender
Summary
10
Creating Customizations with VS Tools
Creating Customizations with VS Tools
Architecture
Installing VS Tools
Vendor Quick Entry project
Adding window controls
Accessing dictionary resources
Building dictionary assemblies
Opening your window
Table operations
Clearing the window
Working with ranges
Building and deploying the application
Dynamics GP 2013 consideration
Summary
11
Upgrading Customizations
Upgrading Customizations
Using the SDK
Dexterity
Modifier with VBA
Extender and Builder(s)
Visual Studio Tools (VS Tools)
Summary
Index
Index

Windows and window fields

Now we are ready to set VBA loose! For our project we will add a button to the Vendor Maintenance window,which, when pushed, will open the Vendor Credit Summary window. We are also going to add a Go To button to the Vendor Maintenance window to provide quick navigation to the following windows:

  • Payables Transactions Entry

  • Payables Transaction Inquiry

  • PO Document Inquiry

  • Vendor Yearly Summary

  • Vendor Period Summary

  • Vendor Summary

First, we need to use the Modifier to add our new buttons to the window. The easiest way to do this is to open the window you want to modify (in our case the Vendor Maintenance window), and then select Ctrl + F10 on the keyboard. The Modifier will open with the Vendor Maintenance layout window displayed.

Now, you are going to put the two new buttons on this window and then you will put the VBA code behind them so that they will do something when you push them. At the end of the project, the Vendor Maintenance window should look similar...

Previous Section
End of Section 3
Next Section