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”

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

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.

Packt Publishing – 10 Years, $10 for 10 Days (4 days remaining)

Packt PublishingThis month marks 10 years since Packt Publishing embarked on its mission to deliver effective learning and information services to IT professionals. In that time it has published over 2,000 titles and helped projects become household names and awarding over $400,000 through its Open Source Project Royalty Scheme.

To celebrate this milestone, from June 26th, Packt is offering all of its eBooks and Videos at just $10 each for 10 days (four days remaining); this promotion covers every title and there are no restrictions on the number of titles that can be bought by July 5th.

Packt Publishing - 10 Years, $10 for 10 Days

2,000th Book Published; Join Packt In Their Celebration With A “Buy One, Get One Free” Offer

Microsoft Dynamics GPPackt Publishing celebrates their 2000th title with an exclusive offer – We’ve got IT covered!

Known for their extensive range of pragmatic IT ebooks, Packt Publishing are celebrating their 2000th book title ‘Learning Dart’ and they want their customers to celebrate too.

To mark this milestone Packt Publishing has launched a ‘Buy One Get One Free’ offer across all eBooks until 26th March.

2,000th Book Published; Join Packt In Their Celebration With A "Buy One, Get One Free" Offer

Packt is one of the most prolific and fast-growing tech book publishers in the world. Originally focused on open source software, Packt contributes back into the community paying a royalty on relevant books directly to open source projects. These projects have received over $400,000 as part of Packt’s Open Source Royalty Scheme to date.

Their books focus on practicality, recognising that readers are ultimately concerned with getting the job done. Packt’s digitally-focused business model allows them to quickly publish up-to-date books in very specific areas across a range of key categories – web development, game development, big data, application development, and more. Their commitment to providing a comprehensive range of titles has seen Packt publish 1054% more titles in 2013 than in 2006.

Click the banner above or this link to browse Packt’s collection of books and take advantage of this buy on, get one free offer.

Don’t forget there are a number of Microsoft Dynamics GP books available including my own book Microsoft Dynamics GP 2013 Financial Management and the Microsoft Dynamics GP 2013 Cookbook co-authored with Mark Polino.