How to Set the Tab Sequence Order in Microsoft Dynamics GP Modifier

Microsoft Dynamics GPWhile created a new version of a customised window for a client (the old customised version was causing problems for submission to Workflow) I needed to change the tab order of the fields on the window; I’d removed quite a few fields and changed the positions of the remaining.

I couldn’t remember how to do this (I last remember doing this in Visual Studio where you can select a field and change the tab order directly) so a quick online search found me a blog from David Musgrave, originally on the old Developing for Dynamics GP blog and now on his Winthrop DC blog.

The short version is to click Layout » Set Tab Sequence and then tab through the fields, double-clicking a field to change the order:

Set Modifier tab order

When doing this make sure you tab through fields, even after double-clicking to change the order, or odd tab ordering will result.

David’s blog post has a lot more detail available on preparatory steps, steps to accomplish the reordering as well as cautions on what to be careful.

Remove Modified Window From Microsoft Dynamics GP

Microsoft Dynamics GPIf you have a modified window which is no longer required, it is fairly easy to remove (although these steps will need to be repeated on each client).

To remove the window, open Modified (Microsoft Dynamics GP menu » Tools » Customize » Modifier):

Microsoft Dynamics GP showing Customize menu

Continue reading “Remove Modified Window From Microsoft Dynamics GP”

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Repurposing the Intelligent Edge page

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The first feature, I am hands on with, is not one of the announced features. Instead it is a new addition to the Home Page of Microsoft Dynamics GP; Intelligent Edge. I first encountered it when I ran the Dynamics GP 2018 R2 client for the first time. I said when I first saw it, that it was not going to be either welcome or useful to clients.

I also said that I hoped someone would find a Dex.ini switch which could be used to switch it off, or re-purpose it to another site such as an Intranet site. Well, MVP David Musgrave has taken a look through the code and found three settings in the Dex.ini file and two messages which need to be updated.

Once this has been done, Intelligent Edge will be no more; instead a useful page can be displayed:

Repurposed Intelligent Edge

Continue reading “Hands On With Microsoft Dynamics GP 2018 R2 New Features: Repurposing the Intelligent Edge page”

Form Customisation Errors Adding Fields To VBA

Microsoft Dynamics GPSince the introduction of the web client in Microsoft Dynamics GP 2013, I have tried to minimise the use of VBA as it is not supported by the web client. However, some clients don’t intend to use the web client and prefer to have a quick customisation to a window done using VBA rather than full development in Dexterity.

As such, I do still sometimes get work with Modifier and VBA. I recently did a change to a client where I added several fields to VBA on the Sales Transaction Entry window.

A little later I needed to add a new checkbox and add it to VBA. I customised the window in Modifier to add the field, but when I tried adding it to VBA I received an error I had not seen before:

Microsoft Dynamics GP - You are manipulating a modified window whose EventMode is set to emOriginalOnly. You must change this window

Microsoft Dynamics GP

You are manipulating a modified window whose EventMode is set to EmOriginalOnly. You must change this window's EventMode to emModifiedOnly before you can add this field.

Continue reading “Form Customisation Errors Adding Fields To VBA”

Microsoft Dynamics GP SmartList Default Visible To Company

Microsoft Dynamics GPIn July, as part of his weekly MS Connect suggestion series, Mark Polino raised the issue of SmartList Favourites and the default Visible To which is set to System.

Mark’s suggestion was to have the default changed to User which would leave a generally tidier list. To be honest I’d rather have a setting which allowed the default to be chosen by each client. The reason for this is we’re currently in the middle of an upgrade project where a few Microsoft Dynamics GP systems will be merged into one and it would be good to have the default Visib le to set to Company.

Following on from my recent post on a fixed width SmartList left pane I decided to have a fiddle and see if I could force the default to something else. And it turns out with some simple VBA that you can do exactly that;


Continue reading “Microsoft Dynamics GP SmartList Default Visible To Company”

Microsoft Dynamics GP 2013 SmartList Fixed Width Left Pane

Microsoft Dynamics GPIn July last year, Frank Hammelly posted a SmartList customisation for Microsoft Dynamics GP 2010 on his blog gp2themax.

I’ve recently been taking a look at Microsoft Dynamics GP 2013 and decided to see if I could use Modifier to reproduce this customisation for GP 2013 (I have no reason to believe the customisation posted by Frank won’t work with 2013, but I wanted to dabble with Modifer and this seemed a good starting point); the customisation can be downloaded at the bottom of this post.

The screenshots below show SmartList in both it’s default size and maximised with the left pane remaining a static size and the right pane occupying the rest of the window;


Continue reading “Microsoft Dynamics GP 2013 SmartList Fixed Width Left Pane”

Error When Switching Back To Microsoft Dynamics GP From Report Writer

Microsoft Dynamics GPI installed Microsoft Dynamics GP 2010 R2 onto my work laptop a few weeks ago, just after I started working for this company.

I needed a demo environment and so installed the most recent version. I’ve been getting an error since that time whenever I switched back from Report Writer to GP itself;

Unhandled script exception: Illega address for field '[Not Found]' in script 'Unregister_Triggers'. Script terminated.

Continue reading “Error When Switching Back To Microsoft Dynamics GP From Report Writer”

SmartList Pane Sizes

Microsoft Dynamics GPOne of my biggest problems with the SmartList in Microsoft Dynamics GP is the size of the two panes. The left hand pane resizes itself when you change the size of SmartList; when maximised it ends up being two fifths of the screen size which seriously cuts down the space for viewing the report.

But, now, help is at hand. Frank Hamelly, a Microsoft Dynamics GP MVP, on GP2themax has posted a modified SmartList window, from Nicole Albertson of Microsoft, which resizes the left pane.

The modified window is loaded in via Customisation Maintenance (Microsoft Dynamics menu » Tools » Customise » Customisation Maintenance) from a .package file and works by keeping the left pane a set size which maximises the pane showing the report data.

Hopefully, the next version of Microsoft Dynamics GP will come with a built in solution to this.