Developing for Microsoft Dynamics GP

October 2008 - Posts

• 0 Comments 1,685 Views

  Statement of Direction for Microsoft Dynamics GP You might have seen some other posts around that the updated Statement of Direction for Microsoft Dynamics GP documentation has been posted on PartnerSource and CustomerSource. Some points of interest for the developer community are listed below: The... Read More... Published: Thursday, October 30, 2008, 02:16 AM Tags: Application, Dexterity, Visual Studio Tools, Web Services, Statement Of Direction, Integration Manager

• 0 Comments 1,810 Views

  Developer Documentation for Microsoft Dynamics GP I found some great reference pages on PartnerSource and CustomerSource today. They are the Developer Documentation pages for Microsoft Dynamics GP 9.0 and 10.0. They contain links to information about every customisation tool available as well as links... Read More... Published: Thursday, October 30, 2008, 02:13 AM Tags: Dexterity, Hybrid, Development Tools, Developer Toolkit, Visual Studio Tools, Web Services, Modifier, eConnect

• 0 Comments 2,637 Views

  Using ADO with VBA with Report Writer As a follow on to the Using VBA with Report Writer post, I would like to discuss using ActiveX Data Objects to access data from SQL Server while using the Report Writer. Sometimes it is not possible to use Report Writer to create a table relationship... Read More... Published: Wednesday, October 29, 2008, 07:10 PM Tags: VBA, ADO, Report Writer

• 0 Comments 2,829 Views

  Using VBA with Report Writer Most people are aware that you can use Visual Basic for Applications (VBA) with Microsoft Dynamics GP forms and the Modifier, but not everyone is aware that VBA can be used with the Report Writer as well. In fact using VBA with the Report Writer can allow... Read More... Published: Wednesday, October 29, 2008, 05:35 PM Tags: DUOS, VBA, ADO, Report Writer

• 0 Comments 4,774 Views

  How to use Word Mail Merge and Macros to Import Data This post explains how to use Microsoft Office Word's Mail Merge functionality to Import Data into Microsoft Dynamics GP. This method can be useful when working with master records or transactions not supported by any of the existing tools such as... Read More... Published: Wednesday, October 29, 2008, 02:48 PM Tags: Application, Integration, Macro, Import

• 0 Comments 1,773 Views

  Running a SQL Script against all GP Company Databases While administering a Microsoft Dynamics GP system, there are times when a fix or change needs to be applied to each company in the system at the SQL Server level. On a system with a large number of companies this can be a very time consuming task. Wouldn't... Read More... Published: Sunday, October 26, 2008, 09:00 PM Tags: SQL, Application

• 0 Comments 1,945 Views

  Dex - Filtering a Third Party Lookup When I started this blog, one of my goals was to help developers push the boundaries of what they believe is possible. This was the foundation of the materials presented at conferences by myself and Mark Rockwell. For more information on the conference... Read More... Published: Wednesday, October 22, 2008, 11:52 PM Tags: Dexterity, Pushing the Limits with Dexterity, Cross Dictionary, Advanced Topic

• 0 Comments 1,681 Views

  Support Debugging Tool Free Live Meeting Session Sorry, I posted this too late for most people. I thought I would let you know that I presented a free Live Meeting session about the Support Debugging Tool for Microsoft Dynamics GP on the 22 nd October at 13:00 AEST (GMT+10 + daylight saving). That was... Read More... Published: Tuesday, October 21, 2008, 09:18 AM Tags: Support Debugging Tool

• 0 Comments 1,521 Views

  What Training do you want and where? Over the years I have had many requests for training on the various tools available for customising or developing with Microsoft Dynamics GP. Training for Microsoft Dynamics GP tools does exist, but it is only run infrequently, in a classroom environment... Read More... Published: Monday, October 20, 2008, 07:34 PM Tags: Training

• 0 Comments 1,703 Views

  Microsoft Dynamics GP 10.0 Service Pack 3 Just a quick post to let you know that Service Pack 3 for Microsoft Dynamics GP version 10.0 has now been released. The link below is the main Service Pack page: Service Pack, Hotfix, and Compliance Update Patch Releases for Microsoft Dynamics GP 10.0... Read More... Published: Wednesday, October 15, 2008, 11:05 PM Tags: Application, Service Packs

• 0 Comments 1,832 Views

  Dex - Illegal address for field 'PowerUser' exception Today I saw another posting on the Microsoft Dynamics GP Community Forum about an error when going into Dexterity test mode after upgrading an application from a previous version to version 10.0. The error message is as follows: Unhandled script exception... Read More... Published: Thursday, October 16, 2008, 03:24 AM Tags: Dexterity, Exception

• 0 Comments 1,659 Views

  Where is the DEX.INI file for version 10.0? Since the release of Microsoft Dynamics GP v10.0 I have seen this question asked many times over on the various newsgroups I monitor (see the Newsgroups Links on the left hand panel of the blog). The quick answer is.... it has moved into the Data subfolder... Read More... Published: Wednesday, October 15, 2008, 06:53 PM Tags: Application, Dexterity, Dex.ini, Vista, UAC

• 0 Comments 1,753 Views

  Dex - Working with the Action Button on the SOP_Entry form Time to get into some Dexterity code. I saw a posting today on the Microsoft Dynamics GP community forum. It was asking about the disappearance of the Void Button from the SOP_Entry form and how to work with the new Action Button. In v9.0 and earlier... Read More... Published: Thursday, October 16, 2008, 02:18 AM Tags: Dexterity, Triggers

• 0 Comments 1,678 Views

  What is Column desSPRkmhBBCreh? If you have ever spent time analysing a DEXSQL.LOG file you might have seen a reference to a table column called desSPRkmhBBCreh. This post explains what this column is used for and why it has the name it does. For example: SELECT desSPRkmhBBCreh FROM... Read More... Published: Tuesday, October 14, 2008, 11:36 PM Tags: SQL, Application

• 0 Comments 2,047 Views

  Unexpected Hidden Talents - Decorating Cakes I have been involved in the Great Plains world now since 1994. During that time I have become known for my work with development techniques and pushing the boundaries of what is possible. While my passion for my work in the Asia Pacific Microsoft Dynamics... Read More... Published: Monday, October 13, 2008, 12:06 AM Tags: Hobbies, Fun, General, Cakes

• 0 Comments 2,059 Views

  Hybrid - Using Menus for Visual Studio Tools from VBA Example After the release of Menus for Visual Studio Tools for Microsoft Dynamics GP 10.0 , my good friend Mariano Gomez asked me if it was possible to use the tool to add menus from Visual Basic for Applications (VBA). Mariano was initially working on an approach... Read More... Published: Sunday, October 12, 2008, 10:36 PM Tags: Dexterity, DUOS, Hybrid, VBA, Menus for Visual Studio Tools

• 0 Comments 1,814 Views

  Providing product feedback using Microsoft Connect Hello Developing for Dynamics GP community. David has been busy posting lots of great information and I thought it was time for my team to start helping contribute. My name is Scott Stephenson and I am the team manager for the Microsoft Dynamics GP Developer... Read More... Published: Friday, October 10, 2008, 05:22 AM Tags: Application, General, Suggestions, Features, Enhancements, Support, Development Tools

• 0 Comments 2,091 Views

  What do the zDP_ Auto Generated Stored Procedures do? If you look at a SQL Server installation of Microsoft Dynamics GP, in the Stored Procedures folder underneath the Dynamics system database or a company database you will find a large number of stored procedures starting with the initials"zDP"... Read More... Published: Monday, October 06, 2008, 02:19 AM Tags: SQL, Dexterity, Performance

• 0 Comments 2,770 Views

  Finding Table and Field Information in Microsoft Dynamics GP This is an updated version of an article I wrote a while back for the Microsoft Dynamics GP community website. The links to the original article, as well as the associated Knowledge Base (KB) article are provided at the bottom of this post. The idea was... Read More... Published: Saturday, October 04, 2008, 06:47 PM Tags: Dexterity, Support Debugging Tool, Dex.ini, SnapShot, SDK

• 0 Comments 1,826 Views

  Visual Studio Tools LineFill Events Developers using Visual Studio Tools for Microsoft Dynamics GP with forms that contain scrolling windows might have noticed that the LineFill events are missing from v9.0 and v10.0, this posting explains why they were missing and why they have been added... Read More... Published: Thursday, October 02, 2008, 05:06 PM Tags: Dexterity, Developer Toolkit, Visual Studio Tools