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”

Hands On With MDGP 2018 RTM New Features: One Payment Per Vendor/Invoice Setting on Vendor Card

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released and I have been taking a Hands On look at the installation and configuration of the new version.

I am now going to take a hands on look at the new and enhanced features introduced in Microsoft Dynamics GP. Rather than do this as a continuation of the Hands On series I wrote in December, as originally intended, I am going to split it out into a separate hands On With the features post. The series index is for this new features series, can be found here.

The twenty-third new feature of the day is One Payment Per Vendor/Invoice Setting on Vendor Card. In older versions of Dynamics GP, you could, on the Select Checks window (Purchasing area page >> Transactions >> Select Checks), select to produce one payment per vendor or invoice; in Dynamics GP 2018, the same options exists in the Build Payment Batch window (Purchasing area page >> Transactions >> Build Payment Batch), which is a renamed Select Checks window, along with the option to read the setting from the Vendor Maintenance window.

To set the option on the vendor, open Vendor Maintenance window (Purchasing area page >> Cards >> Vendor Maintenance), select a vendor and click the Options button.

The option is a pair of radio buttons half way down the page which is defaulted to Vendor; this default will apply to all existing vendors when you upgrade to Dynamics GP 2018:

Vendor Maintenance

Continue reading “Hands On With MDGP 2018 RTM New Features: One Payment Per Vendor/Invoice Setting on Vendor Card”

Hands On With MDGP 2018 RTM New Features: Print Purchase Requisition

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released and I have been taking a Hands On look at the installation and configuration of the new version.

I am now going to take a hands on look at the new and enhanced features introduced in Microsoft Dynamics GP. Rather than do this as a continuation of the Hands On series I wrote in December, as originally intended, I am going to split it out into a separate hands On With the features post. The series index is for this new features series, can be found here.

The twenty-second feature of the day is Print Purchase Requisition. I said in the Feature of the Day series, that my feelings were largely negative towards this feature and my opinion hasn’t changed now that I’ve been hands on with it.

A new Print button has been added to the Purchase Requisition Entry window (Purchasing area page >> Transactions >> Purchase Requisitions):

Purchase Requisition Entry

Continue reading “Hands On With MDGP 2018 RTM New Features: Print Purchase Requisition”

Hands On With MDGP 2018 RTM New Features: Make PO Number Visible to Requisition Originator

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released and I have been taking a Hands On look at the installation and configuration of the new version.

I am now going to take a hands on look at the new and enhanced features introduced in Microsoft Dynamics GP. Rather than do this as a continuation of the Hands On series I wrote in December, as originally intended, I am going to split it out into a separate hands On With the features post. The series index is for this new features series, can be found here.

The twenty-first feature of the day is Make PO Number Visible to Requisition Originator. This feature of the day makes the PO number for purchased requisitions visible to the originator by adding a PO Number column to the Procurement section of the home page:

Procurement

This feature is a nice addition; it gives the originator confirmation and an easy way of seeing the PO Number for the requisition.

Click to show/hide the Hands On With MDGP 2018 RTM New Features Series Index

Hands On With MDGP 2018 RTM New Features: On PO Generation Show Purchase Order Transactions Navigation List

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released and I have been taking a Hands On look at the installation and configuration of the new version.

I am now going to take a hands on look at the new and enhanced features introduced in Microsoft Dynamics GP. Rather than do this as a continuation of the Hands On series I wrote in December, as originally intended, I am going to split it out into a separate hands On With the features post. The series index is for this new features series, can be found here.

The twentieth feature of the day is On PO Generation Show Purchase Order Transactions Navigation List. When I heard of this feature, I initially thought it might be quite useful, but since I’ve been hands on, I’ve changed my mind.

The feature works by launching the Purchase Order Transactions navigation list when the purchase requisition is purchased and the purchase order created:

Purchase Order Transactions navigation list

My problem is that navigation lists can be quite slow to load, especially when Reporting Services Reports have been deployed. This feature would have been much better if it had been introduced with an option to enable/disable it (I’ve looked and can’t find one; if anyone knows different please let me know via the comments).

Click to show/hide the Hands On With MDGP 2018 RTM New Features Series Index

Hands On With MDGP 2018 RTM New Features: Print Single Customer Statement

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released and I have been taking a Hands On look at the installation and configuration of the new version.

I am now going to take a hands on look at the new and enhanced features introduced in Microsoft Dynamics GP. Rather than do this as a continuation of the Hands On series I wrote in December, as originally intended, I am going to split it out into a separate hands On With the features post. The series index is for this new features series, can be found here.

The nineteenth feature of the day, is Email Single Customer Statement from the Customer Maintenance window (Sales >> Cards >> Customer), or at least that is how it was originally billed by Microsoft.

However, now that I’ve had the chance to get hands on with it, it is not the ability to email a statement, but only the ability to print one using the old Standard report. This is very disappointing as this new functionality doesn’t even allow the printing to the Word Template version of the template.

To print the single statement, open the Customer Maintenance window, load a customer, click the Print button to display a small menu, click Statement:

Customer Maintenance

Continue reading “Hands On With MDGP 2018 RTM New Features: Print Single Customer Statement”

Hands On With MDGP 2018 RTM New Features: SmartList Favorite Password Protection

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released and I have been taking a Hands On look at the installation and configuration of the new version.

I am now going to take a hands on look at the new and enhanced features introduced in Microsoft Dynamics GP. Rather than do this as a continuation of the Hands On series I wrote in December, as originally intended, I am going to split it out into a separate hands On With the features post. The series index is for this new features series, can be found here.

The eighteenth feature of the day is SmartList Favourite Password Protection.

In Microsoft Dynamics GP 2016 R2, SmartList Favourite Protection was introduced; however, this protection was via a global password for all SmartList Favourites.

In this 2018 new feature, Microsoft have added the ability to set a separate password for each favourite.

To do this, click the Favorites button. Enter a Name for the SmartList and enter the required password in the Password field.

Click Add:

Add or Remove Favorites

Continue reading “Hands On With MDGP 2018 RTM New Features: SmartList Favorite Password Protection”

Hands On With MDGP 2018 RTM New Features: Copy User Access Across AA Dimensions

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released and I have been taking a Hands On look at the installation and configuration of the new version.

I am now going to take a hands on look at the new and enhanced features introduced in Microsoft Dynamics GP. Rather than do this as a continuation of the Hands On series I wrote in December, as originally intended, I am going to split it out into a separate hands On With the features post. The series index is for this new features series, can be found here.

The seventeenth feature of the day is Copy User Access Across AA Dimensions.

Analytical Accounting is one of those modules which I, and a lot of other consultants, will try to guide clients away from. It is overly complex and time consuming to setup, use and, most certainly, to report from.

This new feature should, somewhat, simplify the configuration of access to alphanumeric dimensions by allowing the granted access to be copied between users.

To do this, open the User Access to Trx Dimension Codes window (Administration area page >> Setup >> Company >> Analytical Accounting >> User Access) and click the Copy button:

User Access to Trx Dimension Codes

Continue reading “Hands On With MDGP 2018 RTM New Features: Copy User Access Across AA Dimensions”

Hands On With MDGP 2018 RTM New Features: Display Sales Hold Status

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released and I have been taking a Hands On look at the installation and configuration of the new version.

I am now going to take a hands on look at the new and enhanced features introduced in Microsoft Dynamics GP. Rather than do this as a continuation of the Hands On series I wrote in December, as originally intended, I am going to split it out into a separate hands On With the features post. The series index is for this new features series, can be found here.

The sixteenth feature of the day, is Display Sales Hold Status, which saw the introduction of a hold flag to the Sales Transaction Entry window (Sales area page >> Transactions >> Sales Transaction Entry):

Sales Transaction Entry

Continue reading “Hands On With MDGP 2018 RTM New Features: Display Sales Hold Status”

Hands On With MDGP 2018 RTM New Features: System Password Remembered

Microsoft Dynamics GPMicrosoft Dynamics GP 2018 RTM has now been released and I have been taking a Hands On look at the installation and configuration of the new version.

I am now going to take a hands on look at the new and enhanced features introduced in Microsoft Dynamics GP. Rather than do this as a continuation of the Hands On series I wrote in December, as originally intended, I am going to split it out into a separate hands On With the features post. The series index is for this new features series, can be found here.

The fifteenth feature of the day, is Remember System Password.

The new feature means that the system password now only needs to be entered once per session:

Enter the system password.

If you have ever needed to build a new security model for Dynamics GP, you will have become heartily sick of having to enter the system password multiple times. In fact, every single time a protected window was opened, the password needed to be entered.

This feature is a most welcome one, but has one drawback. Once entered, the system password is remembered for the rest of the session. This means if you enter it for a user, such as, for example, to give them access to the VAT Return window, they can then access any other window which is usually protected with the system password.

This shouldn’t generally be a problem as the security roles would have locked down the security windows so normal users wouldn’t see them, but it is something to be aware of and consider.

Click to show/hide the Hands On With MDGP 2018 RTM New Features Series Index