Script to Remove Microsoft Dynamics Workflow History Where No Action Is Required

I have quite a few clients using the Microsoft Dynamics GP Workflow module as standard out of the box with no customisations required, but a fair number of clients do have one customisation or another. A few of them have a customisation allowing a SQL view to be used in… Read more“Script to Remove Microsoft Dynamics Workflow History Where No Action Is Required”

Find Microsoft Dynamics GP Databases With Workflow Email Actions Enabled

I was doing an upgrade for a client the other day and ran some scripts to remove the web services SQL objects as part of the upgrade (I always find that an upgrade of the Web Services for Microsoft Dynamics GP doesn’t work very well, so it’s a quicker and… Read more“Find Microsoft Dynamics GP Databases With Workflow Email Actions Enabled”

Microsoft Dynamics GP October 2021 Release Feature of the Day: Remove Carbon Copy Email in Workflow Maintenance

This post is part of the series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Remove Carbon… Read more“Microsoft Dynamics GP October 2021 Release Feature of the Day: Remove Carbon Copy Email in Workflow Maintenance”

Microsoft Dynamics GP October 2021 Release Feature of the Day: Workflow Approvers Count

This post is part of the series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Workflow Approvers… Read more“Microsoft Dynamics GP October 2021 Release Feature of the Day: Workflow Approvers Count”

Microsoft Dynamics GP October 2021 Release Feature of the Day: Add Autopost for Workflow Batches

This post is part of the series where I am going to echo the posts from the Inside Microsoft Dynamics GP Blog, while adding some commentary, on the new features introduced in the Microsoft Dynamics GP October 2021 Release which is now available. This post is on the Add Autopost… Read more“Microsoft Dynamics GP October 2021 Release Feature of the Day: Add Autopost for Workflow Batches”

Microsoft Dynamics GP Workflow Navigation Lists Not Working Correctly After Upgrading

I’ve been involved with a number of upgrade projects recently where we were both upgrading the client to the latest version of Microsoft Dynamics GP, but also introducing some new functionality such as workflow for approvals. Quite a few of these clients are long time users of Dynamics GP who… Read more“Microsoft Dynamics GP Workflow Navigation Lists Not Working Correctly After Upgrading”

SQL Function to Return Last Workflow Final Approval Date

The below SQL function returns the last Microsoft Dynamics GP workflow final approval date and time; it is always returned, not just when final approved is the current status. This function was created to be used in a check of approved documents to see when they had last been approved;… Read more“SQL Function to Return Last Workflow Final Approval Date”

Error opening Word templates from Microsoft Dynamics GP Workflow Action emails

A client reported a problem with workflow approvers opening the batch edit list on a Microsoft Dynamics GP General Ledger Batch Approval workflow action email this morning; only a few users are having problems while everyone else is working without problem. The users with the problem are getting this error… Read more“Error opening Word templates from Microsoft Dynamics GP Workflow Action emails”

Show Workflow Approval Status of posted Microsoft Dynamics GP General Ledger batches

I recently deal with a support call for a client where they were having problems creating a report which showed the approval status of GL batches. Building the WfBusObjKey was more complicated than I expected as it requires the date and time from the batch; for an unposted journal this… Read more“Show Workflow Approval Status of posted Microsoft Dynamics GP General Ledger batches”

Microsoft Dynamics GP Workflow Payables Batch Approval email not including Word template

A client has recently been working on a project to implement approval workflows in a few modules of Microsoft Dynamics GP, but had an issue with the Payables Transaction Approvals notification emails not always including the Word template which all of the steps are marked to include. There appeared to… Read more“Microsoft Dynamics GP Workflow Payables Batch Approval email not including Word template”