Microsoft Dynamics GP ConsultingMicrosoft Dynamics GP, previously called Great Plains, offers small and midsize businesses a wealth of advanced, ready-made solutions for managing core areas such as finances, operations, human resources, and manufacturing. Because of its tight integration with key Microsoft technologies including Active Directory and Azure AD, SQL Server, SharePoint, plus Office and Office 365, and because its architecture is based on Microsoft's .NET Framework, Dynamics GP's out-of-the box functionality can be seamlessly incorporated into virtually any Microsoft-based IT environment to maximize the platform's business value.

For organizations who want to gain competitive advantage by building a business management system that goes outside the box, the open architecture of Dynamics GP offers ample support for custom application development. A broad range of development tools are available to create specialized applications and integrations for Dynamics GP. Progent's expert solution designers and software developers can help your business build enhancements to Dynamics GP that address the unique needs of your business while retaining the advantages of Windows integration and connectivity.

Overview of the Microsoft Dynamics GP Architecture
The Dynamics GP runtime engine was built with the Dexterity development tool, which was created with Microsoft Visual Studio. Microsoft's .NET Framework allows Dynamics GP to provide an enhanced Windows interface for users and offer .NET and VBA technologies for application developers and data integrators. Application data for Dynamics GP is stored and managed by Microsoft SQL Server, delivering advanced performance, login security, transaction integrity, job scheduling, and scalability. Dynamics GP 2015 R2 introduced a new Service Based Architecture (SBA) that provides a REST-style application programming interface (API) to replace the previous SOAP protocol for browser-based access to cloud-hosted Dynamic GP applications. The new SBA design provides more stable connections, better security including end-to-end SSL encryption, transparent scale out and multi-tenancy, plus support for HTML 5 https protocol to facilitate the creation of cross-platform applications for Windows, iOS and Android devices.

Dynamics GP's open architecture makes it easy for end users and system administrators to customize Windows layouts, forms, and reports while providing a familiar environment for programmers and third-party developers to add new functionality and connect with virtually any data source. Progent's Microsoft-certified software developers can help you enhance your Dynamics GP system by providing services that range from customizing management reports to creating powerful line-of-business applications that significantly extend the capability of Dynamics GP.

Tools Available for Customizing Dynamics GP
Development tools for Dynamics GP cover reporting, intranet portals, and integrations. Reporting tools available for Dynamics GP include Report Writer, Microsoft Dynamics GP Analysis Cubes for Excel, Microsoft Dynamics GP Analytical Accounting, Microsoft Enterprise Reporting, Crystal Reports Professional, Microsoft FRx Professional, Microsoft SQL Server Reporting Services (SSRS) for Microsoft Dynamics GP, SmartList, and SmartList Builder. For a description of Progent's consulting services for creating custom Dynamics GP reports, see Microsoft Dynamics GP Reporting Services.

Business Portal for Microsoft Dynamics GP is a web-based application that allows you to create or extend your company intranet and provide users with safe and convenient access to Microsoft Dynamics GP information as well as to any other browser-based applications that use Business Portal. Many of the Business Portal's features including document libraries, lists, announcements, links, and alerts are provided by Windows SharePoint Services. Progent's Dynamics GP developers and SharePoint experts can help you use Business Portal to create custom queries and reports. For information about Progent's SharePoint consulting expertise, see SharePoint Consulting Services.

Progent can also provide expertise with a variety of development tools that can be used to create user-interface integrations and database integrations with Microsoft Dynamics GP. These integration tools include Dexterity, Modifier with VBA, Visual Studio Tools for Microsoft Dynamics GP, Continuum, Extender, eConnect, Web Services for Microsoft Dynamics GP, Integration Manager, and ODBC.

Tools for Developing Custom Integrations for Dynamics GP
Tools that can be used for Dynamics GP integrations allow you to carry out a variety of projects such as exchanging data with external databases, modifying the appearance of Dynamics GP windows or creating new ones, using specific .NET controls for a new window, integrating with Microsoft Dynamics GP navigation and lists, and synchronizing Microsoft Dynamics GP data with an external system. Some of the available tools can be used by non-programmers including authorized end users, while others require experience in developing applications within a Microsoft environment.

Progent can help you decide what integration tools are appropriate for your customization project, show you how to use relevant tools that are within your skill set, and provider application design and programming services for projects you do not wish to tackle with in-house resources.

Application Integration Tools for Dynamics GP
Multiple tools are available for end users and software developers to create application integrations for Dynamics GP. Progent offers consulting support for all these tools including Dexterity, Modifier with VBA, Visual Studio Tools for Microsoft Dynamics GP, Continuum, and Extender.

  • Dexterity
    Microsoft Dynamics GP was created with the Dexterity development environment. Integrations written with Dexterity work transparently with Dynamics GP and can use Dynamic GP's trigger system for event notification. Dexterity is the only development tool that can create integrations containing new commands for menus, toolbars, and actions in Dynamic GP's list action panes. Dexterity includes a graphical forms designer, a scripting language with an integrated debugger, a comprehensive function library, structured exception handling, COM support, integrated source code management with support for Microsoft Visual SourceSafe or Team Foundation Server (TFS), and a built-in Report Writer.
  • Modifier with VBA
    The Modifier with VBA, included with each Dynamics GP client, is a GUI environment that makes it easy and safe for end users to modify the Dynamics GP interface through customizations such as rearranging windows elements, hiding fields, or changing graphic images/ and message text. VBA in Microsoft Dynamics GP includes the familiar Visual Basic syntax used in Microsoft Office products and offers additional features that allow advanced users to create new windows, add business logic to windows and reports, and create VBA forms that add new capabilities to Dynamics GP. Integrations made with Modifier can be deployed via package files.
  • Visual Studio Tools for Microsoft Dynamics GP
    Visual Studio Tools for Dynamics GP offers software developers the managed code environment of Visual Studio and all the features of the .NET Framework to create integrations for Dynamics GP. Developers can create native .NET forms that have the look of standard Dynamic GP windows and can incorporate any available .NET control. Developers have access via .NET code to windows, fields, tables and other Dynamic GP application resources, including fields created by Modifier. Developers can also register for events occurring in windows, fields, and other resources so .NET code can be triggered by user actions. Integrations can be easily deployed by copying them to the Addins folder.
  • Continuum
    Continuum gives developers access to the COM interface for Dynamics GP and, as its name suggests, is useful for creating integrations with legacy applications created with older development tools such as early versions of Visual Basic. Limitations in the integration capabilities of Continuum/COM often require developers to use pass-through scripts with Dexterity's sanScript scripting language to provide the required functionality for integrations.
  • Extender
    Extender is designed to make it easy for non-programmers to create new Dynamics GP windows for entering data into additional fields. The new windows created with Extender can feature lookups and shortcuts, have additional window types such as Notes and Inquiries, and can accept imported data. Extender also allows users to design views that combine Dynamic GP windows with Extender windows for creating reports with external reporting platforms such as SQL Server Reporting Services or Crystal Reports.
Data Integration Tools for Dynamics GP
Dynamics GP offers a variety of technologies that can be used in parallel to import and export data managed by the Dynamics GP SQL Server. The key data integration tools for which Progent can supply support are eConnect, Web Services for Microsoft Dynamics GP, Integration Manager, and ODBC. The relationship of these integration technologies with the SQL Server is illustrated below:

Dynamics GP Data Integration Consulting

  • eConnect
    eConnect, which is installed on the SQL Server used for managing Dynamics GP's data, is a set of stored procedures for reading, writing, and validating data in Dynamic GP's tables. eConnect can provide real-time back-office data to new or existing applications such as web storefronts or customer service software. eConnect uses XML documents with a defined schema for each class of document to be imported from or exported to Dynamics GP. The programming interfaces included with eConnect are BizTalk Adapter, eConnect .NET Assembly, Microsoft Message Queue (MSMQ), and directly accessible SQL Stored Procedures. Web Services for Microsoft Dynamics GP and Integration Manager both rely on eConnect as their data access platform.
  • Web Services for Microsoft Dynamics GP
    Web Services for Microsoft Dynamics GP is based on Windows Communication Foundation (WCF) and uses eConnect to provide real-time web-based access to Dynamics GP data via standard Internet transport protocols and XML-based document formats such as Simple Object Access Protocol (SOAP). Web services allows applications integrated with Dynamics GP to retrieve, create, modify, remove, or void the system's primary documents, which include customers, vendors, purchase and sales documents, payables and receivables transactions, general ledger transactions, and accounts.
  • Integration Manager
    Integration Manager is a separately licensed, standalone graphical application designed to make it easy for non-programmers to import data into Dynamics GP from different sources such as Excel or text files. Features such as graphical data mapping, data validation, data defaulting, and batch imports simplify the task of importing external data into Dynamics GP objects such as a Sales Order Processing document. For power users, Integration Manager supports scripting with VBScript, which allows users to attach scripts to events that occur during the integration process to handle complex import tasks.
  • ODBC
    Dynamics GP data managed by SQL Server can be securely accessed via the industry-standard ODBC (Open Database Connectivity) interface, which is used by popular reporting applications such as Crystal Reports and Microsoft Query. Using the ODBC interface to write data to the Dynamics GP database requires in-depth knowledge of the Dynamics GP database and table structures because ODBC bypasses the eConnect interface and performs no data validation on its own.
Download Progent's Microsoft Dynamics GP/Great Plains Consulting Datasheet
To download a datasheet describing the consulting support available from Progent for Dynamics GP/Great Plains, click Download Microsoft Dynamics GP/Great Plains Consulting Datasheet (PDF file).

Contact Progent for Microsoft Dynamics GP Consulting and Programming Support
If you are looking for a Microsoft Dynamics GP/Great Plains application consultant, phone 1-800-993-9400 or visit Contact Progent.

© 2002- 2019 Progent Corporation. All rights reserved.

More topics of interest:

An index of content::

Award Winning Consultant Services for Great Plains Accounting Des Moines Microsoft Exchange Server 2013 Consulting Service Montgomery
BlackBerry BES Server Small Business Computer Consulting Group BlackBerry BES Server Network Consulting Services
BlackBerry Desktop Manager Computer Consultation Networking Services Orlando-Kissimmee
BlackBerry Email IT Consulting BlackBerry Exchange Outsourcing Technology in Wichita, Sedgwick County
BlackBerry Smartphone Outsourcing IT Support System Recovery
BlackBerry Synchronization Guru Tucson Arizona BlackBerry Consulting Service Firm
Burlingame Network Specialists Half Moon Bay Migration Support Northern California
Burlington, Vermont Computer Consulting Group Vermont PC Consulting
CISSP Engineer Job Microsoft MCSA Consultant Telecommute Job Southern California San Diego
Chesapeake Support Consultants IT Service Providers for Chesapeake, Virginia
Cisco CCSP Network Engineer Career Opportunities Microsoft MCTS Consultant Full-Time Jobs Washington DC
Cisco Consulting Company Information Technology Outsourcing in Tarrant County Texas
Cisco Information Technology Management Cisco Computer Network Support Firms Denver Colorado
Cisco Information Technology Outsource Cisco Recovery Services
Cisco Maine IT Technical Support Company Portland, ME, Lewiston, ME, Bangor, ME, New England Technology Providers
Cisco and Microsoft Certified Birmingham Alabama Networking Group Support Outsourcing for Birmingham, Jefferson County, Alabama
Cisco and Microsoft Certified Expert Denver, Colorado Engineers Consulting Service Firm
Citrix Virtual Application Consult Citrix XenServer Remote Troubleshooting
Colo Consultancy Services Company Colocation Support Company in Essex County New Jersey
Colorado IT Consulting Firm Denver, Colorado System Recovery
Colorado Network Setup Denver Colorado Consulting Firm
Colorado Small Business IT Outsourcing Firm CCIE Expert Certified Colorado Integration Consultants
Computer Consultant Job Openings Microsoft MCDBA Remote Support Part Time Job in Fort Wayne, Allen County
Computer Engineer Home Based Jobs Contract Job Opportunities for Microsoft MCP Support
Computer Network Support Companies for Windows Server 2012 R2 Windows Server 2019 Network Architect Firms
Computer Specialists Remote Support Services for Gilroy
Computer Support Consultants for Ohio IT Consulting Group
Computer Support Help Desk IT Services Virtual Help Desk On-site Support
Computer Support Job Microsoft MCITP Engineer Full-Time Jobs in Oakland, Alameda County
Computer Tech for Cisco Cisco Network Solutions Baton Rouge, LA
Consolidate for BlackBerry BES BlackBerry Email Network Consultant Fulton County Georgia
Consult Cypress, CA Help Desk Consulting Service in Arlington
Consultancy for Dynamics GP Customization Tracy, CA Microsoft MCITP Support Work From Home Job
Consultancy for Dynamics GP Visual Studio Glendale, AZ Worldwide Cisco Computer Support For Small Offices
Consultancy for SQL 2012 Computer Consulting Company for SQL Server 2012 Toledo Ohio
Consultant New York City, NY Integration Support for Linux
Consultant Services for Dynamics GP Customization in Anchorage, AK BlackBerry Redirector Upgrading Omaha Council Bluffs
Consultant Services for Solaris Online Sun Solaris Online Specialists
Contract Job Freelancing Job for Help Desk Consultant in Livermore
Cupertino Computer Network Specialists Award Winning Sunnyvale Security Consulting Companies
Data Center Colocation Online Technical Support Small Business Server Support for Data Center
Datacenter Monitoring Support SCOM 2012 Cloud Monitoring Computer Consultants
Denver, CO Small Business Network Support Denver, Colorado Design Firm
District of Columbia Dynamics GP Software Development Specialists Cisco Migration Consultants
Dynamics GP BizTalk Adapter Consult Omaha Cisco System Consulting Services Iowa - Des Moines, IA, Cedar Rapids, IA, Davenport, IA, Sioux City, IA
Dynamics GP Continuum Professional in Norfolk, VA Security Security Organizations in New York City New York
Dynamics GP Custom Software Computer Consultants Job Opportunity for Help Desk Engineer Monterey California
Dynamics GP Custom Software Consultant San Francisco Exchange Server 2007 Network Specialists in Durham, NC
Dynamics GP Custom Software IT Consultant in Alameda County Cisco Systems Support Cheyenne, Wyoming
Dynamics GP Modifier Consultancy Linux Help and Support in Hawaii
Dynamics GP Modifier Consultant Services in Buffalo Security Computer Security
Dynamics GP ODBC Consulting Services in Denver, CO Microsoft Network Support Service for San Jose
Dynamics GP ODBC Professional San Francisco Computer Tech for Exchange 2003 Server in Seattle Redmond Bellevue
Dynamics GP Software Development Computer Consultants in Milwaukee Design Consultants for SQL Server 2012
Dynamics GP Software Specialist Great Plains Migration Network Consultant
Dynamics GP VBA Consulting Services in Napa Small Business IT Consultants for Cisco Austin
Dynamics GP VBA Engineer Buffalo, New York Microsoft SharePoint Server Help and Support Phoenix Arizona
Dynamics GP Visual Studio Technology Professional Toledo, OH Integration Support for Redhat Linux, Sun Solaris, UNIX Glendale
El Paso, TX Dynamics GP Integration Manager Professionals Linux Setup and Support
Engineer SharePoint 2010 On-site Support Buffalo, NY
Engineer for Gentoo Linux, Solaris, UNIX Top Mandrake Linux, Sun Solaris, UNIX Network Consulting
Engineer in Mobile, Alabama Nationwide Columbus, Cleveland, Cincinnati, OH Information Technology Consulting
Exchange 2003 Server On-Call Services Integration Specialists for Microsoft Exchange 2016 Caddo Parish Louisiana
Exchange 2016 Consulting Services Company Honolulu Hawaii Microsoft Exchange 2010 Outsourcing Technology
Exchange Server 2000 Professionals Exchange 2007 Configuration
Exchange Server 2007 Technology Consulting Company Service Providers for Exchange 2016 Augusta, Richmond County
Fault Tolerant Branch office Network Specialist High-Availability Interoffice Connections Consulting
Firewall Support for Firewall Security Computer Security Colorado
Fort Worth, Texas Solution Providers Best Microsoft Small Business Computer Consulting Services for Houston, Texas
Full Service Outsourcing Consultant IT Outsourcing Consultant
GIAC Web Application Security (GWAS) Professionals Cisco Certified Design Associate (CCDA) Contractor
Great Plains Accounting Specialist in Los Angeles, California Battery Park, New York City Professionals
Hayward Migration Companies Implementation Services Northern California
Help for Omaha Omaha, NE Small Business Server Support
IT Consultants for New York, New York Integration Companies for New York
IT Consultants for SharePoint Server Online Consulting for Microsoft SharePoint Server in Ontario
IT Outsourcing Configuration Services Network Consulting Firm Monterey, CA
Information Technology Consulting for CISSP CISSP Security Firms Connecticut
Integration Firm Outsourcing IT
Jackson, Gulfport, Biloxi, MS Tech Support Outsource Jackson Mississippi Tech Outsourcing
Jacksonville, Miami, Saint Petersburg, FL Experts IT Outsourcing Company
Job Opportunities for MCSE Engineer Microsoft MCA Consultant Telecommuting Job in Omaha Nebraska
Juniper Technical Support Services Juniper Routers Network Security Evaluation
Lincoln, Nebraska IT Outsourcing Group Server Setup for Lincoln
Los Angeles, CA Integration Consultant Cisco Expert California - Los Angeles, CA, San Diego, CA, Long Beach, CA, Fresno, CA Technical Support Organizations
Los Gatos Network Engineer Silicon valley Consultancy Firm
MCSE Consultant Part-Time Job Contract in Palo Alto, Santa Clara County
MCSE MCSA MCDBA MCIPT MCA Support Contractor Jobs Telecommute Job for ISSAP Engineer in Denver Colorado
MCSE MCSA MCDBA MCIPT MCA Support Telecommute Jobs Cisco CCVP Support Telecommute Jobs San Diego County California
Mandrake Linux, Solaris, UNIX Technical Support Local Red Hat Linux, Sun Solaris, UNIX Network Consultant
Massachusetts IT Consulting Microsoft, Cisco and Security Certified Experts Boston, MA, Worcester, MA, Springfield, MA, Lowell, MA, Cambridge, MA System Recovery
Mertztown, PA Services BlackBerry Synchronization Network Specialists in Burlingame, CA
Microsoft Certified Dynamics GP Customization Consultancy in Roseville, CA Microsoft SQL 2008 Computer Outsourcing in Shreveport Louisiana
Microsoft Certified Great Plains Accounting Consultant Services Exchange 2016 Help Toledo, OH
Microsoft Certified Remote Support Home Based Jobs Network Security Consultant Full-Time Job Los Angeles
Microsoft Certified San Francisco Computer Installation Bay Area Consulting Organization
Microsoft Dynamics Developer Firms in Los Angeles, CA Florida Network Engineers
Microsoft Exchange 2016 Consulting Services Remote Support NYC
Microsoft Exchange Server 2013 Server Migration Specialists Support Organizations for Exchange Server 2010
Microsoft Expert Dynamics GP Modifier Specialists Emergency Phone Support Network Security Consulting
Microsoft Expert Migration Companies for Bay Area Bay Area IT Consultants
Microsoft LCS Server IM Support Consultancy
Microsoft MCITP Consultant Part Time Jobs Part-Time Job Grand Rapids, Kent County
Microsoft Remote Monitoring and Reporting Integration Support MOM 2007 Professional
Microsoft SQL Server 2016 Computer Network Specialists Microsoft SQL Server 2017 Migration Westwood,
Microsoft SQL Server 2017 Network Administration SQL Server 2012 Implementation Support in Detroit, Wayne County
Microsoft SharePoint 2010 Online Support Microsoft SharePoint 2010 Network Consultant
Microsoft SharePoint 2010 Support Outsourcing Microsoft SharePoint Server 2013 Specialists in El Paso Greater Ciudad Juarez
Microsoft Windows Networking Firm Microsoft and Cisco Small Business IT Support Firms Bridgeport, CT
Monterey County Networking Group Seaside Network Consultant Northern California
Network Engineers for Aptos Santa Cruz Network Support Companies Northern California
Network Recovery for Exchange Server 2013 Microsoft Exchange 2010 Consultant
New York City- Manhattan, The Bronx, Brooklyn, Queens, Staten Island Small Business Network Consulting Companies Network Designers
On-site Support for Cisco Networking Support for Cisco Massachusetts
Online Consulting for Microsoft ERP Customer Relationship Management Support Services
Online Technical Support Engineer for Slackware Linux, Sun Solaris, UNIX Corpus Christi, South Texas
Parkway Server Integrators Galt Recovery Services in Northern California
Phoenix, AZ, Tucson, AZ, Mesa, AZ, Glendale, AZ, Scottsdale, AZ, Chandler, AZ Experts Arizona - Phoenix, AZ, Tucson, AZ, Mesa, AZ, Glendale, AZ, Scottsdale, AZ Network Installations
Private Cloud Hosting for Virtual Data Centers Consulting Services Virtual Machine Hosting Professional
Professional Phoenix, Arizona Consolidation
Redhat Integration Services Solaris Support Outsourcing in DC
Redhat Online Support Services Support Services in Billings, MT, Missoula, MT, Great Falls, MT, Bozeman, MT
Redhat Setup and Support Troubleshooting California
Remote Access Integration Support Outsourcing
Remote Support Job for Microsoft MCDBA Consulting Job in Boston Cambridge
SQL Server 2016 Small Business IT Outsourcing Company Computer Service Companies for Microsoft SQL Server 2016 in Marion County Indiana
San Rafael Network Services Sausalito Information Technology Manager in California
San Ramon, CA Services for Dynamics GP Integration Manager Exchange 2003 Server Networking Company in Denver, CO
Santa Cruz County Computer System Consultant Santa Cruz County Consultancies
Sarbanes Oxley Compliance Engineer Cisco Experts Office Move Engineers
Security Audits for Security Security Firewall Audit in Bel Air
Security Consultant for Firewall Virginia CISSP Security Services
Security Consulting Companies San Carlos Support Group California
Security Contractor for Firewall Security Firewall Network Install Boston Cambridge
Security Firewall Configure Security Network Consulting Baltimore Towson
Setup and Support for Ubuntu Linux, Solaris, UNIX Gentoo Linux, Solaris, UNIX IT Consultant
SharePoint Server 2010 Network Consultant Louis Armstrong Airport MSY SharePoint Integration
SharePoint Server 2010 Online Help Rochester, NY Microsoft SharePoint IT Services
SharePoint Server 2010 Support Outsourcing SharePoint 2010 Support and Help in Washington DC
SharePoint Server 2010 Technology Consulting Services Microsoft SharePoint Server 2013 Consultants Raleigh North Carolina
Skype for Business video conferencing Consultant Consultants
Slackware Linux, Sun Solaris, UNIX Remote Troubleshooting Fedora Linux, Sun Solaris, UNIX Network Consultants Dallas
Small Business Computer Consulting Companies Cisco Information Technology Outsourcing Group
Small Business Network Consulting Tech Consultants for San Diego
Small Office Computer Consultants for Fremont Newark Security Consulting Companies
Small Office IT Consultant for Lubbock, Texas Small Office Network Consultant
Software Consulting Firm SQL Server 2012 System Consultant in Chesapeake, VA
Software Consulting Firm for Cisco Cisco Computer Support For Small Offices in Phoenix Arizona
Software Outsourcing Consultant Los Angeles, California Server Support
Solano County Network Services Fairfield Experts
South Dakota Technical Firms South Dakota Migration Company
Spokane, WA IT Outsourcing Group Spokane, WA Solution Providers
Sunnyvale Network Design Consultant Cisco and Microsoft Certified Expert San Jose Network Consulting Group
Suse Linux, Sun Solaris, UNIX Setup and Support Suse Linux, Sun Solaris, UNIX Information Technology Consulting in San Diego
Technology Consulting for Microsoft Dynamics GP Technology Consulting Company for Bay Area California
Windows Security Small Office Network Consultants Small Business IT Support Firms for IT Outsourcing in Rockford
Windows Server 2016 Computer System Consultant Small Business IT Consulting Companies for Windows 2008 Server
Windows Support Firms Windows 2008 Server Remote Support Scottsdale, Maricopa County
ransomware preparedness assessment Specialists ransomware protection and recovery Consultant
scom 2016 hybrid cloud monitoring IT Consultants Network Consultants for scom 2016 management servers