Developing for Dynamics GP

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

Browse by Tags

Tagged Content List
  • Blog Post: VBA: DUOS data stored in the wrong database after switching companies

    A while ago I had a case where the customer was storing data in the DUOS (Dynamic User Object Store) table from a VBA (Visual Basic for Applications) customisation. Everything worked fine until the users switched companies. After switching company the VBA customisation would still be connected to the...
  • Blog Post: Microsoft Dynamics GP 2013 R2: VBA and the Action Pane

    Hello! I just want to first take a second to introduce myself since this is my first post on the Developing for Dynamics GP blog. My name is Lucas Miller and I've been supporting Microsoft Dynamics GP since 2005. Like much of the team I'm based out of Fargo, ND, USA. I've been married for almost 2...
  • Blog Post: Customising the Company Login window series Part 2 - Visual Basic for Applications

    Following on from my previous post: Customising the Company Login window series Part 1 - Introduction , here is the method to create a solution using Visual Basic for Applications (VBA). As discussed in the earlier post, the problem we are trying to overcome is that the company drop down list on the...
  • Blog Post: Customising the Company Login window series Part 1 - Introduction

    Recently a comment from David M (not me) was posted on the Support Debugging Tool Portal ( http://aka.ms/SDT ) page asking: "We have some fairly long names for our GP companies. Well, when logging onto GP, the second "Company Login" screen cuts off the company names too short for us. The entry field...
  • Blog Post: More on SQL Server Connection issues with Microsoft Dynamics GP

    I have been working on a recent support case that had a situation that makes me want to raise this topic again. In the past, I have posted a number of articles discussing reasons for connections to SQL Server to be lost. When Microsoft Dynamics GP loses its connection to SQL Server, the Dexterity...
  • Blog Post: All About Listbox, Button Drop Lists, and Drop Down Lists

    It seems like a trivial subject for our dedicated readers but we had a new customer who is just learning Dexterity and he was having trouble recently trying to select items out of a ListBox. And just today the issue came up about Drop Down Lists (DDL) and getting the value selected using VBA in a different...
  • 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: 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: MVP updates: Victoria Yudin's MVP status renewed and Leslie Vail's Developing Microsoft GP Business Applications book

    I am still on leave for another week, but thought I would post about some updates from our Most Valuable Professional (MVP) community. Victoria Yudin has been awarded MVP status for the ninth consecutive year. Well done on the fantastic achievement. Have a look at her article below: Happy New...
  • 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: 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: Microsoft Convergence 2011 Atlanta - Day 2

    Today was the first "Official" day of the Convergence conference. After meeting Leslie and Sheila for breakfast, we went to the Open Keynote: Winning with Microsoft Dynamics . The session is now available from Virtual Convergence , please use this link: Winning with Microsoft Dynamics . The session...
  • Blog Post: Customizations to the Cash Receipts (RM_Cash_Receipts) window failing for GP 2010

    I have had a number of support cases and newsgroup posts recently about Customization to the Cash Receipts (RM_Cash_Receipts) window failing to work for Microsoft Dynamics GP 2010 when they worked for previous versions. The problem is that the code appears to work, but the Document Number field is...
  • Blog Post: Dexterity Training in Orlando (May 16th to 20th 2011)

    Finally, you have another opportunity to learn the foundations of Developing for Dynamics GP using Dexterity. The Microsoft Dynamics GP client application is developed using Dexterity. Many of the features of the Dynamics GP interface are the way they are because of the how Dexterity works. Having...
  • Blog Post: Dynamics Report Writer is the Best Report Writer in the World cont.

    This is a follow up post to my earlier post , which demonstrated how Report Writer when combined with the power of Visual Basic for Applications (VBA) was able to create a customisation that would not have been possible with Report Writer alone. In fact, I would be fairly surprised if any report writer...
  • Blog Post: Using Barcodes from the Dynamics GP Report Writer

    A few months ago, I worked on a support case where we needed to add a barcode to a Sales Order Processing transaction print out. We were able to achieve what we needed using Visual Basic for Applications (VBA) to handle some of the scripting for us. I have been meaning to write a blog post on how to...
  • Blog Post: Dynamics Report Writer is the Best Report Writer in the World

    Alright, maybe I am stretching the truth a little, but I do get frustrated when people discount the Dynamics Report Writer as a useful tool. [Edit] I am not biased at all.... honest. I recently worked on a support case where the partner had spent a significant amount of time trying to get Report Writer...
  • Blog Post: File not found: VBA6.dll error occurs or GP crashes

    This is a follow up to my previous post on the VBA6.dll not found error (for 64-bit). I have found this can occur on 32-bit computers and Microsoft Dynamics GP 10.0 and GP 2010. [Edit] Re-installing the VBA 6.4 core components (as used by Dynamics GP) has been shown to resolve this issue for VBA6...
  • Blog Post: Quick Tip: Solving "Do you want to Save?" dialog appearing after VBA customization

    Have you ever used Modifier and Visual Basic for Applications (VBA) to add an additional field to a window? Have you then had the issue when navigating through records on that window, it keeps coming up and asking " Do you want to Save, Discard or Cancel? " or " Do you want to Save, Delete or Cancel...
  • Blog Post: File not found: VBA6.dll error occurs or GP crashes and creates a Watson fault bucket 1474386816

    We have been running into a few different issues with Microsoft Dynamics GP 10.0 and GP 2010 when you have Office 2010 installed. [Edit] Re-installing the VBA 6.4 core components (as used by Dynamics GP) has been shown to resolve this issue for VBA6.DLL, VBE.DLL, VBA7.DLL and VBE7.DLL errors. Please...
  • Blog Post: Dynamics GP Customizations Summary

    First Jivtesh Singh creates the awesome portal site GPWindow.com and now he starts using it to gather all the best posts together. His latest blog post covers Microsoft Dynamics GP Customization with its many tools and methods and highlights a large number of fantastic posts from around the community...
  • Blog Post: Currency values returned by VBA to a report are multiplied by 10 or 100 with Multicurrency

    Last week, I discussed an issue where Currency values returned by VBA to a report are multiplied by 10 or 100 . To workaround the issue we used string calculated fields rather than currency calculated fields on the report and formatted our values with the FormatCurrency() or FormatNumber() functions...
  • Blog Post: Currency values returned by VBA to a report are multiplied by 10 or 100

    Today, I wanted to highlight an issue that you might see when working with Visual Basic for Applications (VBA) and Report Writer. The issue occurs when using VBA code to return a currency value to be displayed on the report and it appears to be randomly multiplied by 10 or 100. This is a known issue...
Page 1 of 5 (102 items) 12345