What is the Dynamic User Object Store (DUOS)
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The Dynamics GP Blogster, Mariano Gomez, has written a great article on the Dynamic User Object Store (DUOS).
Identifying Payables Transactions with Missing Apply Records
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From the Useful SQL Scripts Series.
I was assisting on a support case recently where we needed to identify transactions in Payables Management history which had missing Apply records. We wanted to add up the total of the Apply records and make sure that they matched the value of the original document amount.
Using the Dexterity Three Trigger Technique Part 2
This 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.
Using the Dexterity Three Trigger Technique Part 1
This 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 …
How to read your own config file with a VSTools Application
This is a reposting of an article Dave Duesk originally wrote on my Developing for Dynamics GP blog.
This article is a result of a couple of recent support incidents where developers would like to read a config from from a Visual Studio Tools (VSTools) addin. VSTools is a special situation because for one, it is a dll, not an exe, and second it only runs if GP is running. VSTools can automatically access the dynamics.exe.config file, steps on how to do that are outlined in KB Article 933930 (Not available). The KB is for 9.0 and references the Dynamics.config file, but it also works for the Dynamics.exe.config on 10.0.
Drag and drop into folders in the 10.0 Navigation/shortcut window
This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
A question was posted to the newsgroups recently that reminded me that I had also run into the same situation previously.
I was trying to drag a shortcut into a folder that I had also created and it wouldn’t drag & drop for me in my Dynamics GP 10.0. I went back to 9.0 and had no issue doing this but it just wouldn’t work in 10.0.
Dexterity: Creating custom ini files
This is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.
One question that I’ve been asked a few times in the past has been – “Can I read/write to other sections of the Dex.ini other than the [General] section with Dexterity?”.
Here I presume the questioner would like to have their own section of the dex.ini file to write their own application settings instead of mixing them into the settings that Dynamics GP uses.
Creating SQL Views of DUOS Data
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Visual Basic for Applications (VBA) can use the Dynamics User Object Store (DUOS) table to store additional data such as user defined fields.
The SY_User_Object_Store (SY90000) DUOS table uses a single row for each field stored, It stores the data in a string field 132 characters long.
Developing Outside of the Box
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Recently I responded to a question on a newsgroup asking how to minimise a window from VBA (Visual Basic for Applications).
The short answer is that it is not possible. But just because a Microsoft Dynamics GP window VBA object does not expose any methods or properties for the window state does not mean we have to give up.
Working with Unrestricted Database Triggers
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I recently responded on a Newsgroup posting where the developer was wanting to identify a table delete event from a particular form. However, the delete event was happening in a function or procedure that did not pass a form’s table buffer as a parameter and so did not use a form level table buffer belonging to any form. This means that it was not possible to use a form restricted database trigger, but using an un-restricted database trigger was picking up table delete events from multiple forms.
So how can I identify when the database event is being generated from the form I am interested in?