Microsoft Dynamics GP Workflow 2.0 Second Edition Now Available on Amazon

Microsoft Dynamics GPMy sixth book is now available to buy in both eBook format from azurecurve Publishing and paperback from CreateSpace, Amazon.com and Amazon.co.uk.

This is an update to the original Workflow 2.0 book I wrote a couple of years ago. This edition includes coverage of the new functionality introduced in Microsoft Dynamics GP 2016, a new chapter on adding table joins to workflow to allow additional conditions to be created, and some chapters and sections have been rewritten to either expand or make clearer the topics being covered.

Dynamics GP includes a variety of tools and modules to assist in controlling processes and data; one of the major modules for this was the Dynamics Workflow module. However, this module had major flaws which very much limited its usefulness; it was slow, clunky and difficult to install, configure and maintain.

eBook Paperback
azurecurve Publishing Amazon.com Amazon.co.uk

Continue reading “Microsoft Dynamics GP Workflow 2.0 Second Edition Now Available on Amazon”

Configuring Permissions to RDP to Server

Microsoft Dynamics GPThis is only something I need to do occasionally so am posting this as a reminder.

Most of the demo VMs I create are on my local Client Hyper-V, but occasionally I make one available to a prospect or client and need to give them a user other than the administrator account.

Creating the user account itself is easy, but the bit I usually fail to remember how to do, is to give the user the rights to sign in remotely.

When this right has not been granted, an error message like the below will be displayed:

To sign in remotely, you need the right to sign in through Remote Desktop Services. By default, members of the Administrators group have this right. If the group you

To sign in remotely, you need the right to sign in through Remote Desktop Services. By default, members of the Administrators group have this right. If the group you're in doesn't have this right, or if the right has been removed from the Administrators group, you need to be granted this right manually.

Continue reading “Configuring Permissions to RDP to Server”

Perfect Image ERP Practice Ready for #FabrikamDay

Microsoft Dynamics GPI imagine all Microsoft Dynamics GP partners are aware that Fabrikam Day is soon to be upon us (6 sleeps!). Amber Bell gives a good writeup of the origin of Fabrikam Day. The first sample company I remember working with is Fabrikam; I’m apparently a little too young to remember The World Online (which lives on in the default Fabrikam database name of TWO).

In advance of Fabrikam Day we got a couple of photos taken. The first is just me:

Ian Grieve, ERP Practice Manager at perfect Image and Microsoft Most Valuable ProfessionalIan Grieve, ERP Practice Manager at Perfect Image and Microsoft Most Valuable Professional

And also roped in the ERP Practice for a photo too: Continue reading “Perfect Image ERP Practice Ready for #FabrikamDay”

Hands On With Microsoft Dynamics GP 2016 R2: Web Services Runtime SQL Server Prerequisite

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

I’ve encountered this particular issue around the prerequisites so rarely, that I usually forget to mention it.

When installing the Web Services for Microsoft Dynamics GP there is a step where the SQL Server Connection Information is entered. This is the server where the Dynamics Security data will be stored.

You will receive the following message when clicking Next if the Windows user account you’re logged in as, is not a SQL Server sysadmin:

Invalid SQL Information - The current user must be a member of the sysadmin SQL role.

Invalid SQL Information

The current user must be a member of the sysadmin SQL role.

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Web Services Runtime SQL Server Prerequisite”

MS Connect Suggestion: Allow Additional Fields to be Avalable to Workflow Notification Emails

Microsoft Dynamics GPMy fourth Workflow suggestion has been submitted to Microsoft Connect for you to vote on.

The fields available to the Workflow email notifications are very limited, and there is no front end way of making them available. I’d like to see functionality added to Workflow Maintenance to flag fields as available to the notification emails; this would include fields from any tables available to the workflow type, including from an additional table joined to the workflow type through the enhanced Query Editor.

You can vote for this suggestion here.

Purchase Order Approval Workflow Automatically Rejected

Microsoft Dynamics GPA client reported a problem with their PO Approval Workflow process failing whenever a PO was submitted for approval. As soon as the Submit button was pressed, the document was rejected, but did not show a user:

Purchase Order Entry

Continue reading “Purchase Order Approval Workflow Automatically Rejected”