Microsoft Dynamics GP Developing for Dynamics GP
A blog dedicated to the Microsoft Dynamics GP Developer & Consultant community		  
Welcome to MSDN Blogs Sign in | Join | Help

Developing for Dynamics GP

by David Musgrave (Australia) and the Microsoft Dynamics GP Developer Support Team (USA)

News

  • Please use the Blog Feedback? - Contact Us link at the top of the page to email questions relating to the blog itself.

    If you wish to ask a technical question, please use the links below to ask on the Newsgroups. If you ask on the Newsgroups, others in the community can respond and the answers are available for everyone in the future.

    Please do not use comments on pages and posts to ask questions unrelated to the topic on that page or post.


    Dates of Interest:

    11-Jul-2008: Blog Created by David Musgrave.
    10-Oct-2008: First Post by Scott Stephenson.
    04-Nov-2008: First Post by Dave Dusek.
    11-Nov-2008: First Post by Beth Gardner.
    28-Nov-2008: First Post by Chris Roehrich.
    30-Dec-2008: First Post by Patrick Roth.
    24-Feb-2009: First Post by Greg Willson.
    22-Apr-2009: First Post by David Clauson.
    04-May-2009: First Post by Ryan Wigestrand.
    19-Jun-2009: First Post by Dawn Langlie.
    03-Jul-2009: First Post by Emily Halvorson.


    WorldMaps Statistics since
    24-Feb-2009:




    Translator Tool:



    Disclaimer

    This blog is provided "AS IS" with no warranties, and confers no rights.

    The links in this blog may lead to third-party Web sites. Microsoft provides third-party resources to help you find customer service and/or technical support resources. Information at these sites may change without notice. Microsoft is not responsible for the content at any third-party Web sites and does not guarantee the accuracy of third-party information.

Contents

Favourite Posts

Blog Links

Newsgroups Links

Resources Links

Dex - How to get started with Dexterity

David MeegoSomething I am often asked is how to get started with Dexterity.  As Dexterity is not really known outside of the Microsoft Dynamics GP world, there are not a large number of books available on the subject, like there are for Visual Basic or Visual C#.

Note: if you are still unsure about which tool or tools is best for you, please see the Choosing a Development Tool post.

So what is the best place to get started.  Below are the steps I suggest.

NOTE: All the articles and links I refer to can be found on the Dexterity Articles & Links page of this blog.

  1. Install Dexterity
    Either from the \Tools\Dex\Setup folder of CD 2 of the Microsoft Dynamics GP install CDs or downloaded from CustomerSource (link at bottom of this page). Follow the steps in KB 949622 (link at top of this page) to set up the development environment.

  2. Read the Manuals
    Dexterity installs manuals in a Manuals folder.  They can also be accessed from the Help menu inside Dexterity. I suggest that you work through the Quick Start manual, using the Programmer's Guide Volumes 1 & 2 for reference.  You should also browse through the sanScript Reference and the Function Library Reference to get familiar with what commands and functions are available. The Integration Guide explains how to write integrating applications and how to re-use all the navigation and security facilities inside Microsoft Dynamics GP.

  3. Do the Training
    The Dexterity Fundamentals training (now called Dexterity I) is an excellent start to getting the foundations needed for all Dexterity developers.  The materials can be downloaded from CustomerSource (link at bottom of this page).  While this training can be completed as self study, nothing beats getting trained by an instructor in the classroom.  Every now and then Microsoft offers training courses for Dexterity (I trained one in Melbourne, Australia in late 2007). I will update the blog when I hear of courses. 

    Your other choice for classroom training in the USA is to attend one of Leslie Vail's classes run through Integrated Business Group Training Courses. Leslie runs the Dexterity I and less known Dexterity II classes. See the bottom of this article for links to training courses.

  4. Check out the Samples
    There are a number of samples provided with Dexterity and also available for download from CustomerSource or the MSDN Dynamics GP Developer Center. The links are on the Dexterity Samples page of this blog. Look at and play with the samples as they will help you learn.

  5. Use the Help File
    Press F1.... The Dexterity help file is a brilliant resource for all things Dexterity.  Use it. 

  6. Read the articles 
    The Dexterity Articles & Links page on this blog has links to great Knowledge Base (KB) articles as well as conference materials on advanced techniques, such as cross dictionary and multi-dictionary development.

  7. Use the Newsgroups
    There is a list of links for Newsgroups on the left hand section of this blog.  The Microsoft Dynamics GP Developer newsgroup is an excellent resource.

  8. Use the Tool
    Get the hands on experience. The best way to learn is to actually get down and create some Dexterity windows and write some sanScript code. It is recommended that you start with a small integration or customisation project first. Learn to walk before you run.  Completely changing the behaviour of the SOP_Entry window is not recommended as your first project.

  9. Use the SDK (Software Development Kit)
    The SDK can be installed from the Tools folder of CD 2 of the Microsoft Dynamics GP install CDs or downloaded from CustomerSource or the MSDN Dynamics GP Developer Center (links on the Developer Articles & links page). The SDK contains vast amounts of information on the data model and transaction flows as well as documentation on procedures and functions that can be re-used.

Please add your comments on your experiences or advice you can give to new Dexterity developers.

David

27-Aug-2008: Integrated Business Group & Leslie Vail are offering Dexterity training in Orlando in October.  See here for more information Dexterity Training in Orlando (Oct 20th to 24th).

24-Apr-2009: Added link to Choosing a Development Tool post.

Posted: Monday, August 11, 2008 12:29 PM by David Musgrave

Comments

David Musgrave said:

Posted for Mariano Gomez:

David,

This is a great step-by-step process for new Dexterity developers. However, I always try to revert back to basics: know thy CRUD operations! Every development language poses that challenge: how to create, read, update and delete records in a table. If you can identify these operations the rest will come easy. Look for my new blog article pretty soon on

Understanding CRUD operations with Dexterity

Of course, I also learned from the best: the former Great Plains Software International Team!!!

MG.-

Mariano Gomez, MVP

Maximum Global Business, LLC

http://www.maximumglobalbusiness.com

# August 14, 2008 9:54 PM

David Musgrave said:

Part 1 of Mariano's posting can be found here

http://dynamicsgpblogster.blogspot.com/2008/08/know-thy-common-table-operations-with.html

# August 20, 2008 3:32 AM

Developing for Dynamics GP said:

This is it. The opportunity to get trained in the Dexterity fundamentals by one of the best trainers

# August 27, 2008 12:45 AM

Jai said:

Hi

Its good article for Dexterity Developer.

Thanks

http://www.interviewsworld.com/SC_7_22_ms-dynamics-gp-10.aspx

# August 28, 2008 4:11 AM

Mark Hayes said:

Hi,

I've been doing battle with the Dynamics site but not getting anywhere in a hurry. It all seems to come back to CustomerSource but I can't work out how to get into it.

Here's the problem. Way back I was a Dexterity developer using version 3 or so thru to 6.5 or so. I developed a range of Dynamics integrated products and some stand-alone.

One of my old customers has a stand-alone still running using 6.00 and they've asked that I make some changes.

So what I want to find out is how to get a current version of Dex (or even an older version) and what is required to run and licence the product these days. I can't seem to find anywhere in Microsoft.com where the simple issue of just buying the product is addressed.

Any help you can offer would be appreciated

# September 3, 2008 12:05 AM

David Musgrave said:

Hi Mark

Please can you use the Email link at the top of the blog so I can get an email address for you.

I am checking what we can do to help you. Normally, you would need to be a registered Partner or Customer to access PartnerSource or CustomerSource where the Dexterity downloads are.

The current version of Dexterity is v10.00 to match Microsoft Dynamics GP 10.0.  You might not want to use v10 as it changes the interface from MDI to SDI. This means that each window shows separately in the taskbar and no longer sit inside the application main window.

David

# September 3, 2008 3:35 AM

David Musgrave said:

Hi Mark

You can still purchase Dexterity as a Customer.

As a Partner, Dexterity is included in the Not For Resale Kit – so, if you signed up as a Partner, you will get an NFR copy of Dexterity.  The code is available on the Microsoft Dynamics GP 10.0 CD #2, and it’s also available for download via PartnerSource.

Dexterity is also available in the Subscriptions area of MSDN.

I hope this helps.

Please use the email link if you have any further questions.

David

# September 3, 2008 8:35 PM

LOW said:

Just want to find out how to create standalone Application without using MSSQL as database in Dexterity v10.

FYI - Since Btrieve & CTree is not being used.

Please advise.

Thanks

LOW

# November 27, 2008 2:20 AM

David Musgrave said:

Hi Low

You will need to edit the Dex.ini to change the default database from SQL to Ctree.

Comment out FileHandler using a semi colon and DatabaseType.

;FileHandler=SQL

DatabaseType=Ctree

As long as any tables you create are set as default database type they will work as ctree.

Make sure you read the Dexterity Manual on Standalone applications (STNDALON.pdf).

David

# November 27, 2008 6:19 AM

KEN said:

Please kindly advise how to create standalone Application using MSSQL as database in Dexterity v10.

If there any procedure on that??? Please advise.

Thanks

KEN

# March 11, 2009 2:45 AM

David Musgrave said:

Hi Ken

Included with the documentation for Dexterity is a Standalone Application Guide (STNDALON.pdf) which explains much of what is needed.

To change the default database to SQL is handled by a DEX.INI setting.

Look for Database and comment it out with a semicolon (;) if it exists and make sure FileHandler is set to SQL:

FileHandler=SQL

Then the system will ask for login on the first access of a SQL table, or you can build your own login window and use the Login_ function library to login yourself (which is how Microsoft Dynamics GP works).

Good Luck

David

# March 11, 2009 6:51 PM
Leave a Comment

(required) 

(required) 

(optional)

(required) 

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Page view tracker