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.

Winthrop DC Directly Distributing All Products from 1st July 2018

Winthrop DCYesterday, Winthrop Development Consultants announced that they would be moving to direct distribution for all of their Microsoft Dynamics GP add-ons (including the GP Power Tools) as of the 1st July 2018.

This means all new subscriptions, subscription renewals, and sales and support queries will be handled directly via Winthrop Development Consultants.

One important point to note, is that all installations will need to be upgraded before the subscriptions expire to be able to renew under Winthrop’s new registration system.

Full information is available from Winthrop Development Consultants including details on the new customer and partner portals.

Until 1st July 2018, Mekorma will continue to distribute GP Power Tools so any new subscription purchase or renewal should be processed via their site.

Implementing Jet Express: Series Index

Jet ReportsThis post is part of a series of posts on Jet Reports. As I said in the series index for the overall series on Implementing jet Reports, I am doing subseries for each of the versions of Jet Reports.

This is the series index for implementing Jet Express which is the lowest tier of the software and suitable for smaller business with simple reporting requirements.

Continue reading “Implementing Jet Express: Series Index”

Implementing Jet Reports: Differences Between Versions of Jet Reports

Jet ReportsThere are three versions of Jet Reports available for Microsoft Dynamics GP. Jet Reports was founded in 2002 and is headquartered in Portland, Oregon, USA and has a presence around the world, including here in the United Kingdom.

The three versions of Jet Reports are:

  1. Jet Express for Excel – an extension included with Microsoft Dynamics GP gives users a simple way to create basic reports and business queries inside Excel.
  2. Jet Professional – fast, flexible financial and business reporting inside Microsoft Excel.
  3. Jet Enterprise – corporate analytics and reporting, anywhere.

There is a product comparison sheet available from Jet Reports which shows the differing capabilities of the three versions.

As mentioned in the series index, I am going to run through the implementation of all three versions, but my recommendation would be to look to the Professional and Enterprise versions for your reporting needs rather than the Express edition; unless your requirements are very simple (no requirements for dashboards, scheduling, security, multi-company) then Jet Express will not be sufficient.