Short URLs Available on Microsoft Dynamics GP Table Reference

Microsoft Dynamics GP Table ReferenceI have deployed my URL Shortener plugin on the Microsoft Dynamics GP Table Reference site which should assist you in locating the page for a table when you already know the table’s physical name.

If, for example, you wanted to view the page for PM Key Master File (PM00400) you would, without the URL shortener, have to type the full page string:

http://gptables.azurecurve.co.uk/products/microsoft-dynamics-gp-0/purchasing/payables-key-master-logical-file/pm-key-master-file-pm00400/

With the URL shortener, all you need is the table name:

http://gpt.azrcrv.co.uk/pm00400

To load the page for the table you want (and this is for any of the GP tables on the site), just type gpt.azrcrv.co.uk/ followed by the table name you want to see.

I know they’re not the shortest URLs in the world, but they should be a big help for viewing the tables when you know the table name and want field information.

Workaround to Workflow Notification View/Edit Link Doesn’t Work on Outlook 365 Online

Microsoft Dynamics GPThe other day I posted about a problem with the online version of Outlook in Office 365 stripping the View/Edit link from the Workflow notification emails. This was confirmed as a bug with the online version of Office 365 with a recommendation from Microsoft Dynamics GP Support to raise a call with the Office 365 team.

That’s going to be a long term solution to the problem, where the client would much rather have a fix in the short term.

Well, no fix in the short term, but I realised there was probably a very simple workaround to the problem.

I constructed a custom link on the Email Message which has the same query string as the normal drill down link, but I replaced the dgpp and server parts of the link with a link to a custom page on my website (see selected section):

Message Setup

<a href='https://www.azurecurve.co.uk/mdgp.php?Db=GP&Srv=SERVER&Cmp=IDEAL&Prod=0&Act=OPEN&Func=OpenReqInq&sReqID={%Requisition Number%}&bHistory=0'<{%Requisition Number%}</a>

The PHP webpage I created is configured to do a redirect to the dgpp drill down link used by Microsoft Dynamics GP and append the query string from the email hyperlink:

<?php
	header('Location: dgpp://DGPB/?' . $_SERVER["QUERY_STRING"], true, $statusCode);
?>

When I tested this on my demo environment it worked perfectly. I then passed it across to the client and they are currently testing.