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

Following on from my previous posts: Customising the Company Login window series Part 1 – Introduction, Customising 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. As discussed in…

2

Menus for Visual Studio Tools Portal

IMPORTANT NOTICE: Menus for Visual Studio Tools will be available from Winthrop Development Consultants (http://winthropdc.com/MVST) This is the portal page for Menus for Visual Studio Tools for Microsoft Dynamics GP. Find this page using the shortened URL: https://aka.ms/MVST For GP 2013 (v12.0): Current release is Build 9 (Last Modified: 11-Dec-2012).For v10.0 & GP 2010 (v11.0): Current release is…

8

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

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). This release for Dynamics GP 2013 is based on the Build 9 code from Dynamics GP 2010 and adds no new features other…

1

Why making the Dex.ini file read only is evil

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…


Menus for Visual Studio Tools Build 9 Released

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). When Menus for Visual Studio Tools for Microsoft Dynamics GP 10.0 was first released, the plan was that…


VBA - Adding Extender Windows to GL Transaction Entry Lines

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…


VBA - Calling a Report using Visual Basic for Applications

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… This technique used the unsupported method…

16

Automating or Customizing the Report Destination Window

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…

14

Hybrid - Setting a push button to Hyperspace

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. What happens? A. Focus moves to the button causing the field change script to run and validates that Customer Number “AARON”…

0

Hybrid Development and Continuum

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. With all the tools available to the Microsoft Dynamics GP developer, and each tool having its strengths and weaknesses, it…

5

Dexterity Training in Orlando (Oct 5th to 9th 2009)

Now is your chance.  If you have not attended a Dexterity Training class and are either new to Dexterity or want to get started with Dexterity, this is an opportunity that should not be missed. My good friend, Leslie Vail, will be training the 5 day Dexterity I (also known as Dexterity Fundamentals) course in…

0

Using Integration Manager with Analytical Accounting

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…

10

Developing Outside of the Box

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…

9

Hybrid - Adding Named Printers control to Reports using VBA

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…

2

Can I customise a 3rd party form with Dexterity?

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. Usually, the developer has created a combined dictionary as per the instructions in the Integrating with Third Party…

21

Developer Documentation for Microsoft Dynamics GP

I found some great reference pages on PartnerSource and CustomerSource today. They are the Developer Documentation pages for Microsoft Dynamics GP 9.0 and 10.0.  They contain links to information about every customisation tool available as well as links to white papers comparing the tools and the architecture of Microsoft Dynamics GP. The pages below will be a…

3

Hybrid - Using Menus for Visual Studio Tools from VBA Example

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). Mariano was initially working on an approach that would expose the Menus for Visual Studio Tools .NET assembly to…

3

Hybrid - Cheque Amount in Words Example

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…

15

Hybrid - Purchasing Terms & Conditions Example

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 specific example will…

3

Menus for Visual Studio Tools - The wait is over

Some brilliant news for Microsoft Visual Studio developers who use Visual Studio Tools to integrate with Microsoft Dynamics GP 10.0. Menus for Visual Studio Tools for Microsoft Dynamics GP 10.0 has now been released on PartnerSource  and CustomerSource . While I was in Fargo, ND for the Microsoft Dynamics GP Technical Airlift 2008 last May, I spent some…

26