Browse by Tags

Related Posts
  • 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: 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: /...
  • 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 . ...
  • 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: Dexterity Training in Fargo (Feb 21st to 25th 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. I have found this can occur on 32-bit computers and GP 10.0. Important This article contains information about how to modify the registry . Make sure that you back up the registry before you modify it. Make sure that you know...
  • 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...
  • 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. I have commented with this information on a newsgroup posting , but thought I could add more information here for all to see. We have found that Office 2010 beta and...
  • 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...
  • Blog Post: VBA - Displaying Extender Data for GL Transaction Lines on the GL Inquiry window

    You might remember last month when we had a support case where the customer wanted to use Extender additional information against the General Ledger Journal Entry (GL_Transaction_Entry) distribution lines. We discovered that the Sequence Line field needed for the unique identifier for the line record...
  • Blog Post: Changing Dictionary Context when using Passthrough Dexterity sanScript Part 2

    This is the second in a series of posts which are are designed to help Dexterity developers as well as VBA and Visual Studio Developers to understand how to work with passthrough Dexterity sanScript. The main focus of this series is to understand how to change the Dictionary Context that the code executes...