Sign in
Developing for Dynamics GP
by David Musgrave (Perth, WA, Australia) and the Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)
Search Form
Options
Blog Home
About
Email Blog Author
Tags
Aaron Donat
ADO
Advanced Topic
Alice Newsam
Application
April Fool
Articles
Automated Solutions
Best Practice
Blogsphere
Business Portal
C#
Cakes
Cloud
Community
Conference
Cross Dictionary
Customizations
Developer Insights
Developer Toolkit
Development Tools
Dex.ini
Dexterity
Discussions
Downloads
DUOS
eConnect
Encryption
Exception
Extender
Fargo Flood
Featured
Fonts
Formats
Forums
FOTD
Fun
Games
General
GP "12"
GP 2010
GP 2010 R2
GP 2013
GPUG
History
Hobbies
Hybrid
Inside Track
Integration
Integration Manager
Karl Gunderson
Language
Logo
Macro
Menus for Visual Studio Tools
Modifier
Named Printers
News
Newsgroups
Notes & OLE Attachments
Pages
Passwords
Performance
PSTL
Quick Tips
Report Writer
Row Level Filtering
RW Functions
Samples
SDK
Search
Security
Service Packs
Smartlist
SmartList Builder
SnapShot
Source Code Control
Source Code Program
SQL
Suggestions
Support
Support Debugging Tool
Surface
Synchronise
System Requirements
Tools
Training
Translation
Triggers
Upgrade
VB
VBA
Visual Studio Tools
Web Client
Web Services
Windows 7
Windows 8
Windows Phone
Word Templates
XML
News
Dates of Interest
11-Jul-2008: Blog Created by David Musgrave.
03-Oct-2008: Syndicated to the
Dynamics Communities
.
10-Oct-2008: First Post by Scott Stephenson.
04-Nov-2008: First Post by Dave Dusek.
11-Nov-2008: First Post by Beth Gardner.
28-Nov-2008: First Post by Chris Roehrich.
30-Dec-2008: First Post by Patrick Roth.
24-Feb-2009: First Post by Greg Willson.
22-Apr-2009: First Post by David Clauson.
04-May-2009: First Post by Ryan Wigestrand.
19-Jun-2009: First Post by Dawn Langlie.
03-Jul-2009: First Post by Emily Halvorson.
23-Sep-2009: Created
Twitter account
with blog feed.
20-Nov-2009: First Post by Alice Newsam.
21-Apr-2010: First Post by Allan Cahill.
19-May-2010: First Post by Marian Verzosa.
24-May-2010: Blog Migrated to new Platform.
28-May-2010: Created
Facebook account
with blog feed.
15-Aug-2011: First Post by Development team.
05-Sep-2011: Created
http://aka.ms/Dev4DynGP
and
http://aka.ms/SDT
Shortened URLs.
15-Sep-2012: First Post by Aaron Donat.
27-Sep-2012: First Post by Jason Lech.
Social Networking & Syndication
Follow David Musgrave and the blog on:
This blog at
Dynamics Communities
Shortened URLs
This Blog:
http://aka.ms/Dev4DynGP
SDT Portal:
http://aka.ms/SDT
Menus for VST:
http://aka.ms/MVST
Disclaimer
This blog is provided "AS IS" with no warranties, and confers no rights.
The links in this blog may lead to third-party Web sites. Microsoft provides third-party resources to help you find customer service and/or technical support resources. Information at these sites may change without notice. Microsoft is not responsible for the content at any third-party Web sites and does not guarantee the accuracy of third-party information.
WorldMaps
WorldMaps Statistics since 24-Feb-2009:
Click for WorldMaps Stumbler
Translator Tool
Translate this page
Powered by
Microsoft® Translator
Links
Contents
General Articles & Links
Modifier & VBA Articles & Links
Dexterity Articles & Links
Developer Toolkit Articles & Links
Modifier & VBA Samples
Dexterity Samples
Developer & Consultant Articles & Links
Report Writer Articles & Links
Developer Toolkit Samples
Microsoft Dynamics GP Blogs
Support Debugging Tool Portal
Menus for Visual Studio Tools Portal
Newsgroups & Forums Links
Microsoft Dynamics GP Community Forum
Great Plains Tek Tips Forum
Microsoft Dynamics GP Partner Forum (Old)
Microsoft Dynamics GP Blogs at Dynamics Communities
Microsoft Dynamics GP Partner Forum
Blog Links
Dynamics GP Support and Services Blog
DynamicAccounting.net (Mark Polino's Blog)
The Dynamics GP Blogster (Mariano Gomez's Blog)
Microsoft Dynamics GP UK Blog
Microsoft Dynamics GP (Duke DelPrado's Blog)
Microsoft Dynamics GP Blogs Page
VSToolsForum.com (Steve Gray's Blog)
About Dynamics, Development and Life (Jivtesh Singh's Blog)
DynExtra (Habib Salim's Blog)
MSDynamicsWorld.com
The Death of Reason (Dwight Specht's Blog)
BlogMS - Official Microsoft Team Blogs
Dynamics GP Land (Christina Phillips, Steve Endow & Lorren Zemke's Blog)
Victoria Yudin's Blog
Dynamics GP Learn & Discuss (Vaidy Mohan's Blog)
Mohammad Daoud's Blog
Catherine Eibner's Blog
Rose Business Solutions Blog
Merit Matters Blog
GP2theMax (Frank Hamelly's Blog)
Dynamics Confessor Blogspot (Leslie Vail's Blog)
Interesting Findings & Knowledge Sharing (Sivakumar Venkataraman's Blog)
Njevity's Blog
Dynamics GP Middle East (Feradh Zain's Blog)
MBS Guru (Michael Johnson's Blog)
Inside Microsoft Dynamics GP (Official Blog)
ComputerationDynamics (Gloria Braunschweig's Blog)
Microsoft Dynamics Partner Community Blog
Q Factor's Blog (Constance Gilleland's Blog)
Dynamics Small Business (Matt Landis' Blog)
DynamicsBlogger (Janakiram M.P.'s Blog)
DynamicsGP.ie (Ian Stewart's Blog)
Dynamics Solution Edge (AMLLP Consulting's Blog)
Great Plains Guy (David Patrick's Blog)
Dynamics CPM (Corporate Performance Management)
Waqas Butt's Microsoft Dynamics GP Blog
eOne Business Solutions Blog
Real Life Dynamics User (Ron Wilson's Blog)
In Touch with Dynamics GP (Touchstone Group's Blog)
Dynamics GP - Knowledge Share (Sandip Jadhav's Blog)
Andy Nifong's Blog
Dynamics GP Builders & Reporting (Devon Southall's Blog)
Summit Group Software Blog
Belinda, the GP CSI (Belinda Allen's Blog)
GPWindow.com - Your window into Dynamics GP Resources
Dynamics Latam Blog
Dynamics for Distribution (Todd McDaniel's Blog)
Omar H. Kloub's Blog
Kuntz Consulting Blog (Jen Kuntz's Blog)
Aaron Berquist - High Dynamic Range
Dynamics GP Blog (Imtiaz Ahmed's blog)
Dynamics GP Help (Rubalpal Kaur's Blog)
Inside Dynamics GP Blog
Microsoft Dynamics GP Discussion (Samuel Mathew's Blog)
BKD Dynamics GP Insights Blog
Andrew Karasev's Blog
MonzerOsama.com (Monzer Osama's Blog)
azurecurve (Ian Grieve's Blog)
Microsoft Dynamics GP DBA (John Lowther's Blog)
Accidental Administrator (John Lowther's other Blog)
Resources Links
PartnerSource
CustomerSource
Microsoft Dynamics
Create Support Incident
Search Knowledge Base
Microsoft Dynamics GP Developer Center
Microsoft Connect: Add a Product Suggestion
Microsoft Dynamics GP Demo Site
Microsoft Dynamics Partner Solutions
ISV Central
Microsoft Dynamics Partner Community
Microsoft Dynamics ISV Solutions (PartnerSource)
Microsoft Dynamics GP Solution Center (PartnerSource)
GPWindow.com - Your window into Dynamics GP Resources
Microsoft Dynamics GP Community
Favourite Posts
GP Logos through the years
Menus for Visual Studio Tools for Microsoft Dynamics GP 10.0
Support Debugging Tool for Microsoft Dynamics GP
Cross Dictionary Dexterity Development
How to get started with Dexterity
Support Debugging Tool - The wait is over
Choosing a Development Tool
Microsoft Dynamics GP Technical Airlift 2008
Menus for Visual Studio Tools - The wait is over
Finding Table and Field Information in Microsoft Dynamics GP
Microsoft Dynamics GP Application Level Security Series
Useful SQL Scripts Series
Support Debugging Tool Build 10 released
Translating Dexterity Applications Series
Why does Microsoft Dynamics GP encrypt passwords?
Support Debugging Tool Build 11 released
Automating Distribution of Customizations
Installing the Support Debugging Tool for Microsoft Dynamics GP FAQ
Understanding Cross Dictionary Dexterity Development
Microsoft Dynamics GP Technical Conference 2009 Wrap Up
Support Debugging Tool Build 12 released
Support Debugging Tool for Microsoft Dynamics GP 2010 Beta
Microsoft Dynamics Convergence Atlanta 2010 Wrap Up
Support Debugging Tool Build 13 released
Menus for Visual Studio Tools Build 9 Released
Getting the most out of your Microsoft Dynamics GP Community
Why can't I run Microsoft Dynamics GP via ODBC over a WAN?
Support Debugging Tool Build 14 released
Microsoft Dynamics GP Technical Conference 2011 - Wrap Up
The Great West Australian Bike Ride - Wrap Up
Microsoft Convergence 2011 Atlanta - Wrap Up
Support Debugging Tool Build 15 released
Support Debugging Tool Build 16 released
Microsoft Convergence 2012 Houston - Wrap Up
Understanding the Support Debugging Tool Series
Support Debugging Tool Build 16 Hotfix released
Support Debugging Tool Build 17 released
Menus for Visual Studio Tools Build 9 for Microsoft Dynamics GP 2013 Released
Support Debugging Tool Build 17 hotfix released
Archives
Archives
May 2013
(9)
April 2013
(12)
March 2013
(5)
February 2013
(11)
January 2013
(7)
December 2012
(15)
November 2012
(14)
October 2012
(17)
September 2012
(16)
August 2012
(17)
July 2012
(16)
June 2012
(12)
May 2012
(16)
April 2012
(14)
March 2012
(20)
February 2012
(13)
January 2012
(10)
December 2011
(10)
November 2011
(13)
October 2011
(10)
September 2011
(19)
August 2011
(17)
July 2011
(7)
June 2011
(12)
May 2011
(10)
April 2011
(21)
March 2011
(28)
February 2011
(13)
January 2011
(15)
December 2010
(13)
November 2010
(16)
October 2010
(18)
September 2010
(20)
August 2010
(22)
July 2010
(22)
June 2010
(22)
May 2010
(23)
April 2010
(22)
March 2010
(17)
February 2010
(20)
January 2010
(19)
December 2009
(14)
November 2009
(19)
October 2009
(18)
September 2009
(19)
August 2009
(23)
July 2009
(19)
June 2009
(17)
May 2009
(17)
April 2009
(19)
March 2009
(24)
February 2009
(20)
January 2009
(20)
December 2008
(17)
November 2008
(21)
October 2008
(23)
September 2008
(17)
August 2008
(15)
July 2008
(31)
Browse by Tags
MSDN Blogs
>
Developing for Dynamics GP
>
All Tags
>
exception
Tagged Content List
Blog Post:
SmartList not working properly, Search window does not display correctly
David Musgrave
Yesterday, I had a support case come in where the customer was complaining that SmartList was not working properly and that the Search window was not being displayed correctly. The Problem During a screen sharing session with the customer, they explained that when they first opened SmartList and...
on
2 May 2013
Blog Post:
Currency Symbol not showing correctly for Users
David Musgrave
I resolved an interesting case the other day and thought I would write this one up on the blog. The Problem The customer reported that for a couple of their users, the currency symbol on the GL Transaction Entry window where not matching the symbols as defined by the Currency ID setup. This issue...
on
30 Apr 2013
Blog Post:
Quick Tip: VBA ADO Connection Run-time error '3709'
David Musgrave
It has been a long time since I shared a Quick Tip for Visual Basic for Applications (VBA), but I have had this one waiting for me to write up for a while. When using VBA on a window with ActiveX Data Object (ADO) to connect to SQL Server to read and/or write data to tables, the best practice is to...
on
10 Apr 2013
Blog Post:
Australian Goods and Service Tax (GST) Business Activity Statement (BAS) XML File fails to import into the Electronic Commerce Interface (ECI)
David Musgrave
Today I am going to discuss a support case where we found an issue with the XML file created when exporting the Business Activity Statement (BAS) tax return report for Australian Goods and Services Tax (GST). So, if you don't have to work with Australian companies and the rest of this article does...
on
28 Feb 2013
Blog Post:
Copying Report Formats between Reports... and a warning about Word Templates
David Musgrave
There is an unsupported method of copying report formats between reports that is very commonly used (and even recommended by me), but we recently had a case that highlighted a problem with the technique. This blog post will discuss the method and the issue we have seen. The Situation The situation...
on
25 Feb 2013
Blog Post:
Dex - Illegal address for field 'System Database Name' exception
David Musgrave
Yesterday, I had a comment posted on the Updating Dexterity code for Microsoft Dynamics GP 2013 post asking about getting an illegal address error after upgrading code to Microsoft Dynamics GP 2013 and launching into Test Mode. The error message was: Unhandled script exception: Illegal address...
on
19 Feb 2013
Blog Post:
Developing for Multiple Dexterity Versions and a warning
David Musgrave
I recently came across a situation recently that highlighted the importance of using the correct best practice when developing Dexterity applications for multiple versions at the same time. While working on the Support Debugging Tool build 17 , which included the update for Microsoft Dynamics GP 2013...
on
8 Jan 2013
Blog Post:
The Importance of Reporting Errors
David Musgrave
Back in January 2009, I wrote an article: The Importance of Reporting the first Error , which talked about why it is important to report errors, but especially the first error. After dealing with a number of recent support cases where it came to light during the course of the support case that there...
on
18 Nov 2012
Blog Post:
Identifying the cause when Microsoft Dynamics GP crashes with the Support Debugging Tool
David Musgrave
A recent support case again highlighted how useful the Support Debugging Tool for Microsoft Dynamics GP can be. This time the customer was having an issue where Microsoft Dynamics GP was crashing while they were working in a specific window. We found out that the customer had a Dexterity based customisation...
on
4 Nov 2012
Blog Post:
How to Fix a MBS_Grant_IMPERSONATE Error from the Support Debugging Tool
David Musgrave
While we are troubleshooting error messages from the Support Debugging Tool, I had another one reported last week. The error message below is displayed by the Support Debugging Tool when setting up the SQL Profile Tracing functionality from the Administrator Settings >> SQL Profile Trace Settings...
on
2 Oct 2012
Blog Post:
How to Fix a This version of Support Debugging Tool is incompatible Error
David Musgrave
This is another issue which can come up every now and then when installing the Support Debugging Tool. The error message below is displayed by the Support Debugging Tool just after logging into Microsoft Dynamics GP: This version of Support Debugging Tool is incompatible with the current version...
on
1 Oct 2012
Blog Post:
How to Fix a Setup File is from a later version Error from the Support Debugging Tool
David Musgrave
This issue with the Support Debugging Tool has occurred a few times recently after installing the latest version of the Support Debugging Tool. The error message below is displayed by the Support Debugging Tool just after logging into Microsoft Dynamics GP: Setup File is from a later version (##...
on
30 Sep 2012
Blog Post:
Microsoft Dynamics GP 2010 Utilities “Hanging” when Upgrading the Databases with Service Pack 3 or any Later Hotfix
David Musgrave
Last month, Kelly Youells posted on the Dynamics GP Support and Services Blog about an issue which can cause Microsoft Dynamics GP 2010 Utilities to hang when updating to Service Pack 3 or later. The details of the issue are posted on the blog and also linked to the Dynamics GP 2010 Hot Topic: ...
on
3 Sep 2012
Blog Post:
Microsoft Dynamics GP Home Page is dependent on Short File Names
David Musgrave
I solved an interesting case yesterday and thought I would share the details with you. The partner had installed Microsoft Dynamics GP 2010 R2 on a new Terminal Server and everything was working except the Home Page was not being rendered correctly. The images were missing and showing as Red X...
on
21 Aug 2012
Blog Post:
Could not load file or assembly 'Microsoft.Dynamics.GP.BusinessIntelligence.Homepage.dll'
David Musgrave
When you start working with Dexterity for Microsoft Dynamics GP 2013, you might notice an error when attempting to use the Dexterity Test Mode from the Dexterity Integrated Development Enviroment (IDE). When going into Test Mode by pressing Ctrl-T, you might receive the known error discussed in this...
on
14 Aug 2012
Blog Post:
How to Fix a Write to Setup File Aborted Error from the Support Debugging Tool
David Musgrave
This minor issue with the Support Debugging Tool has raised its head a few times, so I thought I would explain what is happening and how to resolve it. The error message below is displayed by the Support Debugging Tool just after logging into Microsoft Dynamics GP: Write to Setup File Aborted....
on
12 Aug 2012
Blog Post:
Running Dynamics GP 2010, AX 2012, and SL 2011 on the same machine
Patrick Roth
I ran across an issue a while back that a developer was running into after installing Dynamics SL 2011 on a machine with Dynamics GP 2010 (and Dynamics GP 10). Then in the next few days we had two more cases of the same issue (and again here , here , and here ). But I'm getting ahead of myself in that...
on
31 May 2012
Blog Post:
SQL Error: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)
David Musgrave
Today, I resolved a very interesting case. We had a customer who had just upgraded from an early build of Microsoft Dynamics GP 10.0 to Microsoft Dynamics GP 2010 (11.0) and after the upgrade they were unable to save from the Customer Maintenance window. Every time they would try to add a new record...
on
3 May 2012
Blog Post:
Cross Linked Companies, Pathnames and Everything
David Musgrave
A long time ago, in an ERP system far far away, data was stored in tables which in turn were stored as files in folders. Yes, before Great Plains Dynamics became Great Plains Dynamics C/S+ for SQL (version 3.15/3.17), we had to specify pathnames to dictate where the Ctree or Btrieve files for each...
on
13 Mar 2012
Blog Post:
Quick Tip: Dexterity SQL error invalid cursor state
Patrick Roth
In a recent case of mine, the ISV was running into a common issue that I've run into before more than a few times. Actually something I've done a few times myself. The ISV was attempting to use pass through sanScript to populate a SQL temp table. What he found was that the first SQL_Execute() statement...
on
9 Mar 2012
Blog Post:
Purchase Order Returns Modification
David Musgrave
This post is a public service announcement for those customers and partners using the free customization from Microsoft, Purchase Order Returns Modification (Product ID: 4159) for Microsoft Dynamics GP versions 9.0 and 10.0. Note: The functionality of this customization has been incorporated into...
on
7 Feb 2012
Blog Post:
Language settings for Windows client must match SQL Server Language
David Musgrave
A few weeks ago, I had a very interesting case with a Middle East customer based in the United Arab Emirates (UAE). The customer had reported that when the modified Computer Check Report was printed from one particular work station, it was blank. The same modified report printed fine on other workstations...
on
1 Nov 2011
Blog Post:
Analytical Accounting Security Tasks and Security Roles issue
David Musgrave
While working on a case recently with a colleague we noticed that a user received a security privileges error for some windows which were part of Analytical Accounting. We used the Support Debugging Tool's Security Information window to have a look at what was happening and found that there were Security...
on
1 Sep 2011
Blog Post:
Quick Tip: Why does Microsoft Dynamics GP show as Not Responding
David Musgrave
I am wondering if Joseph Tews is a mind reader, or if he can somehow see my draft blog posts before they are published. Joking aside, it turns out that the same day he posted about Symantec Endpoint Protection , he also posted about this topic that I was planning to post about. Unless he has a super...
on
11 Aug 2011
Blog Post:
Quick Tip: Dynamics fails to launch on system with Symantec Endpoint Protection installed
David Musgrave
I recently had a case where the customer was able to install the Microsoft Dynamics GP client on a machine, but when they clicked on the shortcut nothing happened. Even dragging the DYNAMICS.SET launch file onto the DYNAMICS.EXE application did nothing. In fact, any thing that involved getting the Dexterity...
on
10 Aug 2011
Page 1 of 3 (61 items)
1
2
3
Social Media Sharing