Microsoft Dynamics GP Workflow 2.0 Second Edition Now Available on Amazon

● Ian Grieve ●  ● 3 Comments   ● 

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

● Categories: azurecurve Publishing, Dynamics, GP, Microsoft, Publishing, Workflow ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

Configuring Permissions to RDP to Server

● Ian Grieve ●  ● 1 Comment   ● 

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

● Categories: Microsoft, Windows, Windows Server 2012 ● Tags: , , , ,  ● Permalink ● Shortlink ●

Perfect Image ERP Practice Ready for #FabrikamDay

● Ian Grieve ●  ● 1 Comment   ● 

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

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

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

● Ian Grieve ●  ● 1 Comment   ● 

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

● Categories: Dynamics, GP, Microsoft, Web Services ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

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

● Ian Grieve ●  ● 3 Comments   ● 

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.

● Categories: Dynamics, GP, Microsoft, Microsoft Connect, Workflow ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

Purchase Order Approval Workflow Automatically Rejected

● Ian Grieve ●  ● 4 Comments   ● 

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

● Categories: Dynamics, GP, Microsoft, Workflow ● Tags: , , , , , , , , ,  ● Permalink ● Shortlink ●

Microsoft Dynamics GP Workflow 2.0 Second Edition Now Available in Paperback

● Ian Grieve ●  ● 6 Comments   ● 

Microsoft Dynamics GPMy sixth book is now available to buy in both eBook format from azurecurve Publishing and paperback. Currently the paperback is available only via CreateSpace, but should be on Amazon in the next week or so.

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.

Microsoft Dynamics GP Workflow 2.0 Second Edition

Continue reading → Microsoft Dynamics GP Workflow 2.0 Second Edition Now Available in Paperback

● Categories: azurecurve Publishing, Dynamics, GP, Microsoft, Publishing, Workflow ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

Workflow Error Sending Email: “Execution Of User Code In The dotNET Framework Is Disabled”

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPThis has come up twice fairly recently. In the first case it was following an upgrade to Microsoft Dynamics GP 2016 and workflow was being introduced for the first time, and in the second it was when a client had created a new test system:

Execution Of User Code In The dotNET Framework Is Disabled

Microsoft Dynamics GP

[Microsoft][SQL Server Native Client 11.0][SQL Server]Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.

Continue reading → Workflow Error Sending Email: “Execution Of User Code In The dotNET Framework Is Disabled”

● Categories: Dynamics, GP, Microsoft, SQL Server, Workflow ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

MS Connect Suggestion: Allow SQL Views to be Included in Workflow Conditions

● Ian Grieve ●  ● 4 Comments   ● 

Microsoft Dynamics GPContinuing my list of suggestions for improving Workflow, I have another one for you to vote for.

Through enabling a Dex.ini switch, an enhanced Workflow Condition Query Editor can be enabled, which allows Dexterity tables to be joined into the workflow. However, there have been a few times recently when being able to join in a SQL View would have been most beneficial. This functionality is available in SmartList Designer where Dex tables can be selected and at the bottom of the list is a node for SQL Views which displays all of the views in the database and allows them to be selected.

I’d like the same functionality made available to Workflow Maintenance to add flexibility to workflow design.

You can vote for this suggestion here.

● Categories: Dynamics, GP, Microsoft, Microsoft Connect, Workflow ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

Microsoft Dynamics GP Roadmap 2017-2019

● Ian Grieve ●  ● 1 Comment   ● 

Microsoft Dynamics GPA new roadmap for Microsoft Dynamics GP was released at GPUG Amplify last week which shows the next three releases:

Microsoft Dynamics GP Roadmap 2017-2019

The next version, due for release in 2017 H2 (most likely December) is Microsoft Dynamics GP 2018 and includes updates to Workflow (first time I’ve seen references to Workflow 3.0 and 4.0), Finance and HR Optimizations, Doc Attach, Power Suite (?) and top new features requested by customers.

I believe there is still time for you to get your suggestions onto Microsoft Connect.

If you see posts of the slide presented at GPUG Amplify you’ll notice that the 2016 and 2016 R2 columns were identical; the one posted above does not have this same issue.

● Categories: Dynamics, GP, Microsoft ● Tags: , , , , , ,  ● Permalink ● Shortlink ●