Re-purpose Connect Section of Home Page

Microsoft Dynamics GPI am taking a slight diversion from posting about being hands on with the new functionality of Microsoft Dynamics GP 2018 R2. In the last post, I covered how to re-purpose the Intelligent Edge page; there s a similar re-purposing which can be done to the Connect section of the home page. This was originally posted by MVP Mariano Gomez back in 2014.

There are two Dex.ini switches which need to be added for the Connect section to be re-purposed. Once they’re in place, it will look like the below:

Connect section repurposed

Continue reading “Re-purpose Connect Section of Home Page”

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”

Doc Attach Button in Notes Window Missing

Microsoft Dynamics GPAfter a clients system was upgraded a while ago from Microsoft Dynamics GP 2010 SP3 to Microsoft Dynamics GP 2018, we enabled the Document Attachment feature for the client to use. Unfortunately when showing the client how to use the feaute, we found that the Doc Attach button was missing (the red square is where the button should be):


Continue reading “Doc Attach Button in Notes Window Missing”

Microsoft Dynamics GP Macros: Playing A Macro Quickly

Microsoft Dynamics GPIn this series I am taking a look at how macros can be used to update data in Microsoft Dynamics GP.

As I said in the last post, which covered the playing of a macro, in this post I am going to show how the macro can be played quicker than using the standard Play option.

Credit for this one goes to MVP Leslie Vail, who blogged about it back in 2014. There is a Dex.ini setting which needs to be set to make this function available:


This needs to be configured on any client machine which will be used to run macros. If you are a user of the GP Power Tools you can use the Dex.ini Configuration to roll out this switch to all clients:

User Setup

Continue reading “Microsoft Dynamics GP Macros: Playing A Macro Quickly”

Hands On With the GP Power Tools – Administrator Tools: Company Login Filter

Winthrop DCThis post is part of the Hands On With the GP Power Tools (GPPT) – Administrator Tools series in which I am taking a hands on look at the various tools offered by GPPT.

The Company Login Filter window (GP Power Tools area page >> Setup >> Company Login Filter) is used to set up filtering of the companies available in the Company Login window for a user depending on the instance of the application environment currently being used. This is useful functionality as, on a system with different customization dictionaries or different custom forms and reports for different companies, you can ensure that the correct companies can only be used with the appropriate application client.

This is a scenario used by a number of my clients, so I was interested in doing some testing of this function. The way we’ve dealt with it in the past it to giev the client two shortcuts, looking at different launch files.

There is two ways of configuring this tool, but I am only looking at one of them. I have a single Dex.ini file and two launch files in the application folder; the default DYNAMICS.SET and a DYNAMICS-UK.SET which is pointing at different report and forms locations.

To configure the company login filters, launch the window and enter a Profile ID and Profile Name.

The left scrolling window will populate with the profile ID and a branch for Default Filter when no Path matched. Select this and then mark one (or more) of the companies listed in the right window:

Company Login Filter - select companies for no filters.

Continue reading “Hands On With the GP Power Tools – Administrator Tools: Company Login Filter”

Hands On With the GP Power Tools – Administrator Tools: Dex.ini Configuration

Winthrop DCThis post is part of the Hands On With the GP Power Tools (GPPT) – Administrator Tools series in which I am taking a hands on look at the various tools offered by GPPT.

The Dex.ini Configuration (GP Power Tools area page >> Setup >> Dex.ini Configuration) window can be used to automate changes to the Dex.ini settings for all workstations. This is a very useful tool, especially when there are either a lot of desktop clients installed or a lot of Citrix/terminal servers:

Dex.ini Configuration

Continue reading “Hands On With the GP Power Tools – Administrator Tools: Dex.ini Configuration”

MDGP 2016 R2 Feature of the Day: GL Distribution Line Display UI Change

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2016 R2; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily.

The series index for this series of posts is here

The seventh Feature of the Day is GL Distribution Line Display UI Change.

Transaction Entry

With this new feature, General Ledger Transaction Entry and Journal Entry Inquiry windows will default the scrolling window expanded or collapsed based on the previous display state.

This is promised to be a user based default, so it will be interesting to see if it is actually user based or based upon the Dex.ini file which would make it a machine setting rather than a user one.

Click to show/hide the MDGP 2016 R2 Feature of the Day Series Index

Dex.ini Switch To Prevent Users Changing DSN

Microsoft Dynamics GPThere are a lot of switches available which can be added to the Dex.ini file; Leslie Vail did a post back in February 2014 where she listed all of the switches she knows (and a long list it is too).

I need to have a proper through Leslie’s list again soon as there are some very useful switches. Two that caught my eye recently, which are on Leslie’s list, were actually posted by Béat Bucher on the Dynamics Community Forum (I was searching for something else when I found the post):

SQLLastDataSource=Dynamics GP

These switches set the last DSN used and then disable the Server drop down to stop users changing it. This is useful when there are several DNSs created on the client machine (required for other applications), but only one of them is for Dynamics GP.

Reports Print With Overlapping Text

Microsoft Dynamics GPI had a curious one a few months ago (which I forgot to post). A client I was implementing Microsoft Dynamics GP for encountered a problem whenever they printed a report; all of the text was overlapping:

Overlapping text on report

If a document was printed from Microsoft Word it was fine; if a GP report as printed to XPS and then sent to the printer from there then it was also fine. It was just the reports printed directly from Microsoft Dynamics GP which had the overlapping text problem.

Doing some more testing I was able to narrow the problem down further, from thinking it was all GP reports, to only the text based reports. Not having seen this problem before I thought a quick online search might find me an answer.

And it did; I found an old post from David Musgrave on the Developing for Dynamics GP blog where he covers how to change the font used for Text reports.

By using the information in David’s post to update the settings in the dex.ini file I was able to resolve the problem.

I added the following lines to the dex.ini file on each client (and left notes with the client’s IT department so they could do this on any new installations):

FontCourier New=Lucida Console

Hiding The Fabrikam Demo Company Date Warning

Microsoft Dynamics GPWhen doing sales demos or testing I tend to use the Microsoft supplied demo database to save time on rolling my own.

One annoyance in it is the warning message that is displayed when logging into Fabrikam;

Microsoft Dynamics GP - You have chosen to use the sample company, which provides data that you can use to practice procedures or learn nore about the product. When you use this sample company, the date is automatically set to April 12, 2017.

Continue reading “Hiding The Fabrikam Demo Company Date Warning”