Click here to
Subscribe to
our Newsletter
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The question in more detail is whether it is possible to print “Page: Y/X” or “Page: Y of X” on a Report Writer report, where Y is the current page number and X is the total number of pages for the report.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The Support Debugging Tool for Microsoft Dynamics GP has the ability to create triggers against Functions and Procedures (both global level and form level). While this functionality allows us to identify when a particular function or procedure has been executed, it is unable to obtain the parameters used when the call is made.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Another recent request was to provide a method to prevent backdated transactions from being entered into Microsoft Dynamics GP. This means that we needed to validate the document date of a transaction as it as entered and again when it is saved. This is a perfect opportunity to demonstrate how Visual Basic for Applications (VBA) can add custom business rules to the application.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I recently had a support case where the partner consultant was trying to use the RW_ConvertToWordsAndNumbers() report writer user defined function to display the Purchase Order total in words at the bottom of the document.
This is a reposting of an article Dave Dusek originally wrote on my Developing for Dynamics GP blog.
This is a quick and easy way to add items to the AutoComplete list for a field. I’m talking specifically about the AutoComplete property on a field.
This is a reposting of an article Dave Duesk originally wrote on my Developing for Dynamics GP blog.
This is really an extension of the blog article that David Musgrave wrote VBA – Welcome to Dynamics Example, but instead of using VBA to play the sound file, we are using Dexterity. The same method is called in the winmm.dll, but this is just the Dexterity way to do it. I didn’t include trigger information on this because you could really put this anywhere.
This is a reposting of an article David Clauson originally wrote on my Developing for Dynamics GP blog.
SUMMARY
Data being integrated with eConnect is leaving records in Microsoft Dynamics GP tables when there is an error being returned. eConnect should be rolling back the data out of Microsoft Dynamics GP tables.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Doug Pitcher on the Rose Business Solutions blog (now Armanino Blog) had me laughing with his post The famous David Musgrave.
He has coined the term “Musgravion” to mean followers of my opinions and ways.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
Dexterity has a long development history, dating back to the late 1980’s. There were many people involved in the design, development, testing and documentation of Dexterity. If you want to see some of these names, you can use a little bit of code to open the Hidden_About form in the Dex.dic dictionary. The Dex.dic is available as dictionary ID 1, even though it does not appear in the Dynamics.set launch file.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
As a follow on from the post last week on capturing the logging in and logging out events in Microsoft Dynamics GP, I want to cover how to open a form after logging into Microsoft Dynamics GP. This could be a hidden form used by your code or a window that you want to open automatically.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
A while back I did a post on running Visual Basic for Applications (VBA) scripts when logging into and out of Microsoft Dynamics GP.
Recently, I was asked about the best method of capturing the same events from Dexterity.
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).
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.
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.
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 …
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.
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.
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.
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.
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.