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

● Ian Grieve ●  ● 1 Comment   ● 

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

● Categories: Dynamics, GP, GP Power Tools, Microsoft, Third Party Add-on ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

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

● Ian Grieve ●  ● 

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

● Categories: Analysis Cubes for Excel, Dynamics, GP, Microsoft ● Tags: , , , , , , , , , ,  ● Permalink ● Shortlink ●

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

● Ian Grieve ●  ● 1 Comment   ● 

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

● Categories: Dynamics, GP, GP OData Service, Microsoft, Packt Publishing, Publishing ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Microsoft Dynamics GP 2016 Cookbook Now Available

● Ian Grieve ●  ● 0 Comments   ● 

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.

● Categories: Dynamics, GP, Microsoft, Packt Publishing, Publishing ● Tags: , , , ,  ● Permalink ● Shortlink ●

Microsoft Dynamics GP 2016 Cookbook Now Available In August

● Ian Grieve ●  ● 1 Comment   ● 

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.

● Categories: Dynamics, GP, Microsoft, Packt Publishing, Publishing ● Tags: , , , , , , ,  ● Permalink ● Shortlink ●

Microsoft Dynamics GP 2016 Cookbook Available In January 2017

● Ian Grieve ●  ● 4 Comments   ● 

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

● Categories: Dynamics, GP, Microsoft, Packt Publishing, Publishing ● Tags: , , , , , ,  ● Permalink ● Shortlink ●

Real-world Business Intelligence with Microsoft Dynamics GP Available Now

● Ian Grieve ●  ● 1 Comment   ● 

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

● Categories: Dynamics, GP, Microsoft, Packt Publishing, Publishing ● Tags: , , , , , , , ,  ● Permalink ● Shortlink ●

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

● Ian Grieve ●  ● 1 Comment   ● 

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

● Categories: Analytical Accounting, Dynamics, GP, Microsoft, Packt Publishing, SmartList ● Tags: , , , , , , , , , ,  ● Permalink ● Shortlink ●

Preorder Real-world Business Intelligence with Microsoft Dynamics GP

● Ian Grieve ●  ● 1 Comment   ● 

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

● Categories: Dynamics, GP, Microsoft, Packt Publishing ● Tags: , , , , , , , , , , ,  ● Permalink ● Shortlink ●

Packt Publishing’s 2014 End Of Year $5 Dollar Offer

● Ian Grieve ●  ● 1 Comment   ● 

Packt PublishingPackt Publishing will again be celebrating the holiday season with an all books and videos on all topics for $5 offer.

Packt Publishing

From now, every eBook and video will be available on the publisher’s website for just $5. Customers are invited to purchase as many as they like before the offer ends on Tuesday January 6th, making it the perfect opportunity to try something new or to take your skills to the next level as 2015 begins.

With all $5 products available in a range of formats and DRM-free, customers will find great value content delivered exactly how they want it across Packt’s website this Xmas and New Year.

You can take advantage of the offer until the 6th January 2015.

Packt Pub have some great books available on Microsoft Dynamics GP as well as many other subjects; over the last few years I’ve picked up some great books on Dynamics CRM, SQL Server, Hyper-V, WordPress and HTML+CSS amongst others.

● Categories: Packt Publishing, Special Offer ● Tags: ,  ● Permalink ● Shortlink ●