Writing to An Event Log in a Visual Studio Tools Customization

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.

Continue reading

Finding Command Forms and Commands to use with Menus for Visual Studio Tools or Dexterity

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.

Continue reading

Stored Procedure Executing In Wrong Database

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.

Continue reading

Using SQL DB Update Trigger With Text Fields

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.

Continue reading

Side-by-side configuration is incorrect error message given launching Dynamics GP

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…

Continue reading

VSTools 2010: Adding Company Name to Dynamics GP Home Page

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

A few years ago, the question came up (partner, customer, Convergence – I don’t recall) about being able to identify the current company on the Dynamics Home Page of the Navigation pane.

Continue reading

Avoiding VBA Circular References when using a Dynamics GP Lookup

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?

Continue reading

Dexterity DSCCS 2010 RTM should not be used

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

Several weeks ago, an ISV posted to the forums that he had thrown caution to the window and upgraded his Dexterity DSCCS 7.5 to DSCCS 2010.  The install went OK for him (unlike my own install that I discussed in a previous post) but what he found was that he wasn’t able to check in resources with Dexterity using this version.

Continue reading

Dynamics GP Lists: Exports slowly to Excel

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

Breaking with my recent series on Smartlist and specifically the Smartlist: Exports slowly to Excel – Part 1 post, a comment and followup question to that post was:

This is great!  But is there a similar switch for the Dynamics GP lists such as the “All Sales Transactions” or “Accounts” list?

Good question and honestly I did wonder about that myself.  But it was outside my “all things Smartlist” topic so I figured I’d check it out later.

Now that it came up – today looks like “later” so I thought I’d dig into it.

Continue reading

Smartlist: Exports slowly to Excel – Part 2

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

This is the 4th post in a series of Smartlist posts in the last weeks.  In these articles, I’ve given answers and solutions to common questions about Smartlist that are typically of the “Why doesn’t Smartlist..?” variety.

Last week, the question we were looking at was:

Continue reading

Smartlist: Exports slowly to Excel – Part 1

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

In the last few weeks (here and here), I’ve enumerated several questions that I’ve been asked and have seen posted to the public Dynamics GP newsgroups.  These questions are typically of the “Why doesn’t Smartlist..?” variety.

In this post and a few planned future posts, I’ll look at each of these questions individually and give a few thoughts around them and maybe a few solutions as well.

Continue reading

Smartlist: Splitter control in Smartlist window doesn’t work

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

Last week, I enumerated several questions that I’ve been asked and have seen posted to the public Dynamics GP newsgroups.  These questions are typically of the “Why doesn’t Smartlist..?” variety.

In this post and a few planned future posts, I’ll look at each of these questions individually and give a few thoughts around them and maybe a few solutions as well.

Continue reading

Dexterity Source Code Control Server 2010 with Windows 7

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

Supporting Web Services and Workflow in Dynamics, my primary desktop machines have been Windows 2003 for a number of years.  Of course Vista was out of the question because GP Web Services would only install on a server OS.

When Windows 2008 was released I had considered upgrading my OS but honestly didn’t want to go through formatting my machine and reinstalling everything again for the sake of having an updated operating system.  Yes, I was being a bit lazy.

Continue reading

Microsoft Visual Studio Tools window does not open

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

This week an ISV logged a support incident to determine why their Visual Studio Tools for Microsoft Dynamics GP (VSTools) form wouldn’t open.  The customization worked fine on the developer’s machine (of course) but didn’t work when deploying it to the customer site.

Continue reading