Hands On With Microsoft Dynamics GP 2018 R2 New Features: Duplicate Check Numbers Option Extended

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The fourteenth new feature is Duplicate Check Numbers Option Extended.

This feature sees the Checkbook Maintenance (Financial area page » Cards » Chechbook) option to allow or not allow Duplicate Check Numbers extended to other windows. This means that if this option is not marked, duplicate checks are not allowed in these three windows. Previously, this option only applied to Payables checkbooks but now it includes:

  • Bank Transaction Entry
  • Payroll Manual Checks
  • Miscellaneous Checks
Checkbook  Maintenance

Continue reading “Hands On With Microsoft Dynamics GP 2018 R2 New Features: Duplicate Check Numbers Option Extended”

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Email Customer Statements

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The thirteenth new feature is Email Customer Statements. This feature of the day allows a single statement to be emailed to a customer direct from the Customer Maintenance window (Sales area page » Cards » Customer) using the Email button on the action pane:

Customer Maintenance

Continue reading “Hands On With Microsoft Dynamics GP 2018 R2 New Features: Email Customer Statements”

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Increase Dynamics GP Password Maximum Length

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The eleventh new feature is Increase Dynamics GP Password Maximum Length. This feature sees the maximum length of user passwords increased from 15 to 21 characters:

User Setup

Any increase in the maximum length of passwords is to be welcomed, but, seeing as this change required a database schema change to increase the SQL field length from 15 to 21, I am a little surprised that the new length is only 21 characters.

Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Exclude Items on HITB Report With Zero Quantity or Value

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The tenth new feature is Exclude Items on HITB Report With Zero Quantity or Value. This feature adds two new options to the Historical Inventory Trial Balance (HITB) report. The new options are:

  • Include Items with Zero Quantity
  • Include Items with Zero Value

These items will be excluded on the report if the options are not checked; previously, by default, these items were included. Make sure the checkboxes are unmarked to exclude the items with either zero value or quantity:

Inventory Activity Report Options

When I first read this feature of the day announcement, I thought it would be a good addition. However, now that I’ve been hands on with it, I’m not so sure. Initially, I’d misremembered what the HITB showed; it is basically a report which shows movement of stock. The report I was thinking of, is the Stock Status report and it already allows you to filter out zero quantities or values.

Having played around on Fabrikam, I can’t actually see how excluding items would be useful from the HITB report; when running a Trial Balance, you’d want to see all transactions.

Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index

Hands On With Microsoft Dynamics GP 2018 R2 New Features: New SmartList for Deposits on Unposted Sales Transactions Has Been Created

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The ninth new feature is New SmartList for Deposits on Unposted Sales Transactions Has Been Created. This feature adds a new Deposits on Unposted Sales Transactions favourite to the Sales Transactions SmartList object:

Deposits on Unposted Sales Transactions SmartList Favorite

When the feature of the day post was announced, I expressed some skepticism as to the value of it. It is basically a copy of the default favourite with two columns removed and the Deposit Received column added; very quick and easy to create if it is needed.

I’ve not really changed my mind. It might save you 20 seconds once to create the favourite if you wanted it, but nothing more.

I’d have been happier if it was a new SmartList Object, such as a Budget SmartList, instead of just a new favourite.

Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Vendor Document Number Added to Purchasing All-in-One View

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The eighth new feature is Vendor Document Number added to Purchasing All-in-One View. This feature adds the Document Number to the Payments and Credits column of the Purchasing All-in-One View (Purchasing area page » Enquiry/Inquiry » Purchasing All-in-One View):

Purchasing All-in-One View

This feature is a good feature which will provide additional information to users that they have found the correct information.

Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Transaction Level Post Through General Ledger

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The seventh new feature is .When transaction posting is enabled, this feature allows users to perform posting through the General Ledger at a transaction level. The following is a list of supported transactions for this feature:

  • Invoice Entry
  • Receivables Apply Doc.
  • Receivables Cash Receipts
  • Receivables Sales Entry
  • Sales Deposits
  • Sales Trx Entry
  • Voided Trx Maintenance (Sales)
  • Payables Trx Entry
  • Payment Entry
  • Purchasing Invoice Entry
  • Purchasing Prepayments
  • Receivings Trx Entry
  • Returns Trx Entry
  • Assembly Entry
  • Transaction Entry (Inventory)
  • Transfer Entry
  • Manual Checks (Payroll)
  • Project Accounting Transaction windows except Project Closing

To enable post through for transactions, open the Posting Setup window (Administration area page » Setup » Posting » Posting), and mark the Post Through General Ledger checkbox below the Allow Transaction Posting one:

Posting Setup

In theory this is a great addition to Dynamics GP, as many clients want to do transaction level posting, although more these days are wanting to use workflow for approvals which still requires batches.

However, in my testing so far, all Sales transactions which I post using post through work fine, but nothing on Payables posts through at transaction level regardless of the settings.

I need to do additional testing, but so far this feature isn’t looking good.

Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Print Invoices in Functional Currency from SOP Navigation List

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The sixth new feature is Print Invoices in Functional Currency from SOP Navigation List. This feature of the day is one I requested back in 2014 on behalf of a client; it is the ability to print an invoice in Functional, by changing the Currency to Print drop-down, from the navigation:

Sales Transactions navigation list

Continue reading “Hands On With Microsoft Dynamics GP 2018 R2 New Features: Print Invoices in Functional Currency from SOP Navigation List”

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Print and E-mail Sales Order Processing Documents

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The fifth new feature is Print and E-mail Sales Order Processing Documents. This feature changes the printing behaviour of the Sales Document Print Options window, accessible via Sales Transaction Entry (Sales area page » Transactions » Sales Transaction Entry) to both print and email the sales document:

Sales Document Print Options

When it was announced, I wondered if, in some way, this was related to the print remaining documents functionality, but I tested with 2018 RTM and that was how that version worked. This new feature goes against the 2013 R2 feature in that selecting both boxes will then both print and email the sales document.

I’m not sure what the use case for this feature is. If you have an email address, you’d want to email the document, otherwise you would want to print it. This is exactly what the previous versions would do.

Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Option to Hide Business Analyzer for All Users

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The fourth new feature is Option to Hide Business Analyzer for all Users. This feature allows the Business Analyzer section of the home page and/or the Business Analyzer fact panes on navigation lists to be switched off for all users.

Two new options have been introduced to the System Preferences window (Administration area page » Setup » System » System Preferences).

Unmark the first, Display Business Analyzer on Home page, to remove it for all users; unmark the second, Display Business Analyzer on Navigation List pages to remove the fact pane for all users:

System Preferences

A few years ago I wrote a SQL trigger which would remove the fact pane for all users; this appeared in two editions of the Microsoft Dynamics GP Cookbook and was, much more recently, posted to this blog.

This new feature makes that trigger obsolete, as changing the settings in System Preferences will remove it for all users.

If they desire, users can still switch Business Analyzer back on for themselves on the home page and by individual navigation list. That sid, I don;t know of a single client who wants to use Business Analyzer in either of these ways.

Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index