Tag: Microsoft Dynamics GP 2016 R2

With 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.

This Hands On post is going to take a look at the Purchase Requisition Enquiry Icon Feature of the Day post which follows on from the Cancel A PO Linked to a Requisition feature.

I covered this feature Hands On here.

To test the icon, I entered a purchase requisition with a quantity of 5:

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Purchase Requisition Inquiry Icon”

With 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 feature of the day I am covering in this post, is the Batch Edited Message. If a user tries to open a batch being edited by another user they will receive a warning message containing the users name:

Microsoft Dynamics GP

This batch is being edited by laurab. Please try later.

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Batch Edited Message”

With 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 third feature I’m going to take a look at is the Cancel Purchase Orders Linked To A Requisition. For those doubting why this feature was needed, in previous versions of Microsoft Dynamics GP, when yuo tried to cancel a quantity on a purchase order you would receive a message if the remaining quantity didn’t cover the requisition quantity:

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Cancel A Purchase Order Linked To A Purchase Requisition”

With 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 second of the new features I’m going to cover is SmartList Favorite Protection.

This feature allows the administrators to define a password which must be entered before a SmartList favorite can be modified. The password is entered in the SmartList Options window (Administration >> Setup >> System >> SmartList Options):

The password impacts all SmartList favorites. Please do not use ACCESS as the password; I see far too many clients who have this as a password throughout their system. It is in all of the manuals and lots of blog posts so it is pretty much the least secure password you could use.

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: SmartList Favourite Protection”

With 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.

This is the first of the posts where I will be covering the new functionality introduced to Microsoft Dynamics GP 2016 R2. In this post I am going to cover the addition of SmartList Designer favorites in Advanced Lookups new feature.

To use this feature, create a SmartList Designer object:

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: SmartList Designer Favorites In Advanced Lookups”

I 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.

With Microsoft Dynamics GP 2016 R2 now being available, there are some new security roles and tasks which need to be added.

As they have for the last few versions, Microsoft have made available some SQL Scripts to insert these roles and tasks.

The Dynamics GP 2016 R2 ones can be downloaded from directly from Microsoft or I have a post containing links to all of the versions I can find, which has been updated for Dynamics GP 2016, which is here.

The scripts tend to be cumulative, so if you upgrade from Microsoft Dynamics GP 2013 SP2 to 2016 R2, you only need to run the final script.

Not sure why I thought the scripts were cumulative, but they are not. All of the scripts need to be run in sequence for your upgrade path.

As always, when running scripts against Dynamics GP databases, ensure you have a good backup before starting.

The bulk of my Hands On with Microsoft Dynamics GP 2016 R2 posts are now completed and posted, so time for a brief intermission before I finish the series with a look at the new features.

These were introduced my Microsoft in November and I did a Feature of the Day series at the time, but I can now be hands on with them.

However, before I get to them, I have a few other posts to do.

With 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; the index for this series can be found here.

In the last post, I installed the Analysis Cubes server. The next step is to configure the Analysis Cubes.

There are a choice of three Analysis Cubes Configuration Wizards available, one for each of the supported versions of SQL Server. I have selected the SQL Server 2016 version as this is the version of SQL Server I have installed:

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Configure Analysis Cubes”