Developing for Dynamics GP

by David Musgrave (Perth, WA, Australia) and the Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)

Browse by Tags

Tagged Content List
  • Blog Post: Developers: Microsoft Dynamics GP 2013 Service Pack 2 moves the Vendor and Customer Combiner & Modifier into core code

    Now before you ask.... the answer is No, I have not spent all week playing XBox One (as mentioned on the last post ). Yes, we did get one and yes the kids have been using it, but the reason I have not posted on the blog is just that I have been very busy with support cases. Talking of support cases...
  • Blog Post: Quick Tip: Unusual behaviour when working with SQL Server from Dexterity

    Today, I came across an issue where a feature in Microsoft Dynamics GP would work when the workstation had its regional settings set to United States, but would fail to produce any data when the workstation had its regional setting set to Australia, New Zealand, United Kingdom, etc. We have seen related...
  • Blog Post: Developing with the Microsoft Dynamics GP 2013 Named System Database

    Microsoft Dynamics GP 2013 introduced another long sought after feature.... The Named System Database. Instead of the System database being hardcoded to DYNAMICS, a different name can be selected when installing GP. So what does that mean? Well, it means that more than one Dynamics GP system can...
  • Blog Post: Quick Tip: VBA ADO Connection Run-time error '3709'

    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...
  • Blog Post: Quick Tip: Handling scripts that use old() when using triggers to set default values

    This Quick Tip comes to you after I faced this issue in a recent customisation project. I had seen this issue before and knew the approach required to solve it, but I don't think it has been documented publicly till now. The Scenario The customisation required is fairly common. The customer...
  • Blog Post: Copying Report Formats between Reports... and a warning about Word Templates

    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...
  • Blog Post: Quick Tip: Using Third Party Tables to fill a Scrolling Window

    My good friend, Mariano Gomez ( The Dynamics GP Blogster ) raised this issue recently. He wanted to use the method I discussed in my previous Quick Tip post: Quick Tip: Accessing Third Party Table Buffers using anonymous tables to gain access to the third party table so he could display it in a Scrolling...
  • Blog Post: Quick Tip: Accessing Third Party Table Buffers using anonymous tables

    I have been spending a lot of time recently working on consulting engagement in Malaysia. This project involves a large amount of custom Dexterity code, some of which involves accessing tables in other third party product's dictionaries. In the past, I have covered Cross Dictionary Dexterity Development...
  • Blog Post: Updating Dexterity code for Microsoft Dynamics GP 2013 continued

    Things have been really busy recently, so it has taken a bit longer than I planed to get this blog post completed. This article is a follow up to the earlier post: Updating Dexterity code for Microsoft Dynamics GP 2013 . I wanted to cover some of the other issues and discussion points I came...
  • Blog Post: Developing for Multiple Dexterity Versions and a warning

    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...
  • Blog Post: How to create Dexterity Cross Dictionary Lookups

    As you may know, I was one of the pioneers of Cross Dictionary Dexterity Development and have posted about it a number of times (also see Can I customise a 3rd party form with Dexterity? and Understanding Cross Dictionary Dexterity Development ). I am currently involved as a technical advisor on a...
  • Blog Post: The Importance of Reporting Errors

    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...
  • Blog Post: Updating Dexterity code for Microsoft Dynamics GP 2013

    Today we are going to cover some of the changes you will need to make to your Dexterity code to just bring forward your code to Microsoft Dynamics GP 2013. This will not leverage any of the new functionality or features of Microsoft Dynamics GP 2013, but will at least get your Dexterity code running...
  • Blog Post: Quick Tip: Getting Command Based Menus working in Dexterity

    In the last couple of weeks, I have had a few cases where Dexterity command based menus for addon products no longer showed in Microsoft Dynamics GP 2010 after Service Pack 3 was installed. In each of the cases, a review of the menu creation procedures identified that the code was actually incorrect...
  • Blog Post: Quick Tip: Using fields named as reserved words with Visual Basic for Applications

    I had a case today that raised an issue that I have seen before which has a simple solution. The Problem In summary, when you add a field to Visual Basic from Microsoft Dynamics GP, the name of the field is set to the text in the the linked prompt for that field (or the caption text for buttons...
  • Blog Post: Quick Tip: Capturing the Save Event with Visual Studio Tools

    I recently responded to a community post which was asking how to ensure that all save events from the Item Maintenance window were captured using Visual Studio Tools. The aim was to make sure that the additional fields added to the window with Modifier were saved when the item data in the window was...
  • Blog Post: Getting data from ISV tables onto reports without needing to create alternate reports

    As a Dexterity developer, I have written a number of customisations to Microsoft Dynamics GP which add additional fields to the system. These additional fields are often have a relationship to existing data in Dynamics GP. It is quite common to store the additional data in a parallel table (sometimes...
  • Blog Post: Cross Linked Companies, Pathnames and Everything

    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...
  • Blog Post: Quick Tip: Copying larger amounts of data in SQL Server quickly

    I recently posted the Quick Tip: Copying small amounts of data in SQL Server quickly . This quick tip used the clipboard to copy data between tables as an alternative to using DTS (Data Transformation Services), SSIS (SQL Server Integration Services) or Transact-SQL (T-SQL). In this post, I thought...
  • Blog Post: Quick Tip: Copying small amounts of data in SQL Server quickly

    Last week, I was working on a Microsoft Dynamics GP update case where we had to re-upgrade one company from the previous service pack to the current service pack. To allow Dynamics GP Utilities to re-upgrade one company there are 3 things we need to do. Restore the previous version of the Company...
  • Blog Post: Quick Tip: Solving Dexterity Trigger Clashes

    In a recent support case, I had the rare situation where Dexterity Triggers clashed. Dexterity allows third party developers to create triggers against various events and scripts in a Dexterity application (like Microsoft Dynamics GP). There are times where more than one third party product registers...
  • Blog Post: Failed eConnect document leaves orphaned records

    I assisted on an eConnect incident today that was quite interesting and I thought I'd share the case and the solution. The issue: The ISV was integrating a Payables Invoice using eConnect 10.0. The XML document had 2 distributions and the invoice data. What the ISV found was that there was...
  • Blog Post: Quick Tip: Working with VBA, Extender and Sales Transaction Entry

    I have completed the development project I was working last week and have another Quick Tip that came out of the project. For the previous Quick Tips related to this project have a look at Quick Tip: Passing Variables to SQL Server and Quick Tip: Passing Date and Time Variables to SQL Server . The...
  • Blog Post: Quick Tip: Passing Date and Time Variables to SQL Server

    As a follow on from yesterday's post, Quick Tip: Passing Variables to SQL Server , I wanted to discuss the related topic about passing of date and time variables. There are two main issues we see with passing Dates and Times and both can cause SQL Server to throw the following exception: /* Date...
  • Blog Post: Quick Tip: Passing Variables to SQL Server

    Wow, the week is almost over and I am yet to post something. This week I was working on a small development project using Visual Basic for Applications (VBA) to execute some commands at the SQL Server level after some user interface events. The code to be executed needed to have values from the windows...
Page 1 of 3 (70 items) 123