Winthrop Development Consultants Blog

Do I need access to Microsoft Dynamics GP Source Code?

Posted on 25 January 2009 Posted in Developing For Dynamics GP Tagged with Dexterity, Source Code Program, Support Debugging Tool, Visual Studio Tools 4 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Many times on the newsgroups, I see questions from developers new to Microsoft Dynamics GP along the lines of:

“How can I customize Microsoft Dynamics GP when I don’t have the source code?”

This post discusses the benefits of having access to the Microsoft Dynamics GP source code and explains how it can be used. It also covers how the entire design of Dexterity is such that access to source code is not required to create customisations.

Finding out how to call an existing Report

Posted on 22 January 2009 Posted in Developing For Dynamics GP Tagged with Dexterity, Report Writer, Source Code Program, Support Debugging Tool 5 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Over the years, I have been asked many times how to call a Report Writer report to make it behave the same as if it was called by the original code.

Sending emails with Collaboration Data Objects (CDO) and Dexterity

Posted on 21 January 2009 Posted in Developing For Dynamics GP Tagged with Blogsphere, Dexterity 2 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Mariano Gomez (The Dynamics GP Blogster) has written a great article on using Collaboration Data Objects (CDO) to send emails.

How can I identify the parameters of a Procedure or Function?

Posted on 20 January 2009 Posted in Developing For Dynamics GP Tagged with Cross Dictionary, Dexterity, SDK, Source Code Program, Support Debugging Tool 5 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

One of the great things about Dexterity is that you can develop complex customisations without needing access to the source code. Even if you have access to source code via the Source Code program, a Dexterity developer never actually changes original source code.

“The stored procedure createSQLTmpTable returned the following results: DBMS: 12” exceptions

Posted on 19 January 2009 Posted in Developing For Dynamics GP Tagged with Application, Exception, SQL 9 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Many of inquiry windows in Microsoft Dynamics GP have been optimized to leverage SQL Server to increase performance. This is especially common with transaction inquiry windows which can combine data from more than one table (ie. Work, Open and History).

Passing data from a Business Portal Result Viewer Web Part to Dynamics GP Web Services

Posted on 18 January 2009 Posted in Developing For Dynamics GP Tagged with Business Portal, C#, Chris Roehrich, Developer Toolkit, eConnect, Integration, NDM, Web Services 2 Comments

This is a reposting of an article Chris Roehrich originally wrote on my Developing for Dynamics GP blog.

This post will provide some steps on using the MBF Result Viewer API to pass data to the Dynamics GP Web Services. The specific example shows how you can remove a line item from a Sales Order using the UpdateSalesOrder method. The sales order number, line sequence number, and item number can be pulled off the Rich List Result Viewer web part and passed to the web services.

eOne.Dynamics.GP.ExcelBuilder.Engine.dll Exception

Posted on 14 January 2009 Posted in Developing For Dynamics GP Tagged with Application, Exception, Visual Studio Tools 3 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I have been seeing a number of reports on Newsgroups and Support cases of Add-In Initialization Errors.

In particular, after installing updates or service packs after v10.00 SP2, receiving the following message:

eOne.Dynamics.GP.ExcelBuilder.Engine.dll: Exception has been thrown by the target of an invocation. InnerException: The type initializer for ‘eOne.Dynamics.GP.ExcelBuilder.GPAddIn’ threw an exception.

Hybrid – Adding Named Printers control to Reports using VBA

Posted on 13 January 2009 Posted in Developing For Dynamics GP Tagged with Dexterity, Hybrid, Modifier, Named Printers, VBA 2 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Named Printers is a module to allow controlling of the printer and settings used when printing reports. It was originally developed for v3.00 by me while I was working for Sequel Technology (that’s why the tables and calls are prefixed with ST). Later it was purchased by Great Plains for v5.50 and included in core code (Dynamics.dic) for v6.00 onwards.

Modifier – Reading and Writing Data with ADO Example

Posted on 11 January 2009 Posted in Developing For Dynamics GP Tagged with ADO, Modifier, VBA 3 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

It has been a while since I posted some example code, so here is one which demonstrates how to write back data using ADO.

The Importance of Reporting the first Error

Posted on 6 January 2009 Posted in Developing For Dynamics GP Tagged with Application, Exception 3 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

In my previous post, I mentioned that I was assisting a developer with an issue. It turned out that the issue he was having was not the cause of an error, but the result of a previous error that the users had not told him about. Once the original error was fixed, the entire problem was solved.

Background process is running: Exit Aborted message

Posted on 4 January 2009 Posted in Developing For Dynamics GP Tagged with C#, Exception, VB, Visual Studio Tools 5 Comments

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

In a recent newsgroup posting, I was helping a Visual Studio Tools developer whose users were receiving the following message when they went to exit Microsoft Dynamics GP.

Background process is running: Exit Aborted

Welcome to 2009 & Backups

Posted on 4 January 2009 Posted in Developing For Dynamics GP Tagged with Backups, Blogsphere, General No Comments

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

Posted on 30 December 2008 Posted in Developing For Dynamics GP Tagged with Dexterity, Menu, NDM, Patrick Roth 3 Comments

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

Posted on 18 December 2008 Posted in Developing For Dynamics GP Tagged with General, SDK, Service Packs, Tools 9 Comments

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

Posted on 17 December 2008 Posted in Developing For Dynamics GP Tagged with Dexterity, Security, Support, Support Debugging Tool, Tools 11 Comments

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

Posted on 17 December 2008 Posted in Developing For Dynamics GP Tagged with Dexterity, Tools 11 Comments

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

Posted on 14 December 2008 Posted in Developing For Dynamics GP Tagged with Best Practice, Dexterity, Index File, Source Code Control 6 Comments

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

Posted on 7 December 2008 Posted in Developing For Dynamics GP Tagged with Best Practice, Dexterity, Modifier 7 Comments

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

Posted on 4 December 2008 Posted in Developing For Dynamics GP Tagged with Application, Automated Solutions, Duplicates, Exception, SQL 21 Comments

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

Posted on 2 December 2008 Posted in Developing For Dynamics GP Tagged with Application, Automated Solutions, SQL 14 Comments

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.