Hands On With MDGP 2018 RTM New Features: Web Client Changes

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 fourteenth feature of the day is Web Client Changes; this feature groups together three features.

The first of the features, is the extension of the AutoComplete from the desktop client into the web client. This means that when an ID has been entered once, it will be remembered and listed when the user starts to type the ID again (within the limits of the AutoComplete User Preferences:

Web Client AutoComplete

Continue reading “Hands On With MDGP 2018 RTM New Features: Web Client Changes”

Hands On With MDGP 2018 RTM New Features: Sorting

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 twelfth feature of the day is Sorting. Five windows inquiry windows have had the ability to change the sort order added:

  • Payables Transaction Inquiry – Vendor
  • Payables Transaction Inquiry – Document
  • Receivables Transaction Inquiry – Customer
  • Receivables Transaction Inquiry – Document
  • Select Bank Transactions
Payables Transaction Inquiry - Vendor

Across the years I have been asked numerous times by clients if it was possible to reorder the inquiry windows into date order, but this was never possible. Until Microsoft Dynamics GP 2018 that is.

This feature of the day has seen five of the inquiry windows updated to have sort options available. For Payables Transaction Inquiry – Vendor this means you can change the sort order from Document Number to one of the following:

  • Type
  • Original Amount
  • Unapplied AMount
  • Document Date

The other windows have similar sorting options. We have already started rolling out Dynamics GP 2018 to clients and have had a few positive comments about this feature.

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

MDGP 2018 RTM Feature of the Day: Web Client Changes

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 RTM; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily as well as adding my own commentary.

The series index for this series of posts is here.

The twelfth Feature of the Day is Web Client Changes.

This feature combines three enhancements which have been made to the web client.

Firstly, the web client has been modified to have the same autocomplete functionality as the desktop client:

Customer Maintenance

Continue reading “MDGP 2018 RTM Feature of the Day: Web Client Changes”

MDGP 2018 RTM Feature of the Day: Sorting

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 RTM; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily as well as adding my own commentary.

The series index for this series of posts is here.

The tenth Feature of the Day is Sorting. This feature adds sorting options to five windows in Purchasing, Sales and Bank Reconciliation:

I like this feature a lot. Clients have been asking about being able to reorder the enquiry windows for a long time; it’s nice that I’ll soon be able to tell them that they can now sort the data.

Click to show/hide the MDGP 2018 RTM Feature of the Day Series Index

Dynamics GP Tech Conference 2017: New User Experience Features

Microsoft Dynamics GPThis post is part of the series I am doing on the Dynamics GP Tech Conference 2017.

One of the areas being focused on in the 2018 version of Microsoft Dynamics GP, is the user experience. The announced enhancements are:

  • Add sort to Receivables Transaction Inquiry – by Customer
  • Add sort to Receivables Transaction Inquiry – by Document
  • Add sort to Payables Transaction Inquiry – by Vendor
  • Add sort to Payables Transaction Inquiry – by Document
  • System password is remembered for the duration of the user session – the only downside is if you need to grant access to a window such as the VAT Return to a user, but then need to monitor them to make sure they then close Dynamics GP before continuing with other work.
  • Rename of Payables windows to say Payments instead of Checks – I can;t find the post, but this was a request from Mariano Gomez and is well overdue. Pretty much all payments in the UK are by EFT, so it was getting seriously embarrassing having all the windows with Cheque in the name (UK language pack changes it from Check).
  • Autocomplete added to the web client
  • SmartList Favourites – unique password protection – this is by popular request after the password for SmartList Favourites globally was added in GP 2016 R2.
  • SmartList shortcut on toolbar in web client
  • Bank Reconciliation maximise window in web client
  • Adding additional sorting in Bank Reconciliation window
  • Update help icons to link to tagged online support documents

The enhancements to the user experience listed above should be of benefit to users of Dynamics GP, and follows Microsoft’s ethos of evolution, not revolution in the improvements they are making.

Click to show/hide the Dynamics GP Tech Conference 2017 Series Index

Hands On With Microsoft Dynamics GP 2016 R2: Bank Reconciliation Tracks History

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components and also look at the new functionality introduced; the index for this series can be found here.

The tenth Feature of the Day I’m going “hands on” with is the Bank Reconciliation Tracks History one which introduced a new window on the Financial Routines menu:

Reconciled Transaction Maintenance

To use this feature, decide if all, a range or one Checkbook should have its reconciliation history moved to history.

Mark the checkbox next to the type of transactions which should be moved and enter a Cut Off date; although the date field is aligned with the Reconciled Deposit Transactions, it apples to all of the transaction types.

Click Process to perform the move of reconciled transactions to history.

Click to show/hide the Hands On With Microsoft Dynamics GP 2016 R2 Series Index

Microsoft Dynamics GP January Hotfix Released

Microsoft Dynamics GPI don’t usually post about releases, except for major version releases. However, the January Hotfix release caught my eye with a few of the included features in the 2016 R2 one.

As well as having the US Payroll updates there are updates to the following which would be of benefit to clients in the UK:

  • VAT Daybook

    • VAT Daybook Summary reports may not show correct data in boxes 1, 6 and 7 if you voided a transaction.
    • VAT detail report may show incorrect figures if you have 2 or more tax codes on a transaction.
  • General Ledger

    • The Excel copy and paste function may not calculate the credit/debit column correctly when using an allocation account.
  • Fixed Asset Management

    • Tax values may not update properly if a user marks to create multiple fixed assets in the Fixed Asset Purchase Order additional information window.
  • Bank Reconciliation

    • You may experience performance issues with the Checkbook Register Inquiry window after you install GP 2016 R2.
  • Project Accounting

    • Ability to change line distributions for time and material projects in revenue recognition.
    • Fee Accounts not available in line distributions button.
    • Purchase Receiving’s not reflecting WIP account edits from Purchase Order for non-inventory items.
  • System Manager

    • Fixed issues with Uncollated printing.

The hotfixes for Dynamics GP 2013 R2 and 2015 R2 only contain US Payroll fixes.

The post from the Dynamics GP Support and Services blog contains the download links.

MDGP 2016 R2 Feature of the Day: Bank Rec Tracks History

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2016 R2; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily.

The series index for this series of posts is here.

The tenth Feature of the Day is Bank Rec Tracks History.

Thre is a new process for Reconciled Transaction on the Routines menu in Financials which moves reconciled transactions to history.

Reconciled Transaction Maintenance

With data moved to history, the performance of the Bank Reconciliation processes will improve and anything which improves performance is to be welcomed.

Click to show/hide the MDGP 2016 R2 Feature of the Day Series Index

MDGP 2016 R1 Feature of the Day: Automatically Batch Deposit Cash Receipts

Microsoft Dynamics GPThere are some feature of the days which I look at and think “so what?”. And then there are others I look at and know they are going to be very popular.

This feature is very much one of the latter (I have one client who would be willing to upgrade to just top get this one feature). It is the ability to have Cash Receipts automatically posted in Bank Reconciliation:.

Cash Receipt Posting Journal

Bank Deposit Posting Journal

The main features of are:

  • When Automatically Post Cash Deposits is marked and you post a batch with cash receipts in it, one deposit will be created for all cash receipts in the batch.
  • If you transaction level post, each transaction will create a separate deposit.

There is one downside to this feature; if you want your deposits to show as individual deposits in bank you have to post them separately in Receivables Management. Doing one transaction per batch (transaction level posting would result in manual posting being required of the resulting GL batches) will not be as time consuming as doing all of the deposits manually, but is moving an element of the work from one part of Dynamics GP to another (and possibly from one team to another).

The client I references at the start of this post runs a number of visitor centres so will have a lot of cash receipt transactions being imported into the system, but the majority of them would hit the bank as a single deposit. I’m onsite with them soon to help integrate their new EPOS system into GP so can work with them to make sure transactions are brought into Dynamics GP in the way necessary for them to benefit most from this feature.

Click to show/hide the MDGP 2016 R1 Feature of the Day Series Index

MDGP 2015 R2 Feature of the Day: Automatically Deposit Cash Receipts

Microsoft Dynamics GPMicrosoft Dynamics GP 2015 R2 has been released and, as with previous releases, Microsoft have started a Feature of the Day series on the Inside Microsoft Dynamics GP Team blog. As I have done with the last three series, I’ll be reposting these blog posts here with a little commentary.

The twenty third Feature of the Day is Automatically Deposit Cash Receipts. This feature provides the option to have cash receipts directly update the checkbook balance without the need to manually post the cash receipt deposit in Bank Reconciliation.

This option was previously available in Analytical Accounting. In Microsoft Dynamic GP2015 R2, the option is made available in the core dictionary, expanding the option to companies not using Analytical Accounting.

To select the option, mark the “Automatically post cash receipt deposits” checkbox in the Company Setup Options window.

Company Setup - Options

When this option is marked, cash receipts entered in Cash Receipt Entry, Receivables Transaction Entry, Sales Transaction Entry, and Invoice Entry will be deposited automatically in the checkbook, updating the checkbook balance.

I have a few clients who will benefit from this one, but I have one client especially in mind for it who has asked before about if this was possible.

Click to show/hide the MDGP 2015 R2 Feature of the Day Series Index