8520: Modifier with VBA in Microsoft Dynamics GP 9.0 (3 Days)
About this Course
The three-day Microsoft DynamicsT GP Modifier with VBA course explores using the Modifier and VBA tool to customize Microsoft Dynamics GP windows and reports. This course shows you how to modify windows based on user needs, make global changes to graphics and text, and add fields to forms. This course will also show you how to add VBA programming code to enhance the functionality of Microsoft Dynamics GP windows and reports.
A thorough understanding of these tools allows you to integrate data from Dynamics GP to external applications. You will learn how to work with third-party dictionaries within the VBA project. This course also teaches you how to change default values, populate data fields, and store and retrieve data saved in your own tables.
Audience Profile
Individuals desiring to increase their knowledge and the skills necessary to customize Dynamics GP windows and reports.
Modifier with VBA training is recommended for anyone who plans to customize Microsoft Dynamics GP. The class is targeted toward developers or end users. Some knowledge of programming is helpful but not required.
Prerequisites
Before attending this course, students must have:
- General knowledge of Microsoft Windows
- Working knowledge of Microsoft Dynamics GP
- Basic knowledge of database and programming i.e., experience with database using tools such as Microsoft Visual Basic and Microsoft Access is recommended.
At Course Completion
After completing this course, students should be able to:
- Modify Dynamics GP windows and reports to expand the functionality of the solutions
- Customize Dynamics GP to suit user needs
- Control security for modified windows and reports to ensure proper access to approved users
- Capture and store additional data within the system while maintaining integration to the financial series
- Integrate external data with Dynamics GP using Active Data Objects (ADO)
- Reference data within Third Party dictionaries
Course Outline
Module 1: Modifier Overview
This chapter gives students a general overview of the features and benefits of using Modifier. It also informs the student how to locate and store the customized windows and forms.
Lessons
- Modifier Features and Benefits
- Getting Started
- Overview of the Dynamics GP Modifier
- Test Your Skills - Exercises
After completing this chapter, students will be able to:
- Identify the features and benefits available when using Modifier.
- Identify the navigation used to access and customize a window.
- Identify the files used to store the customizations.
- Identify the layout tools used to make the customizations such as the layout window, the toolbox and the properties window.
Module 2: Modifying Window and Form Properties
This chapter focuses on the procedures used to customize window and form properties. You examine in detail the options available to customize windows and forms to reflect the way your organization does business. Time is spent discussing the benefits of using changing window properties.
Lessons
- Setting Window Properties
- Changing the Opening Position of a Window
Lab : Setting Window Options
Lab : Changing the Opening Position of a Window
After completing this chapter, students will be able to:
- Customize settings for Window Properties.
- Change where a window opens so two separate windows can be open at the same time displaying more detail information.
Module 3: Customizing Window Layouts
This chapter explores how to customize window displays. Learn how to modify fields in the window layout. Time is spent discussing how to create and add fields to an existing Dynamics GP window. Time is also spent learning how to work with scrolling windows. Learn how to set the tab sequence and how to add graphics to a window.
Lessons
- Changing Individual Window Displays
- Modifying Fields in a Dynamics GP Window
- Adding Fields to a Window
- Adding Fields to a Scrolling Window
- Setting the Tab Sequence
- Adding Graphics to a Window
Lab : Modifying Individual Window Prompts
Lab : Modifying Field Displays
Lab : Adding Fields to a Window
Lab : Adding Fields to a Scrolling Window
After completing this chapter, students will be able to:
- Understand which window displays can be changed.
- Examine and customize fields in a window.
- Add a local field to an existing Dynamics GP window.
- Add fields to a scrolling window.
- Change the tab sequence of a window.
- Add or modify graphics on a window.
Module 4: Changing Resources
This chapter examines the steps necessary to change global resources. This process includes making a change to global resources and having that change displayed throughout the entire dictionary. Time is spent discussing resources that can be customized globally and what affect the change might have.
Lessons
- Changing Other Global Resources
- Pictures
- Native Pictures
- Data Types and Formats
- Customizing Strings
- Customizing Messages
Lab : Changing Data Formats
Lab : Modifying Push Button Data Types
Lab : Changing Strings in Dynamics GP
After completing this chapter, students will be able to:
- Modify global resources such as strings.
- Create or Change Pictures in the dictionary.
- Alter data types and formats to change the display of field information.
- Customize a string to reflect the type of business you work with.
- Alter messages to end users.
Module 5: VBA Overview
This chapter examines the available VBA components. Methods, Properties and Events are introduced in this section. Time is spent discussing how and why to create User Forms. Time is also spent discussing what variables are and how to use them. You will also learn how to compile and debug code within VBA.
Lessons
- Introduction
- Supported VBA 6.0 Features
- Dynamics GP VBA Components
- Building a User Form
- Variable Declarations
- Compiling and Debugging VBA
After completing this chapter, students will be able to:
- Understand which VBA features are supported.
- Recognize VBA components.
- Create a User Form and add buttons and basic VBA programming to make it functional.
- Differentiate between local and global variables and know how to declare them.
- Use the Compiling and Debugging tools within the VBA application.
Module 6: Working with Windows and Window Fields
This chapter examines the steps necessary to add window and window fields to the VBA project. Time is spent discussing what methods and events are useful to customize displays or change the business logic of a window. Events will be used to execute VBA code you write. This section is filled with hands-on exercises to improve VBA skills.
Lessons
- Overview
- Adding Windows and Window Fields to your Project
- Using Methods and Properties
- Using Events
Lab : Disabling Fields
Lab : Locking Fields
Lab : Setting Required Fields
Lab : Conditionally Disabling Fields
Lab : Opening Lookup Windows
Lab : Changing Dialog Messages
Lab : Restricting Data in Fields
Lab : Setting Drop-Down Fields
Lab : Calculating and Setting Field Values
After completing this chapter, students will be able to:
- Add windows and fields to the VBA project.
- Write VBA code to customize data being displayed.
- Change field properties through code.
- Determine which events will work best with different scenarios.
Module 7: Working with Grids and Grid Fields
This chapter examines the steps necessary to add grids and grid fields to the VBA project. Time is spent discussing the different events used to execute VBA code for grids. This section is filled with hands-on exercises to improve VBA skills.
Lessons
- Adding Grids and Grid Fields to your Project
- Using Methods and Properties
- Using Events
Lab : Setting Field Values in a Grid
Lab : Restricting Data in Grid Fields
Lab : Setting Field Values on Different Lines in a Grid
After completing this chapter, students will be able to:
- Add grids and grid fields to the VBA project .
- Write VBA code to customize data being displayed.
- Alter data being displayed in a grid.
- Control the movement of the cursor to determine if a line item in a grid can be added.
Module 8: Storing Additional Data
This chapter demonstrates how to save and retrieve information stored in additional tables. Methods and Properties will be discussed in detail as these same events would be used with other storage options.
Lessons
- Dynamics User Object Store (DUOS) Overview
- Using Methods and Properties for DUOS Objects
- Using DUOS Objects with Dynamics GP
Lab : Adding Fields to a Dynamics GP Window Using Modifier
Lab : Retrieving from the DUOS table
Lab : Saving from the DUOS table
Lab : Deleting from the DUOS table
Lab : Selectively Deleting Records
After completing this chapter, students will be able to:
- Work with DUOS tables to add and retrieve data from Dynamics GP windows.
- Customize Dynamics GP windows to add a new field, and then display data in that new field.
- Programmatically determine if data should be removed from tables to keep referential integrity between the Dynamics GP tables and the DUOS tables.
Module 9: Working with Reports and Report Fields
This chapter demonstrates how to add reports and report fields to the VBA project. Methods and Properties will be discussed in detail. Time is spent using VBA functions to properly display data in the report. An exercise demonstrates how to create calculated fields to hold data retrieved from the DUOS table.
Lessons
- Overview
- Adding Reports and Report Fields to your VBA Project
- Using Methods and Properties for Report Fields
- Using VBA Functions in your Project
- Using Report Events
Lab : Adding Fields to Existing Dynamics GP Reports
Lab : Populating Calculated Fields in Dynamics GP Reports
After completing this chapter, students will be able to:
- Add reports and report field to the VBA project.
- Determine when to use functions to display data properly in a report.
- Programmatically display data from DUOS tables.
Module 10: Accessing Data Using ODBC
This chapter discusses how to set up and install ADO. Time is spent learning how to retrieve and update data in Dynamics GP using ADO.
Lessons
- Overview
- Setup and Installation of ODBC Drivers
- Setup and Installation of Data Access Method
Lab : Adding Local Fields to a Dynamics GP Window using Modifier
Lab : Populating Local Fields with Data using ADO and VBA Code
After completing this chapter, students will be able to:
- Determine which data access method will work best for their project.
- Programmatically alter data in a Dynamics GP table using ADO.
Module 11: Working with Multiple Third-Party VBA Projects
This chapter discusses how to work with multiple VBA projects. You will learn that not all information you might need to work with is located in the Dynamics GP dictionary. Time is spent working with an exercise demonstrating how to access values in other VBA projects.
Lessons
- Working With Objects in Other Dictionaries
Lab : Modifying a Third-Party Lookup Window to Display Specific Information
After completing this chapter, students will be able to:
- Mark references to multiple VBA projects to allow access to data.
- Determine how to customize a third party window.
- Write VBA code to control the data being displayed in a third-party window.
Module 12: Distributing Your VBA Project
This chapter discusses how to distribute the VBA customizations to the end users. Detailed information will be given regarding import and export issues the user might encounter. Discussion will also be held regarding how to upgrade the customizations.
Lessons
- Distributing VBA Customizations
After completing this chapter, students will be able to:
- Distribute customizations made using Import Package Files.
- Identify that computers have the appropriate files needed for a successful implementation of a VBA Project.
- Determine if imports work properly.
Module 13: Appendix: Test Your Knowledge
This appendix focuses on measuring the comprehension of the trainees on Dynamics GP Modifier and Dynamics GP Visual Basic Applications. The answers to each test are included in this appendix.
Module 14: Appendix: Lab Answers and Solutions
This appendix has the solutions to the labs provided in the chapters throughout this training manual.
Lessons
- Lab 2.1 - Setting Window Options
- Lab 2.2 - Changing the Opening Position of a Window
- Lab 3.1 - Modifying Individual Window Prompts
- Lab 3.2 - Modifying Field Displays
- Lab 3.3 - Adding Fields to a Window
- Lab 3.4 - Adding Fields to a Scrolling Window
- Lab 4.1 - Changing Data Formats
- Lab 4.2 - Modifying Push Button Data Types
- Lab 4.3 - Changing Strings in Microsoft Dynamics GP
- Lab 6.1 - Disabling Fields
- Lab 6.2 - Locking Fields
- Lab 6.3 - Setting Required Fields
- Lab 6.4 - Conditionally Disabling Fields
- Lab 6.5 - Opening Lookup Windows
- Lab 6.6 - Changing Dialog Messages
- Lab 6.7 - Restricting Data in Fields
- Lab 6.8 - Setting Drop-Down Fields
- Lab 6.9 - Calculating and Setting Field Values
- Lab 7.1 - Setting Field Values in a Grid
- Lab 7.2 - Restricting Data in Grid Fields
- Lab 7.3 - Setting Field Values on Different Lines in a Grid
- Lab 8.1 - Adding Fields to a Microsoft Dynamics GP Window Using Modifier
- Lab 8.2 - Retrieving From the DUOS Table
- Lab 8.3 - Saving From the DUOS Table
- Lab 8.4 - Deleting From the DUOS Table
- Lab 8.5 - Selectively Deleting Records
- Lab 9.1 - Adding Fields to Existing Microsoft Dynamics GP Reports
- Lab 9.2 - Populating Calculated Fields in Microsoft Dynamics GP Reports
- Lab 10.1 - Adding Local Fields to a Microsoft Dynamics GP Window Using Modifier
- Lab 10.2 - Populating Local Fields with Data Using ADO and VBA Code
Module 15: Appendix: Methods, Properties and Events
This appendix is a complete list of the methods, properties, and events available for window, field, grid, and report objects.
Lessons
- Window Objects
- Field Objects
- Grid Objects
- Report Objects
- VBA Global Objects
- DUOSObjects Collection
- DUOSObject Object
- DUOSProperties Collection
- DUOSProperty Object
Module 16: Appendix: Dynamics GP VBA Errors
This appendix focuses on Dynamics GP VBA errors. Items such as displaying a VBA dialog with an error number and message text. Information can be found on handling Dynamics GP VBA errors in the same manner as other errors that appear in VBA, using VBA's On Error statement to respond to the error conditions.
Lessons
- Handling Dynamics GP VBA Errors
- Dynamics GP VBA Error Reference