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 DUOS table in the previous company’s…

1

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…

4

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 (https://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 for companies allow for…

1

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 Runtime automatically…

7

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…

1

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…

1

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…

2

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 Year – 2013   Leslie Vail…

1

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 project involved…

1

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: 12/15/2011  Time:…

4

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 passed through…

7

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 started with Microsoft Corporate VP and leader of the Microsoft…

6

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 never populated and always returns an…

4

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 a background knowledge of Dexterity will help any developer wanting to work with Dynamics…

0

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 would have been able…

6

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…

13

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…

3

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.DLL, VBE.DLL, VBA7.DLL…

10