Hands On With Microsoft Dynamics GP 2016 R1: Deploy Sample Company

Microsoft Dynamics GPWith the system database deployed it is now time to deploy the sample company. This is done by launching GP Utilities.

Enter the user and password and click OK to log in:

Welcome to Microsoft Dynamics GP Utilities

Continue reading “Hands On With Microsoft Dynamics GP 2016 R1: Deploy Sample Company”

wfDeployClrAssemblies Error When Deploying The System Database

Microsoft Dynamics GPThis post is a slight diversion from my Hands On With Microsoft Dynamics GP 2016 R1 series, but I am posting it as it came up while I was deploying the system database.

Towards the end of the deployment an error occurred while the wfDeployClrAssemblies was being executed (actually there were three error messages produced):

Microsoft Dynamics GP Utilities: The following SQL Statement produced an error: EXEC wfDeployClrAssemblies

Microsoft Dynamics GP Utilities

The following SQL Statement produced an error:
EXEC wfDeployClrAssemblies

Continue reading “wfDeployClrAssemblies Error When Deploying The System Database”

Management Reporter 2012 CU15 Is Now Available

Microsoft Dynamics GPThe Dynamics Financial Reporting for Microsoft Dynamics GP has announced the availability of CU15 for Management Reporter 2012. This cumulative up-date contains a few bug fixes as well as some enhancements.

Here’s a summary of the new Management Reporter CU15 features:

  • Improved responsiveness in the Web Viewer.
  • A search bar has been added to search through the current level of the report as in-browser search functions may not always return all results because of the performance changes to improve responsiveness.
  • Printing in the Web Viewer through XPS download.
  • PowerShell module to enable reset of data mart.
  • Added a Turkish (tr-tr) localization.
  • Additional fixes for product defects.

The Dynamics Financial Reporting for Microsoft Dynamics GP team will be blogging about the new features in detail soon.

There are a few new prerequisites which are required for this cumulative update:

  • SQL Server 2012 or higher.
  • Microsoft .NET Framework 4.6.1 is also required (when installed this may require a reboot).

Management Reporter CU15 Release is version 2.12.15000.56; make sure your ERP version is supported by checking the compatibility list.

The EN-US download for Management Reporter CU15 is here and localised versions will be coming soon.

Hands On With Microsoft Dynamics GP 2016 R1: Deploy System Database

Microsoft Dynamics GPNow that we have the first client installed, we can deploy the system database. By default the system database is called DYNAMCIS, but i have chosen to use one called D16R1. To deploy the system database, hit the Windows start button, search for and launch GP Utilities.

While I do try to minimise the use of the sa account as it is the SQL Server system administrator account, the initial implementation of Dynamics GP does require its use. So, on the Welcome to Microsoft Dynamics GP Utilities window enter sa in the User ID field and enter the relevant password.

Once done, click OK:

Welcome to Microsoft Dynamics GP Utilities

Continue reading “Hands On With Microsoft Dynamics GP 2016 R1: Deploy System Database”

Hands On With Microsoft Dynamics GP 2016 R1: Client Installation

Microsoft Dynamics GPOnce you have downloaded the installation media, the first step is to install a client. Typically, I will install a client on the SQL Server itself as this can avoid a number of problems, but this time round I did not and instead installed it on the server which will be my terminal server.

Before starting the install from the media, ensure .NET 3.5 has been installed; this can be done via Programs and Features in the Control Panel. If you have an Internet connection, the relevant files will be downloaded or you will need to specify the location of the files (Windows Server or Windows Client.

To install the desktop client, unzip the media and double click on the setup.exe. This will launch the bootstrapper which will install the remaining prerequisites:

Microsoft Dynamics GP 2016 Bootstrapper Setup

Continue reading “Hands On With Microsoft Dynamics GP 2016 R1: Client Installation”

Hands On With Microsoft Dynamics GP 2016 R1: Downloading The Media

Microsoft Dynamics GPThe first step to installing Microsoft Dynamics GP 2016 R1 is to download the media. Sounds simple doesn’t it?

Yeah, not so much. Microsoft promised the software would be generally available on 1st May, but I checked late last night UK time and nothing was there.

I checked again this morning and still nothing.

Until I checked David Musgrave’s blog and found he had been supplied a direct link by someone at Microsoft.

While Dynamics GP 2016 R1 was downloading, I did a little investigating and I think the reason it doesn’t show up for me is that PartnerSource presents itself as UK for me, whereas the link supplied to David was a northamerican one.

Thinking back I had similar problems when Dynamics GP 2015 came out and I couldn’t find the link on PartnerSource or CustomerSource. That time around I amended the 2013 in the link to 2015 and it worked; this time changing it to 2016 did not work.

Hopefully, Microsoft will get this sorted out to so the downloads for Dynamics GP 2016 are available via the UK sites.

Microsoft Dynamics GP 2016 RTM can be downloaded here.

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

Hands On With Microsoft Dynamics GP 2016 R1: Series Index

Microsoft Dynamics GPMicrosoft Dynamics GP 2016 R1 was released in early May 2016; this post contains the series index for the Hands on series of posts as I install 2016 R1 into my test environment.

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

I plan to follow the installation posts with ones looking at some of the new features, so keep checking back for new posts.

MDGP 2016 R1 Feature of the Day: OData Service

The previous feature of the day introduced the OData Service installation. This one gives a brief overview of how the service works:

OData Service

The main features of the OData service are:

  • Ability to define end points for the service
  • View GP data with any tool that supports OData feeds

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

MDGP 2016 R1 Feature of the Day: OData Service Deployment

Microsoft Dynamics GP 2016 R1 is seeing the introduction of a new complimentary product: an OData service which will allow reports on Dynamics GP data using any reporting tool (such as PoweBI) to be created:

OData Service Deployment

The main features of are:

  • Separate install under Additional Products
  • Use GP Security to control access to data
  • Supports tables, views and stored procs as data sources

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

MDGP 2016 R1 Feature of the Day: PowerBI Reports on the Home Page

In February 2014 Microsoft launched PowerBI for Office 265 and are now bringing it to the Microsoft Dynamics GP 2016 R1 home page (but only the home page of the desktop client):

PowerBI on the Microsoft Dynamics GP 2016 R1 home page

The main features of are:

  • New part on Home Page to display Power BI Reports.
  • Click on the report to take you out to your Power BI site.

I’m not entirely sure how to feel about the addition of PowerBI to Dynamics GP; it almost feels like a scatter gun approach is being used for reporting with Dynamics GP. There are standard reports, Metrics, Excel Reports, SSRS Reports (which for most clients replace the Metrics to the extent I had to lookup the name of Metrics), Management Reporter (with an unknown roadmap/future) reports and now PowerBI reports.

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