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: Menus for Visual Studio Tools Portal

    This is the portal page for Menus for Visual Studio Tools for Microsoft Dynamics GP. Find this page using the shortened URL: http://aka.ms/MVST For GP 2013 (v12.0): Current release is Build 9 (Last Modified: 11-Dec-2012). For v10.0 & GP 2010 (v11.0): Current release is Build 9 (Last Modified:...
  • Blog Post: Menus for Visual Studio Tools Build 9 for Microsoft Dynamics GP 2013 Released

    With the release of Microsoft Dynamics GP 2013 , I am pleased to announce the release of Build 9 of Menus for Visual Studio Tools for Microsoft Dynamics GP for version GP 2013 (v12.0). This release for Dynamics GP 2013 is based on the Build 9 code from Dynamics GP 2010 and adds no new features other...
  • Blog Post: Why making the Dex.ini file read only is evil

    Time and time again I have heard consultants say that the solution to stopping Microsoft Dynamics GP remembering the last user on a Terminal Server or Citrix installation is to make the Dex.ini file read-only. There was even a Knowledge Base (KB) article that suggested clearing the SQLLastUser setting...
  • Blog Post: Menus for Visual Studio Tools Build 9 Released

    Well, it has taken a little longer than orginally planned, but I am pleased to announce that Menus for Visual Studio Tools build 9 has now been released for Microsoft Dynamics GP 10.0 and Microsoft Dynamics GP 2010 (v11.0). When Menus for Visual Studio Tools for Microsoft Dynamics GP 10.0 was first...
  • Blog Post: VBA - Adding Extender Windows to GL Transaction Entry Lines

    Last week I had an interesting support case that I thought I would share with you. The customer had created an Extender window to capture additional information for distribution lines on the General Ledger Journal Entry (GL_Transaction_Entry) window. The unique identifier for a distribution line is...
  • Blog Post: VBA - Calling a Report using Visual Basic for Applications

    I was recently asked about a forum post of mine from a few years ago. It was about how to call a Dexterity report from Visual Basic for Applications (VBA). I checked the blog and could not find a post that showed the code in its simplest form. So here one is... This technique used the unsupported...
  • Blog Post: Automating or Customizing the Report Destination Window

    I have seen this issue come up a number of times. Trying to automate processes which involve reports and wanting to automate the Report Destination window. Sometimes you can add the Report Destination to Visual Basic for Applications (VBA) and sometimes the system will not add the window to VBA. This...
  • Blog Post: Hybrid - Setting a push button to Hyperspace

    Trivia question for today: Given the following sequence of events: In Microsoft Dynamics GP, in a control field such as Customer Number, the user types in "AARON". The user then presses the associated lookup button. What happens? A. Focus moves to the button causing the field change script...
  • Blog Post: Hybrid Development and Continuum

    In the past, I was known for my pioneering work with and promotion of Cross Dictionary Dexterity Development . More recently I have been talking up the benefits of Hybrid Development and Developing Outside of the Box . With all the tools available to the Microsoft Dynamics GP developer, and each tool...
  • Blog Post: Dexterity Training in Orlando (Oct 5th to 9th 2009)

    Now is your chance. If you have not attended a Dexterity Training class and are either new to Dexterity or want to get started with Dexterity, this is an opportunity that should not be missed. My good friend, Leslie Vail, will be training the 5 day Dexterity I (also known as Dexterity Fundamentals...
  • Blog Post: Using Integration Manager with Analytical Accounting

    When you use Integration Manager on a system with Analytical Accounting (AA) installed, integrations often fail because Analytical Accounting will open windows which are unhandled by Integration Manager. However, there are time when you still want to use Integration Manager to import transactions where...
  • Blog Post: Developing Outside of the Box

    Recently I responded to a question on a newsgroup asking how to minimise a window from VBA (Visual Basic for Applications). The short answer is that it is not possible. But just because a Microsoft Dynamics GP window VBA object does not expose any methods or properties for the window state does not...
  • Blog Post: 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 it was purchased by Great Plains for v5.50 and included...
  • Blog Post: Can I customise a 3rd party form with Dexterity?

    Over the last few weeks I have been asked a number of times about methods of customising a 3rd party form. This purpose of this post is to clarify what can and cannot be achieved with Dexterity. Usually, the developer has created a combined dictionary as per the instructions in the Integrating with...
  • Blog Post: 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 to white papers comparing the tools and the architecture...
  • Blog Post: 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 that would expose the Menus for Visual Studio...
  • Blog Post: Hybrid - Purchasing Terms & Conditions Example

    This example shows how you can call a Dexterity report from Visual Basic for Applications (VBA). The report can be either a built in report or a custom report. If a built in report is used security will define whether the original, modified, alternate or modified alternate version will be printed. ...
  • Blog Post: Hybrid - Cheque Amount in Words Example

    One of the Report Writer functions added to v7.00 onwards (see Using the built-in Report Writer Functions ) was the RW_ConvertToWordsAndNumbers() function to convert a currency amount into words. After the code was added, it was realised that Report Writer calculated fields of return type string are...
  • Blog Post: Menus for Visual Studio Tools - The wait is over

    Some brilliant news for Microsoft Visual Studio developers who use Visual Studio Tools to integrate with Microsoft Dynamics GP 10.0. Menus for Visual Studio Tools for Microsoft Dynamics GP 10.0 has now been released on PartnerSource and CustomerSource . While I was in Fargo, ND for the Microsoft...
  • Blog Post: Hybrid - Adding Record Notes to a window Example

    I spent this morning discussing a very interesting customisation with my good friend Mariano Gomez . We had both seen a newsgroup posting asking if it was possible to add access to the Item Master's record note from the Item Inquiry window using VBA. Mariano had told me that he wanted to see if he could...
  • Blog Post: Hybrid - Running a macro to automatically close GP Example

    The following VBA example shows how a macro file can be started from VBA. This particular example will close Microsoft Dynamics GP when the Check Links window closes. As macros wait for background processes to complete, the macro will not start until the Check Links process and report have completed...
  • Blog Post: Choosing a Development Tool

    One of the great things about Microsoft Dynamics GP is the fact that there so many options available to integrate with or customise the application. There is a range from full development environments, to tools for consultants to utilities for the end user. The list includes Dexterity, Modifier...
  • Blog Post: Menus for Visual Studio Tools for Microsoft Dynamics GP 10.0

    Great News for Visual Studio developers working with Microsoft Dynamics GP 10.0. The Issue As I worked more with the Developer Toolkit and in particular Visual Studio Tools for Microsoft Dynamics GP, I found that the main support issue being seen was that it is not possible to add menu entries...
  • Blog Post: Hybrid - Clearing the Last User on a Terminal Server Example

    Microsoft Dynamics GP remembers the last user to use the application and defaults the User ID into the login window next time the application is loaded. This is useful when only a single user uses the specific workstation install. In a Terminal Server or Citrix environment, multiple users use a single...
  • Blog Post: Hybrid - Dynamically Populating a Modifier Added List Example

    When using the Modifier to add a list field (drop down list, button drop down list, listbox, multi-select list box) to a window as a local field, the only option available to populate the list was to add static values. This is because there is no functionality available in VBA to add items to a Dexterity...
Page 1 of 2 (27 items) 12