Microsoft Dynamics GP Book Roundup

Microsoft Dynamics GPThere are a number of books available for Microsoft Dynamics GP which have been written by various people across a umber of years (although a few names crop up repeatedly). I thought it might be useful to list the books which are currently available for each version of Microsoft Dynamics GP; some of the books are only available for older versions of Dynamics GP, but the information within is still mostly relevant.

To avoid any appearence of favouritism, I have listed them in Dynamics GP version and author surname order (when multiple authors, the first listed author’s name is used).

Where there is no version in the name I have made by best guess as to which version it was written against.

Microsoft Dynamics GP 2018

Microsoft Dynamics GP 2016

Continue reading “Microsoft Dynamics GP Book Roundup”

Hands On With the GP Power Tools – Administrator Tools: Administrator Settings – Colors Tab

Winthrop DCThis post is part of the Hands On With the GP Power Tools (GPPT) – Administrator Tools series in which I am taking a hands on look at the various tools offered by GPPT.

In this little subseries on the Administrator Settings (GP Power Tools area page >> Settings >> Administrator Settings), the first piece of functionality I’m going to cover is the Company Color Scheme Settings. This is functionality which I have written about before in the Microsoft Dynamics GP 2013 Cookbook when GP Power Tools was still the Support Debugging Tool and was free from Microsoft; this chapter was cut from the 2016 Cookbook as we were only covering standard Dynamics GP functionality.

This is one of the features which I already knew well and liked; the main use I, and my clients make of this function, is to make it obvious whether a user is logged into a live or test company (and sometimes which of the live companies).

To activate the Company Color Scheme Settings function, mark the Activate Company based Color Schemes checkbox and then use the Select Theme Colors to select from one of the many themes available:

Administrator Settings - Colour tab

Continue reading “Hands On With the GP Power Tools – Administrator Tools: Administrator Settings – Colors Tab”

Hands On With Microsoft Dynamics GP 2016 R2: Configure Analysis Cubes

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; 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:

Analysis Cubes Configuration Wizards

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

Hands On With Microsoft Dynamics GP 2016 R2: Configure & Use OData Service

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

I am not going to cover the configuraion and use of OData in this post, as it is not an area with which I have much experience. However, I know a man who does and I wrote a book with him in 2016:

Microsoft Dynamics GP Cookbook

Mark Polino is one of the three top people for reporting from Microsoft Dynamics GP and, in Chapter 13: Modern Business Intelligence for Microsoft Dynamics GP of the Microsoft Dynamics GP 2016 Cookbook, Mark covered how to configure and use the GP OData Service.

The full outline of topics covered by Mark is as follows:

  • Introduction
  • Activating OData for better external analysis
  • Secure OData to control access
  • Connecting OData to Excel for Business Intelligence
  • Connecting GP to Power BI with OData
  • Adding Power BI to the home page in Dynamics GP

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

Microsoft Dynamics GP 2016 Cookbook Now Available

Microsoft Dynamics GPMark Polino and I have been working on a new version of the Microsoft Dynamics GP Cookbook for Dynamics GP 2016. Originally, it was scheduled for publication in January 2017.

However, Mark and I were able to proceed a tad ahead of schedule, meaning the Cookbook is now available:

Microsoft Dynamics GP Cookbook

Despite being early, the quality of the book is as high, if not higher, than previous versions as this book is a genuine collaboration between Mark and I. By splitting the work in this way, we were each able to focus on particular areas in which we had strengths.

We also received good feedback, to guide improvements, from fellow MVPS Leslie Vail and Jivtesh Singh.

You can order the book from Packt Publishing.

Microsoft Dynamics GP 2016 Cookbook Now Available In August

Microsoft Dynamics GPMark Polino and I have been working on a new version of the Microsoft Dynamics GP Cookbook for Dynamics GP 2016. Originally, it was scheduled for publication in January 2017.

However, Mark and I were able to proceed a tad ahead of schedule, meaning the Cookbook is now slated for release in August:

Microsoft Dynamics GP Cookbook

That’s right; scheduled for release this month. Five months ahead of schedule. Don’t worry though, the quality is as high, if not higher, than previous versions as this book is a genuine collaboration between Mark and I. By splitting the work in this way, we were each able to focus on particular areas in which we had strengths.

We also received good feedback, to guide improvements, from fellow MVPS Leslie Vail and Jivtesh Singh.

You can pre-order the book from Packt Publishing, and very soon your pre-orders will be shipped. From what I gather the book should be available to order, as opposed to pre-order, in the next week or so, so you won’t need to wait long to receive your copy.

Microsoft Dynamics GP 2016 Cookbook Available In January 2017

Microsoft Dynamics GPMark Polino and I are working on a new version of the Microsoft Dynamics GP Cookbook for Dynamics GP 2016.

The book is currently scheduled for release in January 2017 and can be pre-ordered now from Packt Publishing:

Microsoft Dynamics GP Cookbook

Real-world Business Intelligence with Microsoft Dynamics GP Available Now

Microsoft Dynamics GPI mentioned a couple of months ago that there was a new book coming for MIcrosoft Dynamics GP (and it wasn’t my new Workflow 2.0 book.

Well, that book is Real-world Business Intelligence with Microsoft Dynamics GP by Dynamics GP MVPs Belinda Allen and Mark Polino:

Real-world Business Intelligence with Microsoft Dynamics GP

Continue reading “Real-world Business Intelligence with Microsoft Dynamics GP Available Now”

MDGP 2015 R2 Feature of the Day: Analytical Accounting Transaction Lists

Microsoft Dynamics GPMicrosoft Dynamics GP 2015 R2 will soon be released (due late May/early June 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 fourth Feature of the Day is Analytical Accounting Transaction Lists.

This feature provides improvements to SmartLists and Excel Reports for Analytical Accounting (AA) transaction information. The first improvement is an expansion of the amount of information available to be included as columns in the AA SmartLists and Excel Reports. AA tracks a lot of information for each record, and we’ve included more of this data in the SmartLists and Excel Reports.

Microsoft have also improved the way the AA dimension code information displays in the lists. In prior releases, the lists contained a single column for the AA transaction dimension code. Thus, if the company is tracking more than one dimension on a transaction, multiple lines were required in the list for a distribution entry.

In GP2015 R2, they have updated the SmartLists and Excel Reports to display a column for each transaction dimension, showing the code assigned for that dimension.

For example, the below SmartList shows how the list would display for a company tracking Cost Center and Project as AA transaction dimensions.

Analytical Accounting SmartList

The change in how the data displays improves readability of the report, and also improves the ease with which users can summarize and work with the data in Excel using pivot table functionality.

Analytical Accounting is one of the modules which is not much used, but can add substantial analysis without needing the chart of accounts to be overly complicated.

If you’re thinking of starting to use Analytical Accounting, more information is available in my second book, Microsoft Dynamics GP Financial Management:

Amazon.com Amazon.co.uk

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

Preorder Real-world Business Intelligence with Microsoft Dynamics GP

Microsoft Dynamics GPI was just browsing the Packt Publishing website (as you do) and found that there is a new book about Microsoft Dynamics GP being released next month.

Real-world Business Intelligence with Microsoft Dynamics GP by Dynamics GP MVPs Belinda Allen and Mark Polino:

Real-world Business Intelligence with Microsoft Dynamics GP

Continue reading “Preorder Real-world Business Intelligence with Microsoft Dynamics GP”