Welcome to 2009 & Backups
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Hello everyone.
Welcome back to work and welcome to 2009.
Dexterity: Accessing a form menu from a global script
This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
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.
How can I get access to PartnerSource & CustomerSource
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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.
Support Debugging Tool Build 10 released
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
IMPORTANT NOTICE: The Support Debugging Tool is now GP Power Tools from Winthrop Development Consultants (https://winthropdc.com/GPPT)
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.
DDB.exe: The forgotten tool
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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).
Using an Index File with Dexterity Source Code Control
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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.
How to Set the Tab Sequence
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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.
Identifying Duplicate Transactions
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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.
Releasing Stuck Batches and Transactions without exiting all Users
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
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.
spSearchOnAllDB: SQL Stored Procedure to Search an Entire Database
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From the Useful SQL Scripts Series.