Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 by Mark Polino – A (short) Review

Microsoft Dynamics GPA few weeks ago Mark Polino, in conjunction with Packt Publishing published another book, the Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013;

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013

I got a copy of Mark Polino’s Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 the other week with the intention of working through it following all of the examples. However, the reality is I don’t have the time to do this due to other commitments (both work and outside of work ones).

Continue reading “Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 by Mark Polino – A (short) Review”

Microsoft Dynamics GP 2013 Web Client Unexpected Error

Microsoft Dynamics GPI restarted the virtual machine running the Microsoft Dynamics GP 2013 Web Client and tried to login but got the beow error message;

Web Client - Unxpected Error - An unexpected error has occurred. Press the Sign-in button to reconnect to the application. Correlation ID: 99259225-b352-b163-b7c1a166e06cAn unexpected error has occurred. Press the Sign-in button to reconnect to the application. Correlation ID: 99259225-b352-b163-b7c1a166e06c

Continue reading “Microsoft Dynamics GP 2013 Web Client Unexpected Error”

Microsoft Dynamics GP 2013 Service Pack 1 Available

Microsoft Dynamics GPLast Friday the Dynamics GP Service and Support blog announced that the first Service Pack for Microsoft Dynamics GP was available for download.

Service Pack 1 can be downloaded from the following pages;

As well as the service pack itself there is a new DVD containing the service pack which can be downloaded from the Product Release pages;

Coming Soon: Microsoft Dynamics GP 2013 Cookbook

Microsoft Dynamics GPWith an expected release date of June 2013, the Microsoft Dynamics GP 2013 Cookbook is to be released.

This is an update to the Microsoft Dynamics GP 2010 by Mark Polino, which was released three years ago. With the new version of Dynamics GP 2013 being released in December last year, it was time for a new version of the book to be written and with Mark was otherwise engaged writing the Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 so Packt Publishing approached me and asked if I would write the update.

So, in June this year the Microsoft Dynamics GP 2013 Cookbook by Ian Grieve and Mark Polino will be released;

Microsoft Dynamics GP 2013 Cookbook by Ian Grieve and Mark Polino

With this book you will:

  • Understand the various tips and tricks to master Dynamics GP, and improve your system’s stability in order to enable you to get work done faster
  • Discover how to solve real world problems in Microsoft Dynamics GP 2013 with easy-to-understand and practical recipes
  • Access proven and effective Dynamics GP techniques from authors with vast and rich experience in Dynamics GP

You can pre-order the Microsoft Dynamics GP 2013 Cookbook direct from Packt Publishing.

Microsoft Dynamics GP 2013 Web Client First Run On A Client

Microsoft Dynamics GPOver the last few posts, I’ve covered the installation of the Web Client Runtime, added the IIS role, created a self-signed certificate, installed the Web Client, ran the Configuration Wizard, and installed the GP Resource Web Cache. Now it is time to run the Web Client for the first time to ensure required components are installed on a client; I’m installing a new demo machine so I know one component won’t be installed.

Navigate to the address if the site hosting the Web Client. In the case when you have a self-signed security certificate (which I would only advise for demo or test systems) you will be presented with a warning that the site may not be safe; this is the one time I will recommend to someone that they go against the browser’s advice and click Continue to this website (like my credit card company, MBNA, who have a site with an invalid certificate, going on for six years now, and have the security team advise people to accept the invalid certificate and proceed);

Internet Explorer

Continue reading “Microsoft Dynamics GP 2013 Web Client First Run On A Client”

How To Install Microsoft Dynamics GP 2013 Web Client: Installing The GP Web Resource Cache

Microsoft Dynamics GPWith the Microsoft Dynamics GP Web Client installed and configured the Web Client is now available for use. However, there is one final additional product which can be installed from the Microsoft Dynamics GP 2013 setup utility and that is the GP Web Resource Cache which improves performance by enabling web client caching.

On a multi-machine deployment the GP Web Resource Cache should be installed on each Session Host machine.

Launch the Microsoft Dynamics GP 2013 setup utility and under Additional products select GP Web Resource Cache;

Microsoft Dynamics GP 2013 setup utility

Continue reading “How To Install Microsoft Dynamics GP 2013 Web Client: Installing The GP Web Resource Cache”

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 by Mark Polino

Microsoft Dynamics GPFollowing on relatively quickly from Leslie Vail’s new Microsoft Dynamics GP book, , available from Packt Publishing, comes Mark Polino with Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013.

This book will teach you how to build a dashboard using Excel 2013 with information from Microsoft Dynamics GP 2013, how to make Excel a true business intelligence tool with charts, sparklines and slicers and show how to utilise PowerPivot’s full potential to create even more complex dashboards;

Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 by Mark Polino

Continue reading “Building Dashboards with Microsoft Dynamics GP 2013 and Excel 2013 by Mark Polino”

How To Install Microsoft Dynamics GP 2013 Web Client: Running The Configuration Wizard

Microsoft Dynamics GPIn the last post, I showed how to install the Microsoft Dynamics GP Web Client; the next step is to run the Microsoft Dynamics GP Web Client Configuration Wizard from the Windows Start menu;

Microsoft Dynamics GP Web Client Configuration Wizard - Welcome

Continue reading “How To Install Microsoft Dynamics GP 2013 Web Client: Running The Configuration Wizard”

How To Install Microsoft Dynamics GP 2013 Web Client: Installing the Web Client

Microsoft Dynamics GPIn this series of posts, I’m taking a look at the steps needed to install the Microsoft Dynamics GP 2013 Web Client. In the previous posts I took a look at installing the Web Client Runtime, adding the IIS Role and a self-signed certificate created. With those steps completed, we can now install the Web Client itself.

This is done from the Microsoft Dynamics GP 2013 setup utility by selecting Web Client under the Additional Products section;

Microsoft Dynamics GP 2013 setup utility

Continue reading “How To Install Microsoft Dynamics GP 2013 Web Client: Installing the Web Client”

How To Install Microsoft Dynamics GP 2013 Web Client: Create A Self-Signed Certificate

Microsoft Dynamics GPEarlier in this series of posts, I took a look at installing the Web Client Runtime and adding the IIS server role. In this post I’ll take a look at installing a self-signed certificate (self-signed is really only a valid option for a demo or test system; on a live system you should really use a real certificate.

To create a self-signed one, open Internet Information Services (IIS) Manager and click on Server Certificates;

Internet Information Services (IIS) Manager - Server Home

Continue reading “How To Install Microsoft Dynamics GP 2013 Web Client: Create A Self-Signed Certificate”