Developing Microsoft Dynamics GP Business Applications. If you want a thoroughly practical guide to developing business applications with Microsoft Dynamics GP, this is the book for you. Its hands-on approach will have you developing or customizing in no time

Spis treści książki

• Developing Microsoft Dynamics GP Business Applications
  • Table of Contents
  • Developing Microsoft Dynamics GP Business Applications
  • Credits
  • About the Author
  • Acknowledgement
  • About the Reviewers
  • www.PacktPub.com
    • Support files, eBooks, discount offers and more
      • Why Subscribe?
      • Free Access for Packt account holders
      • Instant Updates on New Packt Books
  • Preface
    • What this book covers
    • What you need for this book
    • Who this book is for
    • Conventions
    • Reader feedback
    • Customer support
    • Downloading the example code
      • Downloading the color images of this book
    • Errata
    • Piracy
    • Questions
  • 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
  • 2. Integrating Application Fundamentals
    • Defining the project
      • Changing a windows 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
          • Buttons
          • TextBoxes
          • Labels
          • ComboBoxes
          • ListBoxes
      • 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
  • 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
          • Field properties
            • Object properties
            • Visual properties
          • Linking prompts
          • Linking lookup buttons
        • Composite
        • Table
        • Form and window
          • Window properties
            • Object properties
            • Visual properties
        • Scrolling window
          • Creating a scrolling window
          • Scrolling window properties
            • Object properties
            • Visual properties
          • Adding fields to a scrolling window
    • Navigating the Resource Explorer
      • Worksets
    • Summary
  • 4. Building the User Interface
    • Overview
      • Workset
    • Base resources
      • Data types
      • Format
      • Fields
    • Creating tables and keys
      • Tables
        • Customer Contact Master
          • Table keys
        • Contact Phone Master
          • Table keys
        • 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
        • • Global fields
          • Window text properties
          • Global field properties
          • Local fields
        • New scrolling window
      • Lookup form and window creation
      • Window fields
    • Scrolling windows
    • Working with window fields
      • Adding static text
        • Column headings
    • Summary
  • 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
          • Script analysis
        • 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
          • Calling the lookup form
          • Defaulting the double-click
      • Editable windows
        • Line events
          • LineFill
          • LinePre
          • LineChange
          • LinePost
          • LineInsert
          • LineDelete
      • 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
  • 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
  • 7. Creating Customizations with Modifier
    • Overview of Modifier
      • Two tools in one!
    • Modifying windows and window fields
      • Launching the 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
          • Change the window title
          • Change the text prompt
          • Change the static text of a checkbox
          • Add a dividing line
          • Adding a tool tip
        • Adding or changing graphic elements
          • Adding a new picture
          • Changing the Picture
    • Changing global resources
      • Pictures and native pictures
      • Strings
      • Formats
      • Data types
      • Messages
    • Summary
  • 8. Creating Customizationswith 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
  • 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
          • Task: Item Number field
        • Go To: Item transaction inquiry
          • Task 1: Item Number field
          • Task 2: (L) Display Options field
          • Task 3: (L) Display By field
          • Task 4: (L) Start Location field
          • Task 5: (L) End Location field
    • Granting security to a SmartList Builder object
    • Excel Report Builder
    • Drill Down Builder
    • Extender
      • Overview
      • Extender editions
        • Extender Standard
        • eXtender Enterprise
        • Working with Extender
          • Event form project
            • Field 1: Event Type field
            • Field 2: Catering Company field
            • Field 3: Rental Company field
            • Field 4: Rental Location field
            • Field 9: Customer field
            • Field 10: City field
            • Field 1, Column 2: Event Location field
            • Creating the City Lookup object
            • Extra windows
            • Extender menu
          • Customer window group
          • Customer contacts
          • Line item note
    • Summary
  • 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
          • ButtonType on dexButtonProvider
          • AutoSetDexColors
        • TextBox
          • AutoSetDexColors
        • Label
          • LinkField on dexLabelProvider
        • RadioButton and GroupBox
        • ComboBox
          • Style
          • AutoSetDexColors
    • 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
  • 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
  • Index

pokaż cały spis treści

ukryj recenzje