This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests series where I am going hands on with the top feature requests of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series.

The eighth, and final, new feature from the top user requests, is copy and paste from Excel in the web client. This has not worked since 2015 R2 with fixes promised always in the next version.

Again it has been included as a feature in the October 2019 release, but while it allows you to get the data from Ececl into the GL Transaction Entry window, but is instead an import. To import the journal lines in the web client, click the Paste button and then click Choose file:

You can browse to select a file to import as journal lines. The format is the same as when pasting in the desktop client.

It works, but it is not as nice and easy as the copy and paste possible in the desktop client and is not a copy and paste despite the announcement.

Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests
Copy Report Option
Filter Item Stock Inquiry by Date
Exclude Inactive Items on Item Price List Report
Minimize transaction when Go To is selected for PO that exists
Save setting for how to show new POs
Inactive field added to Item SmartList
Show the User ID in the Items SmartList
Paste from Excel in Web Client

This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests series where I am going hands on with the top feature requests of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series.

The seventh new feature from the top user requests, is the storage of the user ID who last modified an item record; this field has also been made available to SmartList:

Being able to see the last user to amend an item is a good addition and it is nice to see it made available within SmartList.

Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests
Copy Report Option
Filter Item Stock Inquiry by Date
Exclude Inactive Items on Item Price List Report
Minimize transaction when Go To is selected for PO that exists
Save setting for how to show new POs
Inactive field added to Item SmartList
Show the User ID in the Items SmartList
Paste from Excel in Web Client

This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests series where I am going hands on with the top feature requests of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series.

The sixth top requested enhancement is the availability of a column in the Items SmartList showing if an item is active or inactive:

I was a little surprised to see this announced as a feature as I had assume this field was already available, but it seems that when an Inactive flag was added in Dynamics GP 2013 RTM, that was as far as the change went. Extra visibility is always a good thing, so nice to see this added.

Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests
Copy Report Option
Filter Item Stock Inquiry by Date
Exclude Inactive Items on Item Price List Report
Minimize transaction when Go To is selected for PO that exists
Save setting for how to show new POs
Inactive field added to Item SmartList
Show the User ID in the Items SmartList
Paste from Excel in Web Client

This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests series where I am going hands on with the top feature requests of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series.

The fifth new feature based on the top requested features, is a new setting to control whether the displaying of the PO is skipped when a purchase requisition is purchased. Microsoft Dynamics GP 2018 RTM saw a new feature introduced whereby, when a PR was purchased, the purchase order transactions navigation list was automatically displayed. This turned out to be very disruptive for some clients due to the time it took to load the navigation list (especially when the Reporting Services Reports were deployed and the fact pane visible) that it was amended in Dynamics GP 2018 R2 to ask the user if they wanted to skip showing the navigation list.

The enhancement now is the addition of a drop down list in Purchase Order Setup (Purchasing » Setup » Purchase Order Processing) where the administrator can choose what happens:

The default option remains Show the message which is the 2018 R2 behaviour.

I like being able to set the option to not show the question let alone the navigation list. Most of the clients I work with always click the option to skip displaying the navigation list, so this option to allow them to set it to ,em>Don’t show the message and don’t open the new PO is going to be very welcome.

Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests
Copy Report Option
Filter Item Stock Inquiry by Date
Exclude Inactive Items on Item Price List Report
Minimize transaction when Go To is selected for PO that exists
Save setting for how to show new POs
Inactive field added to Item SmartList
Show the User ID in the Items SmartList
Paste from Excel in Web Client

This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests series where I am going hands on with the top feature requests of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series.

The fourth enhancement based on top requested features is the minimisation of the Payables Transaction Entry window when you choose Go To when you receive a warning that a PO exists for that vendor:

The purchasing transactions navigation list displays with the Payables Transaction Entry open with the transaction entered, but minimised so it can’t be seen. Once you’re done with the navigation list, you can restore the Payables Transaction Entry window to post or delete the transaction.

this is apparently one of the top requested features, but I don’t really see the point. A lot of the clients I work with have dual monitors so are more likely to want to move the window to a secondary monitor rather than have it minimised. Unfortunately, this new feature doesn’t have any options to control the behaviour so the transaction entry window is minimised if you opt to go to the navigation list.

Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests
Copy Report Option
Filter Item Stock Inquiry by Date
Exclude Inactive Items on Item Price List Report
Minimize transaction when Go To is selected for PO that exists
Save setting for how to show new POs
Inactive field added to Item SmartList
Show the User ID in the Items SmartList
Paste from Excel in Web Client

This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests series where I am going hands on with the top feature requests of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series.

The third enhancement based on the top feature requests is being able to specify if you want to exclude inactive items from the Item Price List report:

I’ve compared the window above to the one in Dynamics GP 2018 R2 and cannot see a difference, so either I am missing something or this “new” feature has been present for a while and just announced.

Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests
Copy Report Option
Filter Item Stock Inquiry by Date
Exclude Inactive Items on Item Price List Report
Minimize transaction when Go To is selected for PO that exists
Save setting for how to show new POs
Inactive field added to Item SmartList
Show the User ID in the Items SmartList
Paste from Excel in Web Client

This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests series where I am going hands on with the top feature requests of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series.

The second enhancement based on the top feature requests is the addition of date filters in the Item Stock Inquiry window to restrict the view; as is standard on enquiry windows click Redisplay to filter data based on the From and To dates:

Being able to filter the returned data by date will make it easier to review the stock movement by date.

Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests
Copy Report Option
Filter Item Stock Inquiry by Date
Exclude Inactive Items on Item Price List Report
Minimize transaction when Go To is selected for PO that exists
Save setting for how to show new POs
Inactive field added to Item SmartList
Show the User ID in the Items SmartList
Paste from Excel in Web Client

This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests series where I am going hands on with the top feature requests of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series.

The first enhancement from the top requested features is the ability to copy a report option. This allows you to replicate one report option under a different name, make some changes and then save the changes, allowing you to quickly set up standard options on a range of report options.

To copy a report option, enter the new Option name and click the Copy button on the action pane:

Continue reading “Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests: Copy Report Option”

This post is part of the Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests series where I am going hands on with the top feature requests of the new version of Microsoft Dynamics GP; it is part of the larger Hands On with Microsoft Dynamics GP October 2019 Release New Features series.

This post is the series index for the top feature requests made to Microsoft Dynamics GP October 2019 Release

Hands On with Microsoft Dynamics GP October 2019 Release New Features – Top Feature Requests
Copy Report Option
Filter Item Stock Inquiry by Date
Exclude Inactive Items on Item Price List Report
Minimize transaction when Go To is selected for PO that exists
Save setting for how to show new POs
Inactive field added to Item SmartList
Show the User ID in the Items SmartList
Paste from Excel in Web Client

The series index will, if you’re heading this on azurecurve|Ramblings of a Dynamics GP Consultant, automatically update as posts go-live.