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

So you are writing your top notch, one-of-a-kind Visual Studio Tools for Microsoft Dynamics GP customization.

You’ve covered all the bases for any potential errors and just in case you miss any and an exception is thrown, you are catching the exception to write into an event log.

Read more →

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

One of the issues ISV’s have when integrating with the Dynamics GP menu system is to determine the name of a command list and command form to use.

Read more →

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

We ran into an odd issue recently that I’d like to share today.

An ISV reported that in their customer was getting an error when the ISV application attempted to execute a stored procedure.

[SQL Server] Could not find stored procedure DYNAMICS.dbo.SomeStoredProcedure

Easy you say – the proc doesn’t exist.  Just create it and you’ll be fine.

Read more →

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

An ISV had a goal of creating an audit table of the Dynamics record notes table – SY03900 – but was running into an issue.

He mentioned that he was using an “instead of update” SQL trigger and not just a normal “update” trigger.  The specific issue was that while his audit table was being updated, the SY03900 table was not.

After discussing the goals of his application and the issue, I set out to discover why exactly the normal update trigger wouldn’t work, why the SY03900 table wasn’t being updated, and lastly what we could do about it.

Read more →

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

It is somewhat coincidental that one of the system techs had a case Friday running into an error launching Dynamics GP 2010 and the release of Microsoft Dynamics GP 10.0 Service Pack 5.  What do these events have to do with each other?  Read on…

Read more →

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

Honestly, I struggled a bit on the title of this article.

Is this article to show one way to use a Dynamics GP lookup window in your Modifier/VBA customization?  Or is it an article that shows a way to work around the circular reference problem that you can get yourself into when using VBA across projects in Dynamics GP?

Read more →