Dexterity: Accessing a form menu from a global script

Every so often, a developer might need to check or set the status of a form level menu item.  Say, for instance, the goal would be to make sure that the “Add Item” menu item of the Sales Transaction Entry Options menu was checked. From a global procedure – your trigger handling script most likely –…

3

Season’s Greetings 2008

As you read this post, I will be celebrating Christmas with my family. I would like to take this opportunity to wish everyone in the Microsoft Dynamics GP community a Merry Christmas. For those of you who don’t celebrate Christmas, I wish you a safe and happy time. Take this period to spend time with…

2

Upcoming Developer Workshops

Happy Holidays to all the GP Developers that continue be active readers of the Developing for Dynamics GP blog. I am posting today to make everyone aware of a couple of upcoming developer tools workshops that my team will be performing in the coming months. Emily Halvorson and Dave Dusek from my team are currently scheduled to…


Welcome to the Dynamics Confessor Blogspot

Another one of the Microsoft Dynamics GP MVPs has just created a blog. So welcome to the blogsphere, Leslie Vail and the Dynamics Confessor Blogspot. Leslie is asking for topics, so please go visit her site and put in your requests. I have also added the link to the Microsoft Dynamics GP Blogs page and to the Blog…

2

How can I get access to PartnerSource & CustomerSource

You have probably noticed the padlock icon  next to many of the links on this blog. This icon signifies links which require access to PartnerSource or CustomerSource. You will find that many Knowledge Base articles, Tools, Software Development Kits (SDK), Product Releases and Service Packs are all protected in these secure areas. To get access to…

9

Support Debugging Tool Build 10 released

Some of you might know that I have been busy working on the next build of the Support Debugging Tool for Microsoft Dynamics GP. If you did not know… well… you do now. I have a wish list of features based on feedback from colleagues and the partner community as well as my own ideas for enhancements….

11

DDB.exe: The forgotten tool

Back in the distant past when Great Plains Dynamics only ran on Ctree and Btrieve (which became Pervasive.SQL), accessing raw data was extremely difficult.  There were ODBC drivers, but they were difficult to use (Btrieve required DDF files generated and Ctree was read-only). Then a tool call DBrowser was created. This tool used DDE (Dynamic…

11

Using an Index File with Dexterity Source Code Control

While many Dexterity developers are now using Source Code Control (usually with Microsoft Visual Source Safe), there are a number of developers that did not know that an index file should always be used with Source Code Control. This post explains how Microsoft Dynamics GP developers can use an Index File with Dexterity Source Code Control…

6

Dexterity 10.00.0320 crashing when checking in to Source Code Control

It has come to my attention that there is an issue which can occur with Dexterity 10.00.0320 (Service Pack 3) when checking in resources to Dexterity Source Code Control (Generic Repository or Microsoft Visual Source Safe). If you check in more than one resource at a time, Dexterity crashes. To resolve the issue, please re-install…

1

Where did David go?

Hello all I just wanted to let you know that I will be taking some Annual Leave from the 13th December through to the 5th January.  I am taking this time to have a break and go on holiday with my family. Due to the magic of technology, I have written some blog articles that…

4

How to Set the Tab Sequence

The following article describes the methods for setting up the tab sequence for fields in a window using Dexterity or Modifier.  It also provides methods for handling overlaid fields such as radio buttons. Before we start setting the tab sequence we need to do a little preparation first: For any field that is non editable,…

7

Updated Blog Addresses

Hi everyone Just a quick note to let you know that a couple of Microsoft Dynamics GP related blogs have changed their addresses.  Here are the details: Mohammad Daoud at Mohammad Daoud (now at http://mohdaoud.blogspot.com/)  Vaidy Mohan at Dynamics GP – Learn & Discuss (now at http://www.vaidy-dyngp.com/) I have updated the Microsoft Dynamics GP Blogs page…

0

Identifying Duplicate Transactions

From the Useful SQL Scripts Series. Because Microsoft Dynamics GP is designed to have separate tables for WORK, OPEN and HISTORY transactions, there are times where it is possible for a transaction record to exist in more than one table.  This is usually the result of an error or interruption. These duplicate records become an issue when…

21

Releasing Stuck Batches and Transactions without exiting all Users

From the Useful SQL Scripts Series. When a system has a batch that is stuck as marked to post or a transaction that cannot be accessed as it says it is already being edited, the usual instructions are to exit all users from the system and then delete the contents of the activity tracking, and Dexterity session and lock tables. These…

12

Welcome to the GP2theMax Blog

It seems that the blog bug is spreading. Another one of the Microsoft Dynamics GP MVPs has created a blog. So welcome to the blogsphere, Frank Hamelly and the GP2theMax Blog. I have also added the link to the Microsoft Dynamics GP Blogs page and to the Blog Links on the left hand pane of the…

1

spSearchOnAllDB: SQL Stored Procedure to Search an Entire Database

From the Useful SQL Scripts Series. This stored procedure, originally written by Oufimtsev Gleb from Moscow, allows you to search all columns in all tables in a database for the occurrence of a particular string or value.  Wild card characters such as those supported by the LIKE keyword can be used. For example: _ to wild card a…

18

Useful SQL Scripts Series

After the success of the Microsoft Dynamics GP Application Level Security Series, I have decided to release a another series which contains some really useful SQL scripts I have collected over time. The posts in the series (so far) include: 01-Dec-2008: spSearchOnAllDB: SQL Stored Procedure to Search an Entire Database   03-Dec-2008: Releasing Stuck Batches and Transactions…

14

All about the Dexterity OLE Container

Over the years, the question of how to interact with the Microsoft Dynamics GP OLE Notes from outside the application has been raised many times. I have responded to newsgroup posts with information that would hopefully lead the developers in the right direction. Well now, all I need to do point them to Mariano Gomez’s…

1

How to retrieve Quantity On Hand amount using Web Services for Dynamics GP 10.0

This post is due to requests I have come across in the past and very recently in a support incident.  The question raised was how to retrieve quantity amounts like Quantity On Hand for inventory items?  This Visual Studio 2005 (C#) sample shows how to retrieve the Quantity On Hand value for an Inventory Item. …

1