Customising the Company Login window series – Visual Studio Tools revisited – Visual Basic .Net

David Meego - Click for blog homepageFollowing on from my last post, Customising the Company Login window series – Visual Studio Tools revisited – Visual C#, where I completed the Customising the Company Login window customisation using Visual Studio and Visual C#, I wanted to create the same example using Visual Basic .Net.

Thanks to Tim Wappat from the Dynamic Coding Blocks blog for his post which helped me get past the issues I was having accessing the Continuum Integration Library:

Continue reading

Customising the Company Login window series – Visual Studio Tools revisited – Visual C#

David Meego - Click for blog homepageJust before I left Microsoft, I was writing a series of blog articles about Customising the Company Login window so that you could see the full company name in the drop down list for long company names.

I had shown how to achieve the customisation with Dexterity and with Visual Basic for Applications, but was having problems getting it to work from Visual Studio Tools.

Continue reading

Customising the Company Login window series Part 4 – Visual Studio Tools

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

GP Power Tools – Administrator Tools Module can provide this functionality without needing customizations. (http://WinthropDC.com/GPPT)

Following on from my previous posts: Customising the Company Login window series Part 1 – IntroductionCustomising the Company Login window series Part 2 – Visual Basic for Applications and Customising the Company Login window series Part 3 – Dexterity, here is a discussion about trying to create a solution using Visual Studio Tools.

Continue reading

Menus for Visual Studio Tools Portal

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 (http://winthropdc.com/VSIT)

Continue reading

Menus for Visual Studio Tools Build 9 for Microsoft Dynamics GP 2013 Released

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

With the release of Microsoft Dynamics GP 2013, I am pleased to announce the release of Build 9 of Menus for Visual Studio Tools for Microsoft Dynamics GP for version GP 2013 (v12.0).

Continue reading

Why making the Dex.ini file read only is evil

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

Time and time again I have heard consultants say that the solution to stopping Microsoft Dynamics GP remembering the last user on a Terminal Server or Citrix installation is to make the Dex.ini file read-only.  There was even a Knowledge Base (KB) article that suggested clearing the SQLLastUser setting from the Dex.ini file and then marking the file as read-only.  Well, in my opinion this method has always been evil and from Microsoft Dynamics GP 10.0 onwards will not work anyhow.

Continue reading

Menus for Visual Studio Tools Build 9 Released

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 (http://winthropdc.com/VSIT)

Well, it has taken a little longer than orginally planned, but I am pleased to announce that Menus for Visual Studio Tools build 9 has now been released for Microsoft Dynamics GP 10.0 and Microsoft Dynamics GP 2010 (v11.0).

Continue reading

VBA – Adding Extender Windows to GL Transaction Entry Lines

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

Last week I had an interesting support case that I thought I would share with you.

The customer had created an Extender window to capture additional information for distribution lines on the General Ledger Journal Entry (GL_Transaction_Entry) window. The unique identifier for a distribution line is the Journal Entry field from the main window and the Sequence Line field from the scrolling window. These are the fields used when creating the Extender settings for the additional information to be stored.

Continue reading

VBA – Calling a Report using Visual Basic for Applications

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

I was recently asked about a forum post of mine from a few years ago. It was about how to call a Dexterity report from Visual Basic for Applications (VBA).  I checked the blog and could not find a post that showed the code in its simplest form.  So here one is…

Continue reading

Automating or Customizing the Report Destination Window

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

I have seen this issue come up a number of times.  Trying to automate processes which involve reports and wanting to automate the Report Destination window.  Sometimes you can add the Report Destination to Visual Basic for Applications (VBA) and sometimes the system will not add the window to VBA.  This post will explain the reason for this “weird” behavior.

Continue reading

Hybrid – Setting a push button to Hyperspace

Patrick Roth - Click for blog homepageThis is a reposting of an article Patrick Roth originally wrote on my Developing for Dynamics GP blog.

Trivia question for today:

Given the following sequence of events:

In Microsoft Dynamics GP, in a control field such as Customer Number, the user types in “AARON”. The user then presses the associated lookup button.

Continue reading

Hybrid Development and Continuum

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

In the past, I was known for my pioneering work with and promotion of Cross Dictionary Dexterity Development.  More recently I have been talking up the benefits of Hybrid Development and Developing Outside of the Box.

Continue reading

Using Integration Manager with Analytical Accounting

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

When you use Integration Manager on a system with Analytical Accounting (AA) installed, integrations often fail because Analytical Accounting will open windows which are unhandled by Integration Manager. However, there are time when you still want to use Integration Manager to import transactions where the Analytical Accounting information is left blank. This post provides three methods of how to make Integration Manager work when Analytical Accounting is installed.

Continue reading

Developing Outside of the Box

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

Continue reading

Hybrid – Adding Named Printers control to Reports using VBA

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

Named Printers is a module to allow controlling of the printer and settings used when printing reports.  It was originally developed for v3.00 by me while I was working for Sequel Technology (that’s why the tables and calls are prefixed with ST).  Later it was purchased by Great Plains for v5.50 and included in core code (Dynamics.dic) for v6.00 onwards.

Continue reading

Can I customise a 3rd party form with Dexterity?

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

Over the last few weeks I have been asked a number of times about methods of customising a 3rd party form.  This purpose of this post is to clarify what can and cannot be achieved with Dexterity.

Continue reading

Hybrid – Using Menus for Visual Studio Tools from VBA Example

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

After the release of Menus for Visual Studio Tools for Microsoft Dynamics GP 10.0, my good friend Mariano Gomez asked me if it was possible to use the tool to add menus from Visual Basic for Applications (VBA).

Continue reading

Hybrid – Purchasing Terms & Conditions Example

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.

Continue reading

Hybrid – Cheque Amount in Words Example

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.

Continue reading

Menus for Visual Studio Tools – The wait is over

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 (http://winthropdc.com/VSIT)

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

Continue reading