#Dexterity Well Behaved Ranges

While we are discussing ranges and in particular indexed ranges, it is worth having a discussion on what a “Well Behaved” range is.

If you have not read the previous article on Future Proof range setting, check it out below:

• #Dexterity Future Proof Range Setting

#Dexterity Future Proof Range Setting

This is another one of those “Musgravian” principles.

When I train people on Dexterity I show them a better method to set indexed ranges than the style you will often see in older code or by developers who have not yet been “converted”.

Visual Studio Tools: Best Practice when adding References to Projects

I am writing this article after seeing the side effects of Visual Studio Tools developers not following Best Practice when adding references to their projects.

Two mistakes made by the developer in this example resulted in Microsoft Dynamics GP failing to launch with the “An exception occurred while trying to load or initialize the addin” error.

Dexterity: Why won’t my Security operations show in Test Mode?

I was recently assisting a fellow Dexterity developer to create scripts to automatically create all the Security Tasks and Security Roles for their ISV (Independent Software Vendor) add-on product for Microsoft Dynamics GP.

While they were checking their code in Dexterity Test mode, the security settings for their product never showed up. This was weird as the data appeared to be in the tables and worked when in Runtime mode.

Developing using Dexterity for Microsoft Dynamics GP 2015

Today, I was contacted by a fellow Dexterity developer who was having trouble getting Dexterity for Microsoft Dynamics GP 2015 or later to run Dynamics.dic in Test Mode.

In this article, I will take you through the errors you could get and how to resolve them. Some of these you might know from previous versions, others are new to GP 2015 or later.

Part of the #Dexterity Development Environments Series. See Summary at end for quick list.

How to enable Visual Studio Tools Customisations for the Web Client

Have you ever written some cool Visual Studio Tools (VST) code that worked great on the desktop client, but does not work on the web client? VST code that does not use any WinForms or uses WinForms but only with supported controls and so should work?

Well, I have. A great example is the Company Login window customisations covered in the blog posts below:

• Customising the Company Login window series – Visual Studio Tools revisited – Visual C#
• Customising the Company Login window series – Visual Studio Tools revisited – Visual Basic .Net

The code worked fine on the desktop client, but had no effect in the web client. Something was missing, but I did not know what.

Quick Tip: Dexterity Ranges and how to update Fields that are part of the Key

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.

 

Customising the Company Login window series Part 3 – Dexterity

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

GP Power Tools – Administrator Tools Module can provide this functionality without needing customizations. (http://WinthropDC.com/GPPT)

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.

Customising the Company Login window series Part 2 – Visual Basic for Applications

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

GP Power Tools – Administrator Tools Module can provide this functionality without needing customizations. (http://WinthropDC.com/GPPT)

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).

Customising the Company Login window series Part 1 – Introduction

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

GP Power Tools – Administrator Tools Module can provide this functionality without needing customizations. (http://WinthropDC.com/GPPT)

Recently a comment from David M (not me) was posted on the Support Debugging Tool Portal 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 longer strings (65 Characters) but only displays 31 characters on the pull-down list. There is plenty of real estate on this window going unused. Can anyone think of a way to enhance/fix this to display more of the company name?”

Developers: Microsoft Dynamics GP 2013 Service Pack 2 moves the Vendor and Customer Combiner & Modifier into core code

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I had a case today where a developer was having issues when using the Customer Combiner. This functionality was part of PSTL (Professional Services Tools Library) and as of Microsoft Dynamics GP 2013 Service Pack 2 is now part of core code.

Quick Tip: Unusual behaviour when working with SQL Server from Dexterity

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.

Developing with the Microsoft Dynamics GP 2013 Named System Database

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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 Server. Before when a second Dynamics GP system was needed, you would have to install a new instance of SQL Server. Now you can have multiple System Databases on a single server without needing additional instances of SQL Server.

Quick Tip: VBA ADO Connection Run-time error ‘3709’

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.

Quick Tip: Handling scripts that use old() when using triggers to set default values

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

This Quick Tip comes to you after I faced this issue in a recent customisation project. I had seen this issue before and knew the approach required to solve it, but I don’t think it has been documented publicly till now.

 

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

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.

 

Quick Tip: Using Third Party Tables to fill a Scrolling Window

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.

Quick Tip: Accessing Third Party Table Buffers using anonymous tables

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.

Updating Dexterity code for Microsoft Dynamics GP 2013 continued

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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:

Developing for Multiple Dexterity Versions and a warning

This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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.