Developing for Dynamics GP

by Microsoft Dynamics GP Developer Support Team (Fargo, ND, USA)

Browse by Tags

Tagged Content List
  • Blog Post: Quick Tip: Dexterity Ranges and how to update Fields that are part of the Key

    Last week, I had an interesting case where a Dexterity Developer was having trouble getting some code to update a range of records selected in a table. The code would only update the first record in the range. The Scenario The developer was trying to move the contents of the SOP_Serial_Lot_WORK_HIST...
  • 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: Quick Tip: Where does that customisation come from?

    I was recently asked about a custom button that was added to a window and how to change the internet URL that the button opened when it was closed. I was not provided with any other information or screenshots. The answer to the question is that the method to change the URL depends on what tool was...
  • Blog Post: Quick Tip: Debugging Visual Studio Tools

    Let's jump right in. We debug our Visual Studio applications over and over; and attaching to the test environment is among the most important, and time-consuming skills we use. (How many times have I launched GP2010 when I was thinking of GP2013?) Of course we all simplify our testing by building...
  • 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: 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: Quick Tip: Creating a Splitter control between panes of a window with Dexterity

    For many years Dexterity developers have wanted to be able to add a splitter control to windows with "panes" created with lists, treeviews or listviews. Using the window Object property Resizeable set to True-Per Field, developers have created windows which can be resized but the join between the...
  • Blog Post: Quick Tip: How to remove an alternate window from your Dexterity development environment

    One great thing about doing the job I do as an Escalation Engineer on the Asia Pacific Microsoft Dynamics GP support team is I have no end of support cases from which to draw ideas for blog posts from. So here a Dexterity case I helped with recently. The Problem The question from the Dexterity...
  • 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: 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: 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...
  • Blog Post: Quick Tip: Making sure Activity Tracking is enabled for all users

    This Quick Tip comes to you courtesy of an idea from my friend, Robert Cavill. On a Microsoft Dynamics GP system where Activity Tracking is being used, it needs to be activated for each User ID/Company ID that you want it enabled for. In most cases, you would want the Activity Tracking enabled for...
  • Blog Post: Quick Tip: Passing Parameters to Background Processes in Dexterity

    A couple months ago there was a post on the Partner Forum about Dexterity Oddities . One of the points raised in the post was about passing a text datatype parameter to a procedure called in the background and the fact that the contents of the text variable are lost. The same code called in the foreground...
  • Blog Post: Quick Tip: Hidden Forms, Command Forms and Dictionary Context issues

    This quick tip follows on from my previous post: Quick Tip: Updating Dexterity customizations to work with Security Tasks and Security Roles . There are times when there is a requirement to have some fields on a hidden form (a form with non of the windows set to AutoOpen). One example is when you...
  • Blog Post: Quick Tip: Updating Dexterity customizations to work with Security Tasks and Security Roles

    Another Quick Tip for Dexterity developers. This one discusses what changes need to be made to an integrating Dexterity application when upgrading from pre version 10.0 code to version 10.0 or GP 2010 to handle the changes in the security model. When version 10.0 was released it changed the security...
  • Blog Post: Quick Tip: Using substring() with a text field datatype

    An interesting tip today. Over the last few months there has been a thread on the Partner Forum ( GP Notes Lockdown ) with the request to prevent changes to the existing text on the Record Notes feature of Microsoft Dynamics GP. The functionality request has two parts: Prevent existing notes...
  • Blog Post: Quick Tip: Best practice for using sum range table command

    I came across an interesting issue yesterday relating to the Dexterity sum range command. We had a SQL datetime conversion error caused by a sum range command. This was the error message: A sum range operation on table 'SVC_Serial_Lot_Work_HIST' failed accessing SQL data. More Info: [Microsoft...
Page 1 of 2 (39 items) 12