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 table for a line…

0

Customising the Company Login window series Part 3 – Dexterity

Following on from my previous posts: Customising the Company Login window series Part 1 – Introduction and Customising the Company Login window series Part 2 – Visual Basic for Applications, here is the method to create a solution using Dexterity. As discussed in the earlier posts, the problem we are trying to overcome is that the company drop…


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

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 issues where code…

1

Developing with the Microsoft Dynamics GP 2013 Named System Database

Microsoft Dynamics GP 2013 introduced another long sought after feature…. The Named System Database. Instead of the System database being hardcoded to DYNAMICS, a different name can be selected when installing GP. So what does that mean? Well, it means that more than one Dynamics GP system can reside on a single instance of SQL…

0

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

Copying Report Formats between Reports… and a warning about Word Templates

There is an unsupported method of copying report formats between reports that is very commonly used (and even recommended by me), but we recently had a case that highlighted a problem with the technique. This blog post will discuss the method and the issue we have seen.   The Situation The situation is very common…

4

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 Window on his form….

0

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 techniques and the usual method I recommended for…

6

Updating Dexterity code for Microsoft Dynamics GP 2013 continued

Things have been really busy recently, so it has taken a bit longer than I planed to get this blog post completed. This article is a follow up to the earlier post:  Updating Dexterity code for Microsoft Dynamics GP 2013. I wanted to cover some of the other issues and discussion points I came across…

1

Developing for Multiple Dexterity Versions and a warning

I recently came across a situation recently that highlighted the importance of using the correct best practice when developing Dexterity applications for multiple versions at the same time. While working on the Support Debugging Tool build 17, which included the update for Microsoft Dynamics GP 2013, I came across an issue where the SDT code…

2

How to create Dexterity Cross Dictionary Lookups

As you may know, I was one of the pioneers of Cross Dictionary Dexterity Development and have posted about it a number of times (also see Can I customise a 3rd party form with Dexterity? and Understanding Cross Dictionary Dexterity Development). I am currently involved as a technical advisor on a large consulting project which requires customisation to…

1

The Importance of Reporting Errors

Back in January 2009, I wrote an article: The Importance of Reporting the first Error, which talked about why it is important to report errors, but especially the first error. After dealing with a number of recent support cases where it came to light during the course of the support case that there had been…

4

Updating Dexterity code for Microsoft Dynamics GP 2013

Today we are going to cover some of the changes you will need to make to your Dexterity code to just bring forward your code to Microsoft Dynamics GP 2013. This will not leverage any of the new functionality or features of Microsoft Dynamics GP 2013, but will at least get your Dexterity code running.  …

9

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. Once the…

12

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 saved. The developer had already…

2