Bug With Microsoft Dynamics GP 2018 RTM Workflow Step Copy Function

Microsoft Dynamics GPOne of the new features introduced with Microsoft Dynamics GP was the Copy Workflow Step feature; I have a number of clients using workflow and having to manually configure every step could be very time consuming, when being able to copy and amend the conditions would save huge amounts of time.

When the new feature came out I did go hand on with it, but only so far as to copy a step. What I didn’t actually do was amend the conditions; if I had I would have found that there was a bug in this new functionality. Unfortunately, it took one of my clients to come across the bug when they were adding some steps to a workflow.

The problem is this; when you copy a step, it also copies the conditions. When the step is copied, it adds a new line to the Workflow Step Table (WF100003); but, there is no new entry added to the QueryDesigner_Conditions (CO00123) table.

This has the unfortunate side effect that when you amend the condition on the new step, you are also changing it on the original step.

below is a simple example of the problem.

First, set up a step:

Workflow Original Step

Continue reading “Bug With Microsoft Dynamics GP 2018 RTM Workflow Step Copy Function”

Implementing Jet Express: Prerequisites

Jet ReportsThis post is part of a series of posts on implementing Jet Reports and is part of the Jet Express sub-series.

Jet Express for Microsoft Excel is the lowest featured product in the Jet Reports product range and is really only of value to clients with very simple financial reporting from the General Ledger; Jet Express can be downloaded from here:

Jet Express has fairly generous system requirements:

  1. Microsoft Office – Microsoft Office 2007, 2010, 2013, 2016, Microsoft Office 365 Desktop Edition
  2. Operating System – Microsoft Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista, Windows Server 2008 through 2012R2
  3. Prerequisites: – Microsoft .NET Framework 4.5 (if not present, will be installed with Jet Express).

Jet Express will also work with all versions of Dynamics GP starting with version 9.0.