David Meego - Click for blog homepageThis 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.

Read more →

David Meego - Click for blog homepageThis 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.

Read more →

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

IMPORTANT NOTICE: Menus for Visual Studio Tools is now Visual Studio Integration Toolkit from Winthrop Development Consultants (https://winthropdc.com/VSIT)

Some brilliant news for Microsoft Visual Studio developers who use Visual Studio Tools to integrate with Microsoft Dynamics GP 10.0.

Read more →

David Meego - Click for blog homepageThis 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.

Read more →

David Meego - Click for blog homepageThis 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.

Read more →