Developing Microsoft Dynamics GP Business Applications

Developing Microsoft Dynamics GP Business Applications
eBook: $35.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $95.98    Print cover: $59.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • Make your business more efficient with fully customizable applications
  • Develop mission critical applications with Microsoft Dynamics GP
  • Learn how to enhance your application with sanScript

Book Details

Language : English
Paperback : 590 pages [ 235mm x 191mm ]
Release Date : December 2012
ISBN : 1849680264
ISBN 13 : 9781849680264
Author(s) : Leslie Vail
Topics and Technologies : All Books, Enterprise Products and Platforms, Microsoft Other, Microsoft Dynamics, Enterprise, Microsoft

Table of Contents

Chapter 1: Microsoft Dynamics GP Architecture
Chapter 2: Integrating Application Fundamentals
Chapter 3: Getting Started with Dexterity
Chapter 4: Building the User Interface
Chapter 5: sanScript – Making It Work
Chapter 6: Deploying a Dexterity Solution
Chapter 7: Creating Customizations with Modifier
Chapter 8: Creating Customizations with VBA
Chapter 9: Code-free Customization
Chapter 10: Creating Customizations with VS Tools
Chapter 11: Upgrading Customizations
  • Chapter 1: Microsoft Dynamics GP Architecture
    • The native user interface
      • Horizontal
      • Vertical
    • Dexterity overview
      • Resource Explorer
      • sanScript scripting language
      • Extensive function library
      • Structured exception handling
      • Integrated source code control
      • Built-in Report Writer
      • COM support
      • Graphical forms designer
      • Debugging tools
      • Dexterity design
    • Components of the Dynamics GP application
      • Start your engines!
      • The launch file (Dynamics.set)
      • The preferences file (Dex.ini)
        • SQLLogSQLStmt
        • SQLLogODBCMessages
        • SQLLogAllODBCMessages
        • Synchronize
        • Workstation=WINDOWS
        • Workstation2
        • OLEPath
        • RememberUser
        • ShowAdvancedMacroMenu
        • ExportOneLineBody
      • The Dexterity Runtime Engine (Dynamics.exe)
    • SQL table and procedure names
      • Original table-naming convention
        • 00000 – Master tables
        • 40000 – Setup tables
        • 50000 – Temp tables
        • 60000 – Relation or Cross Reference tables
        • 70000 – Report Options tables
        • 80000 – Posting Journal Reprint tables
        • 90000 – Miscellaneous tables
      • 10000, 20000, and 30000 - Work, Open, and History Transaction tables
      • Stored procedures
      • Current table-naming convention
    • What you see – the User Interface (UI)
      • Push buttons
      • Note button (record level)
      • Printer icon
      • Zoom fields
      • Lookup button
      • Browse buttons
      • Sort-by List
      • Note button (window level)
    • Additional window elements
      • E-mail Link
      • Map Link
      • Quantity alert button
      • Multicurrency button
      • Show Details
      • Information button
      • Expansion arrow
      • Help button
    • Summary
    • Chapter 2: Integrating Application Fundamentals
      • Defining the project
        • Changing a window's look or behavior
        • Changing current functionality
        • Creating new functionality
        • Exchanging data between systems
        • Storing additional data
        • Types of integrations
      • Overview of available tools
        • Dexterity
          • Capabilities of Dexterity
          • Limitations
          • Developer skills required
          • End-user prerequisites
        • Visual Studio Tools for Dynamics GP (VS Tools)
          • Capabilities of VS Tools
          • Developer skills required
          • End-user prerequisites
        • Modifier with VBA (Visual Basic for Applications)
          • Capabilities of Modifier with VBA
          • Developer skills required
          • End-user prerequisites
        • Continuum
          • Capabilities of Continuum
          • Developer skills required
          • End-user prerequisites
        • Extender / eXtender Enterprise
          • Capabilities of Extender and eXtender Enterprise
          • Developer skills required
          • End-user prerequisites
        • DDE \ ODBC \ ADO \ OLE Automation
          • DDE
          • ODBC
          • ADO
          • OLE Automation
          • Capabilities of DDE \ ODBC \ ADO \ OLE Automation
          • End-user prerequisites
        • Integration Manager
          • Capabilities of Integration Manager
          • Developer skills required
          • End-user prerequisites
        • Table Import
          • Capabilities of Table Import
          • Developer skills required
          • End-user prerequisites
        • eConnect
          • Capabilities of eConnect
          • Developer skills required
          • End-user prerequisites
        • Web services
          • Capabilities of web services
          • Developer skills required
          • End user prerequisites
      • Modifying the user interface
        • Dexterity
        • VS Tools
          • WinForm properties
          • WinForm control properties
        • Modifier with VBA
        • Extender / eXtender Enterprise
          • Forms
          • Detail forms
          • Windows
          • Detail windows
          • Notes
      • Changing or adding functionality
        • Dexterity
          • Form events
          • Window events
          • Field events
          • Scrolling window events
        • Triggers
          • Five triggers in Dexterity
        • VS Tools
          • Form events
          • Window events
          • Scrolling window events
          • Field events
          • Procedure events
          • Function events
        • Modifier with VBA
          • Window events
          • Modal dialog events
          • Field events
          • Scrolling window events
          • Report events
          • Band events
        • Continuum
        • eXtender Enterprise
      • Adding information not previously collected
        • DUOS
      • Summary
      • Chapter 3: Getting Started with Dexterity
        • Overview of the development process
          • Installing the software
          • Preparing your development environment
          • Developing the application
          • Creating the chunk file
          • Delivering the final product
        • Preparing the development environment
          • Installing Dexterity and the SDK
          • Modifying the Dex.ini file
          • Creating the development dictionary
          • Moving to test mode
            • Dynamics GP desktop
          • Modifying user security
          • Installing DexSense
          • Installing the Support Debugging Tool (SDT)
          • Blast off!
        • Overview of Dexterity
          • Components of Dexterity
          • Resources and their relationships
            • DataType
            • Format
            • Field
            • Composite
            • Table
            • Form and window
            • Scrolling window
        • Navigating the Resource Explorer
          • Worksets
        • Summary
        • Chapter 4: Building the User Interface
          • Overview
            • Workset
          • Base resources
            • Data types
            • Format
            • Fields
          • Creating tables and keys
            • Tables
              • Customer Contact Master
              • Contact Phone Master
              • Table naming conventions
              • Table options
              • Types of tables
          • Creating forms and windows
            • Maintenance form and window creation
              • Attaching tables
              • Setting window properties
              • Removing window fields
            • Adding fields to the window
              • New scrolling window
            • Lookup form and window creation
            • Window fields
          • Scrolling windows
          • Working with window fields
            • Adding static text
              • Column headings
          • Summary
          • Chapter 5: sanScript – Making It Work
            • Introduction to sanScript
              • Scripts
                • Syntax rules
                • Script flow
                • Script naming conventions
              • Table operations
                • get
                • change
                • remove
                • save table
                • release table
                • copy to table
                • copy from table
              • Creating a record
              • Retrieving a record
                • Customer
                • Customer zoom
                • Browse buttons
              • Updating a record
              • Deleting a record
              • Ranges
                • Setting a range
                • Creating a virtual key
                • range where
            • Scrolling windows
              • Big and Small Line item
              • BrowseOnly windows
                • Lookup windows
              • Editable windows
                • Line events
              • AddsAllowed windows
            • Triggers
              • Form trigger
                • Form trigger registration
                • Form trigger considerations
                • Cross-dictionary considerations
              • Focus trigger
                • Focus trigger registration
                • Focus trigger considerations
                • Cross-dictionary considerations
              • Database trigger
                • Database trigger registration
                • Database trigger considerations
                • Cross-dictionary considerations
              • Procedure trigger
                • Procedure trigger registration
                • Procedure trigger considerations
                • Cross-dictionary considerations
              • Function trigger
                • Function trigger registration
                • Function trigger considerations
                • Cross-dictionary considerations
              • Create your form trigger!
                • Processing procedure
            • Summary
            • Chapter 6: Deploying a Dexterity Solution
              • System requirements
                • General requirements
                • Feature-specific requirements
              • Minding versions and builds
              • Table creation routines
                • Using the SQL Maintenance window
                • Building a utilities window
                • Automatically creating the tables upon launch
              • Completing the application
                • Forms and windows
                  • Linking your prompts
                  • Linking your lookups
                  • Adding tool tips
                  • Hyperspacing your lookup buttons
                  • Linking your formats
                  • Setting your tab order
                  • Complying with user interface standards
                • Tables
                • Reports
                  • Referential diagnostics
                  • Linked prompts
                  • Table relationships validation
              • Creating the chunk file
                • Extracting resources
                • Transfer dictionary module
              • Testing in a multi-dictionary environment
                • Chunk doesn't unchunk
                • Testing tools and techniques
                • Additional resources available
              • Distributing the completed application
                • Sending the chunk
                • Windows Installer services
              • Summary
              • Chapter 7: Creating Customizations with Modifier
                • Overview of Modifier
                  • Two tools in one!
                • Modifying windows and window fields
                  • Launching Modifier
                  • The window properties
                    • Size
                    • Opening position
                    • The tab sequence
                  • The window layout
                  • Modifying the General Entry window
                    • Adding and modifying window fields
                    • Adding fields to the scrolling window
                    • Modifying static text
                    • Adding or changing graphic elements
                • Changing global resources
                  • Pictures and native pictures
                  • Strings
                  • Formats
                  • Data types
                  • Messages
                • Summary
                • Chapter 8: Creating Customizations with VBA
                  • VBA overview
                    • Components
                      • Objects
                      • Properties
                      • Methods
                      • Events
                    • UserForms
                    • Modules
                    • Debugging
                    • Setting options
                  • Windows and window fields
                    • Creating the Summary button
                    • Creating the Go To button
                    • Adding objects to the project
                      • Adding the Vendor Maintenance window
                      • Adding additional windows and window fields
                    • Using methods and properties
                    • Setting field values
                    • Cross-dictionary access
                      • Referencing the Collections module
                  • Scrolling windows
                    • Adding a scrolling window to the project
                    • Grid events
                      • Line got focus
                      • Line lost focus
                      • Line change
                    • Filtering records
                      • BeforeLinePopulate
                  • Fun with dialogs
                    • BeforeModalDialog
                    • AfterModalDialog
                  • The Dynamic User Object Store
                    • Architecture
                    • Declaring the objects
                    • Retrieving data
                    • Saving data
                    • Deleting data
                  • Deploying a Modifier/VBA customization
                    • Creating package files
                    • Limitations of packages
                    • Editing packages
                    • Known issues with Windows 7
                  • Summary
                  • Chapter 9: Code-free Customization
                    • Overview of tools
                      • SmartList Builder
                      • Excel Report Builder
                      • Drill-Down Builder
                      • Extender
                    • SmartList Builder
                      • Getting Started with SmartList Builder
                        • Importing the templates
                      • Creating a SmartList object
                      • Adding tables
                      • Fields
                      • Field options
                        • Currency fields
                        • Date fields
                        • Integer and long integer fields
                        • String fields
                      • Calculated fields
                        • Calculated field 1: QTY Available for Sale
                        • Calculated field 2: List of On Hand QTY
                        • Calculated field 3: CONSTANT 2
                        • Calculated field 4: CONSTANT 4
                      • Restrictions
                      • Go Tos
                        • Go To: Item maintenance
                        • Go To: Item transaction inquiry
                    • Granting security to a SmartList Builder object
                    • Excel Report Builder
                    • Drill Down Builder
                    • Extender
                      • Overview
                      • Extender editions
                        • Extender Standard
                        • eXtender Enterprise
                        • Working with Extender
                    • Summary
                    • Chapter 10: Creating Customizations with VS Tools
                      • Architecture
                        • Dexterity Shell
                        • Dexterity Bridge
                        • Application assemblies
                        • Add-ins folder
                      • Installing VS Tools
                        • Download it
                        • Run the installation
                      • Vendor Quick Entry project
                        • Creating the new project
                        • Adding the new window
                        • Window controls
                          • Button
                          • TextBox
                          • Label
                          • RadioButton and GroupBox
                          • ComboBox
                      • Adding window controls
                        • TextBox controls and properties
                        • Label controls and properties
                        • Button controls and properties
                        • RadioButton and GroupBox
                        • ComboBox
                      • Accessing dictionary resources
                        • Referencing the application assembly
                        • Referencing the namespace
                      • Building dictionary assemblies
                        • Dictionary Assembly Generator (DAG)
                        • Using the DAG
                        • Creating the AddIn assembly
                      • Opening your window
                        • Code the action
                        • Building and testing your assembly
                      • Table operations
                        • Creating a record
                        • Retrieving a record
                        • Updating a record
                        • Deleting a record
                      • Clearing the window
                      • Working with ranges
                      • Building and deploying the application
                      • Dynamics GP 2013 consideration
                      • Summary
                      • Chapter 11: Upgrading Customizations
                        • Using the SDK
                          • Script changes
                          • Data model changes
                            • New tables
                            • Deleted tables
                            • New columns
                            • Deleted columns
                            • New indexes
                            • Deleted indexes
                            • Different data types
                            • Different segments
                            • Different index columns
                            • New RW relations
                            • Deleted RW relations
                          • Table changes
                            • Table changes – summary
                            • Table changes – detail
                          • Form changes
                        • Dexterity
                          • Setting up generic source code control
                            • Installing Dexterity Source Code Control Server (DSCCS)
                            • Configuring the DSCCS
                            • Resolving validation errors
                          • Checking in the old dictionary
                          • Checking in the old dictionary to start the new project
                          • Creating the new development dictionary
                          • Making changes to your code
                            • Data type changes
                            • Field changes
                            • Procedure or function changes
                            • Table changes
                            • Functionality changes
                          • Completing the update
                            • Converting the data
                            • Recreating alternate forms and reports
                            • Updating forms and report dictionaries
                            • GP 2013 considerations
                            • Testing your application and building the update chunk
                        • Modifier with VBA
                          • Modifier
                          • VBA
                            • Environment changes
                            • Window changes
                            • Report changes
                            • GP 2013 considerations
                        • Extender and Builder(s)
                          • Extender
                          • SmartList Builder and Excel Report Builder
                        • Visual Studio Tools (VS Tools)
                          • Downloading the application
                          • Opening the solution
                          • Rebuilding application assemblies
                          • Updating references to the assemblies
                          • Fixing the code
                          • Building the new solution
                            • GP 2013 considerations
                        • Summary

                        Leslie Vail

                        Leslie Vail is a CPA and has been working as a Microsoft Dynamics GP Consultant for nearly 20 years. She began with Version 1.0 in 1993. During this period she completed numerous implementations, conversions, and custom-development projects. She has been a Session Leader at many partner and customer-technical conferences, and conducts training classes throughout Northern and Central America. Leslie has been a Microsoft Dynamics GP Microsoft Most Valuable Professional (MVP) since 2007. She is recognized throughout the industry for her product expertise and contributions to the Dynamics community. She is the Principal of ASCI, Inc., a consulting firm located in Dallas, TX. As a Microsoft Certified Trainer (MCT), she serves as a Subject Matter Expert (SME) for the Microsoft Assessments and Certification Exams (ACE) team. She is a member of the US MCT Advisory Council, and has been listed as one of the Microsoft Dynamics Top 100 most influential people by DynamicsWorld. She is one of the top contributors to the Microsoft Dynamics GP Newsgroup and the Dynamics Community forum. Leslie maintains the popular Dynamics Confessor Blogspot blog ( Leslie has reviewed and developed Microsoft Courseware, coauthored the book Confessions of a Dynamics GP Consultant published by Accolade Publications, Inc., and has been the Technical Editor of several books dedicated to Microsoft Dynamics GP. Leslie provides implementation and consulting services for companies ranging from a family office to a multinational manufacturing firm. She is a Microsoft Certified IT Professional in Microsoft Dynamics GP Applications and Microsoft Dynamics GP Installation & Configuration, as well as a Microsoft Certified Database Administrator (DBA). She holds a Microsoft Certified Technology Specialist certification in Dexterity, Modifier with VBA, Integration Manager, Report Writer, HR/Payroll, Financials, Inventory and Order Processing, FRx Report Designer, SQL Server 2000, SQL Server 2008, and Microsoft XP Professional. A skilled developer, Leslie uses Dexterity, Modifier with VBA, Integration Manager, and eConnect to provide custom solutions to her clients. She is a Certified Integration Developer (CID), a Dexterity CID, a Dynamics Tools CID, and a Dexterity Certified Systems Engineer. Her training proficiency spans the entire Microsoft Dynamics GP product line. She is an experienced trainer and gives classes for Dexterity, Financials, Inventory & Order Processing, HR/Payroll, Integration Manager, Modifier with VBA, FRx Report Designer, SQL Server Reporting Services, Report Writer, Crystal Reports, SmartList Builder, Excel Report Builder, Integrated Excel Reports, Extender, and System Manager. Prior to working with Microsoft Dynamics GP, Leslie was the Tax Director for a large financial institution; before that, she worked for one of the original "Big Eight" accounting firms as a Senior Tax Accountant.
                        Sorry, we don't have any reviews for this title yet.

                        Code Downloads

                        Download the code and support files for this book.

                        Submit Errata

                        Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

                        Sample chapters

                        You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                        Frequently bought together

                        Developing Microsoft Dynamics GP Business Applications +    Oracle Application Integration Architecture (AIA) Foundation Pack 11gR1: Essentials =
                        50% Off
                        the second eBook
                        Price for both: £32.75

                        Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                        What you will learn from this book

                        • Discover the ins and outs of Microsoft Dynamics GP Architecture
                        • Utilize Dexterity and sanScript to build business applications
                        • Learn the correct use and implementation of object triggers
                        • Modify your application without code
                        • Utilize VBA to extend your business application
                        • Discover how to use Visual Studio tools
                        • Upgrade Dexterity applications

                        In Detail

                        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.


                        Written in a hands-on and friendly manner, Developing Microsoft Dynamics GP Business Applications takes a practical approach to teaching you how to develop and customize ERP applications.

                        Who this book is for

                        If you are a Microsoft Dynamics GP developer, consultant, or power user who wants to create and customize applications, then this book is for you. A working knowledge of Microsoft Dynamics GP is required. A basic understanding of business management systems and reporting applications, such as Microsoft Excel and SQL Reporting Services, is highly recommended.

                        Code Download and Errata
                        Packt Anytime, Anywhere
                        Register Books
                        Print Upgrades
                        eBook Downloads
                        Video Support
                        Contact Us
                        Awards Voting Nominations Previous Winners
                        Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                        Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software