Developing for Microsoft Dynamics GP

January 2009 - Posts

• 0 Comments 1,621 Views

  Before you Write a Customization, check Solution Finder My friend Jeff Katz from the US Microsoft Dynamics GP Field Team has created a blog post about Partner and ISV Solutions for Microsoft Dynamics GP . He informs us about an exported version of the information available in the Solution Finder tool. It contains... Read More... Published: Thursday, January 29, 2009, 05:00 PM Tags: Solutions, Blogsphere, Customizations

• 0 Comments 1,548 Views

  Controlling a Visual Studio Tools Window Position Mohammad Daoud has found a great technique to control the initial location of a Visual Studio Tools window, so that it is centered on the screen regardless of resolution. Please have a look at his blog post for more information: Starting the Dynamics... Read More... Published: Wednesday, January 28, 2009, 06:00 PM Tags: Blogsphere, Visual Studio Tools

• 0 Comments 1,722 Views

  Customizations that you do not need to do Having supported the various customization tools over the years, you run into common requests again and again. Something that often surprises me is that you get requests to 'customize' Dynamics GP to make it do something and as it turns out Dynamics... Read More... Published: Tuesday, January 27, 2009, 09:00 AM Tags: Customizations, Modifier, VBA

• 0 Comments 1,832 Views

  Farewell and Good Luck to The Fabulous Matt G I have been involved with Great Plains (the product and company) since 1994 and during that time there has been one person in the Fargo Great Plains organisation who has always been there to answer my questions. I could direct any question at him and... Read More... Published: Monday, January 26, 2009, 06:00 PM Tags: Blogsphere, News, Fun, General

• 0 Comments 2,124 Views

  Do I need access to Microsoft Dynamics GP Source Code? 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... Read More... Published: Sunday, January 25, 2009, 06:30 PM Tags: Source Code Program, Dexterity, Visual Studio Tools, Support Debugging Tool

• 0 Comments 1,586 Views

  Finding out how to call an existing Report 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. If you are member of the Source Code program, you could always find the run report command in the source... Read More... Published: Thursday, January 22, 2009, 06:30 PM Tags: Source Code Program, Dexterity, Support Debugging Tool, Report Writer

• 0 Comments 1,530 Views

  Sending emails with Collaboration Data Objects (CDO) and Dexterity Mariano Gomez ( The Dynamics GP Blogster ) has written a great article on using Collaboration Data Objects (CDO) to send emails. Dexterity does have the MAPI_ function library but it can only handle a single attachment. Another method of sending email... Read More... Published: Wednesday, January 21, 2009, 05:00 PM Tags: Blogsphere, Dexterity

• 0 Comments 1,673 Views

  How can I identify the parameters of a Procedure or Function? 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... Read More... Published: Tuesday, January 20, 2009, 06:30 PM Tags: Source Code Program, Dexterity, Support Debugging Tool, SDK, Cross Dictionary

• 0 Comments 3,147 Views

  "The stored procedure createSQLTmpTable returned the following results: DBMS: 12" exceptions 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... Published: Monday, January 19, 2009, 06:00 PM Tags: Exception, Application, SQL

• 0 Comments 2,312 Views

  Passing data from a Business Portal Result Viewer Web Part to Dynamics GP Web Services 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,... Read More... Published: Sunday, January 18, 2009, 10:30 AM Tags: Business Portal, eConnect, Developer Toolkit, Integration, C#, Web Services

• 0 Comments 1,867 Views

  Microsoft Dynamics GP 10.0 Service Packs, Hotfixes and Payroll Compliance/Year End Updates May Damage the Modified Reports and Forms This issue which has now been confirmed by development seems to be hitting a few people when installing Microsoft Dynamics GP v10.00 Service Packs and Year End updates. Please see the following Hot Topic posts for more information: https://mbs.microsoft... Read More... Published: Thursday, January 15, 2009, 07:36 PM Tags: Formats, Exception, Application, Service Packs

• 0 Comments 1,725 Views

  Microsoft Dynamics™ GP 10.0 Bootcamp (Australia) There is some Microsoft Dynamics GP application training coming up in February for partners in Australia. Below are the details: New to Microsoft Dynamics™? Need to ramp up quickly? Have certification exams to pass? Microsoft is pleased to bring technology... Read More... Published: Thursday, January 15, 2009, 03:00 PM Tags: Training, Application

• 0 Comments 2,058 Views

  eOne.Dynamics.GP.ExcelBuilder.Engine.dll Exception 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... Read More... Published: Wednesday, January 14, 2009, 06:00 PM Tags: Visual Studio Tools, Exception, Application

• 0 Comments 1,708 Views

  Hybrid - Adding Named Printers control to Reports using VBA 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... Read More... Published: Tuesday, January 13, 2009, 06:30 PM Tags: Dexterity, Hybrid, Modifier, Named Printers, VBA

• 0 Comments 1,502 Views

  WorldMaps Tracking Added You might have noticed the world map showing in the News section of the blog on the left hand pane. This will allow us to track where the visitors to the blog are coming from. For detailed information click on the map or use the link below: WorldMaps... Read More... Published: Tuesday, January 13, 2009, 05:30 AM Tags: Blogsphere, General

• 0 Comments 1,574 Views

  Modifier - Reading and Writing Data with ADO Example 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 following VBA example adds the Item Short Description and Standard Cost fields to the Item Transaction Inquiry window and reports... Read More... Published: Sunday, January 11, 2009, 06:30 PM Tags: ADO, Modifier, VBA

• 0 Comments 1,483 Views

  Microsoft Research releases Songsmith OK, this is not actually Microsoft Dynamics GP related, but it is great for a bit of harmless (and in my case ... tuneless) fun. Songsmith is a bit like Karaoke in reverse. You sing the lyrics into a microphone and the software automatically generates... Read More... Published: Thursday, January 08, 2009, 06:00 PM Tags: Songsmith, Fun

• 1 Comments 1,983 Views

  The Importance of Reporting the first Error 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... Read More... Published: Tuesday, January 06, 2009, 06:30 PM Tags: Exception, Application

• 0 Comments 1,723 Views

  Background process is running: Exit Aborted message 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 There is a common cause for this error... Read More... Published: Sunday, January 04, 2009, 06:30 PM Tags: Visual Studio Tools, Exception, C#, VB

• 0 Comments 1,486 Views

  Welcome to 2009 & Backups Hello everyone. Welcome back to work and welcome to 2009. I had a great holiday with my family and (as hinted to by Mariano) went on a cruise to Vanuatu and New Caledonia in the South Pacific. We managed to catch up with family on both sides of Australia... Read More... Published: Sunday, January 04, 2009, 01:07 AM Tags: Blogsphere, Backups, General