Click here to
Subscribe to
our Newsletter
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
This example shows how you can call a Dexterity report from Visual Basic for Applications (VBA). The report can be either a built in report or a custom report. If a built in report is used security will define whether the original, modified, alternate or modified alternate version will be printed.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
One of the Report Writer functions added to v7.00 onwards (see Using the built-in Report Writer Functions) was the RW_ConvertToWordsAndNumbers() function to convert a currency amount into words. After the code was added, it was realised that Report Writer calculated fields of return type string are limited to 80 characters. This means that if your amount in words is longer than 80 characters, only the first 80 characters will be returned and the rest will be truncated and lost.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The following VBA example shows how you can set a lookup window to open with a default sort order. The reason that this is normally difficult is that the usual methods that people use to set defaults with VBA do not work on lookup windows.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
I spent this morning discussing a very interesting customisation with my good friend Mariano Gomez. We had both seen a newsgroup posting asking if it was possible to add access to the Item Master’s record note from the Item Inquiry window using VBA. Mariano had told me that he wanted to see if he could do it and this morning sent me the first version of his code as a package.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The following VBA example shows how a macro file can be started from VBA. This particular example will close Microsoft Dynamics GP when the Check Links window closes. As macros wait for background processes to complete, the macro will not start until the Check Links process and report have completed.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
The following VBA example adds the Sales Order Processing User Defined 3 field onto the Receivables Transaction Inquiry window.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
For those of you who have been involved with the Great Plains product for a while, you will remember the “Welcome to Dynamics” wave that played when the application was launched. Well, if you want that functionality again, you can use VBA to add it back.
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
If you have not read part 1 of this posting it can be found using the link below:
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
From Microsoft Business Solutions – Great Plains v8.00 onwards the system has included a User Login Activity window which can be used by a user to remove their own login record after it has been left stranded by an abnormal termination of the application (read “crash”).
This is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.
A long time discussion in the Microsoft Dynamics GP world is how to handle the distribution of customizations and updates. There are a number of approaches available and this article discusses the benefits and issues of the different configurations.