How to add Item Category Long Descriptions to reports using the Support Debugging Tool

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

I am currently working on a support case where the customer is making use of the six user defined categories for items. That in itself is nothing remarkable or worth blogging about.  However, they are using Long Description field on the Item Category Setup window and wished to include the data from this field onto reports. That’s the difficult bit.

Continue reading

How to read a Dexterity Script Profile to solve Performance Issues

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Today, I thought I would spend a little time explain how to read a Dexterity Script Profile to resolve a performance issue. To demonstrate this I will use a support case I had where the customer was intermittent long delays when clicking on the checkbox on the Apply Sales Document window.

Continue reading

Working with Temporary Tables in Dexterity

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Dexterity developers often need to use temporary tables to perform tasks, such as displaying data in a different order, consolidating or totalling data, to store data while it is being edited, or to combine data from tables so it can be sorted using an index using fields from multiple tables.

Continue reading

Writing to An Event Log in a Visual Studio Tools Customization

Patrick Roth - Click for blog homepageThis is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

So you are writing your top notch, one-of-a-kind Visual Studio Tools for Microsoft Dynamics GP customization.

You’ve covered all the bases for any potential errors and just in case you miss any and an exception is thrown, you are catching the exception to write into an event log.

Continue reading

Changing Dictionary Context when using Passthrough Dexterity sanScript Part 2

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

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

Continue reading

Changing Dictionary Context when using Passthrough Dexterity sanScript Part 1

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

This is the first 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 in.

Continue reading

Getting Table and Field Data out of Dexterity Dictionaries

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Today, I have something special. Also, something that I had not planned to do…

Over the years since Mark Rockwell and I published the Pushing the Limits with Dexterity, I have been asked a number of times about accessing dictionary resources such as tables and fields. This is information that is not stored anywhere in SQL tables and can only be accessed using Dexterity sanScript code to “read” the resources definitions.

Continue reading

Dex – How to work with a passed anonymous table without changing table buffer contents

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

This cool technique comes out of an issue that I was working on as part of a support case.  I will not go into specifics, but will explain what was happening.

We have a Dexterity window which reads a table and displayed information from that table to the window.  However, not all the fields in the table have associated window fields, so some of the fields are read and changed using the table buffer.  When the record is saved, the table buffer changes are written down to the physical table.  All sounds fine.

Continue reading

Improving Performance Accessing Tables in Dexterity

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Here are a couple of really cool tricks that can boost performance of your Dexterity code for almost no effort at all.  The techniques discussed below can significantly speed up accessing table buffers in functions and procedures when looping through a range of records in a table.

Continue reading

Safepay Integration

Dave Dusek - Click for blog homepageThis is a reposting of an article Dave Dusek originally wrote on my Developing for Dynamics GP blog.

Recently, I have been getting a lot of customization requests for Safepay, specifically, adding information into the detail line in the safepay file.  Safepay customizations like that are pretty much all the same thing, no matter what field you want to add, so I figured I would share my integration point and how to handle these types of customizations.  I have done probably 4 or 5 of these in the last couple of months.

Continue reading

Debugging ISV Application Crashing Dynamics

Patrick Roth - Click for blog homepageThis is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

I recently had a case that I thought I’d share with you. A well known ISV opened an incident with Developer Support to help solve an issue at their customer site.

This ISV has an application that encrypts certain sensitive data in the custom application in the ISV’s custom table in their own Dexterity based window.

The complaint given: After opening the custom window and making the application perform the decrypted data, when the window closes and the Dynamics navigation shell has focus – Dynamics GP crashes with the “Dynamics Runtime has encountered an error and needs to close..” dialog.

Continue reading

Accessing a Table Buffer when it is not passed as a parameter

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

This post is a follow up to the previous posts on the Three Trigger Technique. If you have not read the posts explaining this technique, please use the links below:

The idea of the three trigger technique is to use a trigger on an unrelated function or procedure call to get the timing you require for your code.  The 1st and 2nd triggers are used to ensure that the 3rd trigger is only used when it is called from your desired parent script.

Continue reading

VBA – Determine if the Caps Lock button is enabled on Password entry

Patrick Roth - Click for blog homepageThis is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

With password policies in place in Dynamics 10.0 RTM, it was easy to be able for your user to ‘lock themselves out’ after a mistyped password or two.

Because Dynamics GP doesn’t give you any kind of warning that the Caps Lock key is enabled, the user wouldn’t necessarily notice this is the real issue and not a typo and all of a sudden you are locked out.

Continue reading

Using the Dexterity Three Trigger Technique Part 2

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

In the previous part of this post we discussed the theory of the Three Trigger Technique and the details of a problem that was solved using this technique.

This post will cover the actual solution used and has the scripts used so you can see the techniques in action.

Continue reading

Using the Dexterity Three Trigger Technique Part 1

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

When working with Dexterity triggers, the hardest part of the process is working out where to place the triggers. There are times where it seems impossible to get the trigger you need in the correct location. This post explains the concept of what I call the Three Trigger Technique. The technique involves using a trigger on an apparently unrelated function or procedure which executes at the appropriate point within the code of the function or procedure. Let me explain in more detail …

Continue reading

Dex – Filtering a Third Party Lookup

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

When I started this blog, one of my goals was to help developers push the boundaries of what they believe is possible. This was the foundation of the materials presented at conferences by myself and Mark Rockwell.  For more information on the conference sessions and materials have a look at the Cross Dictionary Dexterity Development post.

Continue reading