Home
»
Microsoft Dynamics GP
»
Developing for Microsoft Dynamics GP
»
All Tags
»
Advanced Topic
Browse by Tags
Application
Best Practice
Cross Dictionary
Development Tools
Dexterity
Encryption
Exception
Featured
Passwords
Performance
Pushing the Limits with Dexterity
Quick Tips
Report Writer
SQL
Support
Support Debugging Tool
Triggers
VBA
Visual Studio Tools
Windows 7
Related Posts
Blog Post:
Quick Tip: Handling scripts that use old() when using triggers to set default values
Developing For Dynamics GP
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. The Scenario The customisation required is fairly common. The customer...
on
10 Mar 2013
Blog Post:
How to create Dexterity Cross Dictionary Lookups
Developing For Dynamics GP
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...
on
16 Dec 2012
Blog Post:
Update: Resizing SmartList TreeView and ListView panes using the Support Debugging Tool
Developing For Dynamics GP
As promised in my post Quick Tip: Creating a Splitter control between panes of a window with Dexterity , I have updated the concept of my previous post: Resizing SmartList TreeView and ListView panes using the Support Debugging Tool to use a Splitter control rather than selecting a percentage via a menu...
on
4 Dec 2012
Blog Post:
Quick Tip: Creating a Splitter control between panes of a window with Dexterity
Developing For Dynamics GP
For many years Dexterity developers have wanted to be able to add a splitter control to windows with "panes" created with lists, treeviews or listviews. Using the window Object property Resizeable set to True-Per Field, developers have created windows which can be resized but the join between...
on
2 Dec 2012
Blog Post:
Quick Tip: How to remove an alternate window from your Dexterity development environment
Developing For Dynamics GP
One great thing about doing the job I do as an Escalation Engineer on the Asia Pacific Microsoft Dynamics GP support team is I have no end of support cases from which to draw ideas for blog posts from. So here a Dexterity case I helped with recently. The Problem The question from the Dexterity...
on
30 Oct 2012
Blog Post:
Further Update: Obscuring Table Data Fields using the Support Debugging Tool
Developing For Dynamics GP
A while back, I posted some articles which used the Support Debugging Tool and non-logging Automatic Debugger Mode triggers to " encrypt " data. The use of the word " encrypt " was unwise as it has connotations about providing a level of security and possible compliance with various...
on
9 Oct 2012
Blog Post:
Update: Adding Window Size and Position Memory using the Support Debugging Tool
Developing For Dynamics GP
While I am updating examples, I have made some changes to the Adding Window Size and Position Memory using the Support Debugging Tool sample code. The original version used the Dex.ini to store the window size and position as a setting, for example: MBS_Win_POP_PO_Entry_POP_PO_Entry=-400,-118,664...
on
20 Aug 2012
Blog Post:
Update: Obscuring Table Data Fields using the Support Debugging Tool
Developing For Dynamics GP
A little while ago, I posted an example of Obscuring Table Data Fields using the Support Debugging Tool . During my recent Dexterity Training class , I showed this example to the attendees and was asked about how the obscuring worked with reports. So, as a test, we printed the RM Customer Report...
on
19 Aug 2012
Blog Post:
Determine Company_Options from DYNAMICS.dbo.SY01500 (Reading a Multi-Select List Box)
Developing For Dynamics GP
A recent post on DynDeveloper.com caught my eye as I have faced a similar problem before and had to work quite hard to get the correct answer. The post was titled: Determine Company_Options from DYNAMICS.dbo.SY01500 and asked how to figure out how to interpret the binary(4) field. I realised that...
on
5 Aug 2012
Blog Post:
Resizing SmartList TreeView and ListView panes using the Support Debugging Tool
Developing For Dynamics GP
This article is another Support Debugging Tool Non-Logging Trigger example and is a follow up to two previous articles: From this blog: Adding Window Size and Position Memory using the Support Debugging Tool From Mark Polino: Dynamic Future - Vote - Resize the Left Pane on Smartlists...
on
19 Jul 2012
Blog Post:
Adding Window Size and Position Memory using the Support Debugging Tool
Developing For Dynamics GP
As a follow on to the article: Using Support Debugging Tool Non-Logging Triggers , I thought I would post a few small examples of how Non-Logging Triggers can be used for simple customizations. There have been some other examples posted in the past on this and other blogs. If you are interested have...
on
17 Jul 2012
Blog Post:
How to calculate Aging Buckets based on documents shown on a Receivables Statement
Anonymous
I had a case a couple of weeks back, where the customer wanted to filter the transactions shown on a Receivables Management Statement. There was one type of transaction that they did not want included on the statements sent out to the customers. The transactions to be excluded could be identified by...
on
12 Jul 2011
Blog Post:
How to access data from other companies from Dexterity
Anonymous
Have you ever had to develop Dexterity code that needs to read data from a company other than the current Microsoft Dynamics GP company? Well, with my latest updates to the Support Debugging Tool , I came across this requirement. While developing the support for the Extender security objects, I realised...
on
23 Jun 2011
Blog Post:
How to add Item Category Long Descriptions to reports using the Support Debugging Tool
Anonymous
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...
on
23 May 2011
Blog Post:
How to read a Dexterity Script Profile to solve Performance Issues
Anonymous
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. The customer...
on
13 May 2011
Blog Post:
Quick Tip: How to create conditional Triggers in Dexterity
Anonymous
Here is another Quick Tip article. This time I wanted to discuss the best practices for making conditional triggers in Dexterity. There are times where we might want to have a trigger which only runs under certain circumstances. There are a number of methods of handling these situations. This post...
on
9 May 2011
Blog Post:
Quick Tip: Understanding the Dexterity Reject Script command
Anonymous
This is a Quick Tip post to explain how the Dexterity Reject Script command works. The Reject Script command is designed to be used in trigger scripts to stop the original code from running. However, it only works in specific situations: The trigger MUST be a Focus trigger on a user interface...
on
27 Apr 2011
Blog Post:
Working with Temporary Files in Dexterity
Anonymous
Keeping with the theme of my previous post , I have another "Temporary" topic to discuss. Dexterity developers sometimes need to write out files (usually text files) to a location. This could be for a variety of purposes, including: to create a file for integration into an external...
on
27 Oct 2010
Blog Post:
Working with Temporary Tables in Dexterity
Anonymous
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. Working...
on
25 Oct 2010
Blog Post:
Writing to An Event Log in a Visual Studio Tools Customization
David Musgrave [MS]
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. This works...
on
15 Oct 2010
Blog Post:
Changing Dictionary Context when using Passthrough Dexterity sanScript Part 2
Anonymous
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...
on
13 Jul 2010
Blog Post:
Changing Dictionary Context when using Passthrough Dexterity sanScript Part 1
Anonymous
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...
on
11 Jul 2010
Blog Post:
Getting Table and Field Data out of Dexterity Dictionaries
Anonymous
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...
on
7 Jul 2010
Blog Post:
Dex - How to work with a passed anonymous table without changing table buffer contents
Anonymous
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...
on
13 Jun 2010
Blog Post:
SQL DB Insert Trigger Breaks Dexterity Active Locking
Anonymous
An issue came up recently that I thought I'd share with our readership. The customer is using SQL insert database triggers on various Dynamics GP tables and running into an issue. I don't have the full details on the "how, why, and what" but I do know the result of the issue they...
on
11 Jun 2010
1
2