David Meego - Click for blog homepageThis 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).

Read more →

David Meego - Click for blog homepageThis 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.

Read more →

David Meego - Click for blog homepageThis 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.

Read more →

David Meego - Click for blog homepageThis 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.

Read more →

Dave Dusek - Click for blog homepageThis is a reposting of an article Dave Dusek originally wrote on my Developing for Dynamics GP blog.

A common situation that can happen when coding with Dexterity is an error that you attempted to use the old()/diff() function from a field that doesn’t have focus. The exact error message is as follows:

Unhandled Script Exception: Attempt to use old()/diff() from a field that does not have focus.

Read more →