With 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:
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:
The 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.
- SQL Server 2012 or higher.
- Microsoft .NET Framework 4.6.1 is also required (when installed this may require a reboot).
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:
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.
Now 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:
Once 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:
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.
|Hands On With Microsoft Dynamics GP 2016 R1|
|Downloading The Media|
|Deploy System Database|
|Deploy Sample Company|
I plan to follow the installation posts with ones looking at some of the new features, so keep checking back for new posts.
The previous feature of the day introduced the OData Service installation. This one gives a brief overview of how the service works:
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
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:
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
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):
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.