Sample SQL Views for SmartLists (by Jen Kuntz)

Microsoft Dynamics GPI occasionally link to blog posts that other people have done and todays post is one of these.

Jen Kuntz is running a TIP Tuesday series of posts at the moment and her tip this week is looking at a set of SQL views from Microsoft (originally posted by Isaac Olson).

As Jen points out, while Microsoft bill these as for use with SmartList Designer, they will work with SmartList Builder or any other reporting tool (Excel Reports, Reporting Services Reports and so on).

To make use of these SQL views, you do need to have a CustomerSource login to download them and knowledge of creating views and granting permissions.

My addition to this would be a reminder that there are lots of other resources available from the wider community which can be freely amended and used in reporting, such as from Victoria Yudin.

You can read Jen’s full post here.

I try to keep up-to-date with blog posts about Dynamics GP, but the post from Isaac apparently went by without me seeing it, so it was good to get a second chance at reading about it from Jen.

** updated due to wrong name

Does Project Green Dynamics 365 Mean The Death Of Dynamics GP?

Microsoft Dynamics GPNewly anointed MVP Jen Kuntz, of Kuntz Consulting Inc. has a new blog post up where she discusses what the launch of Dynamics 365 means for Microsoft Dynamics GP and the rumours which have been springing up.

Unfortunately, some of these rumours seem to be coming from Microsoft partners themselves.

I was at the reIMAGINE Dynamics GP partner conference earlier this year, where Errol Schoenfish, the Director of Product Marketing at Microsoft, reiterated, and got us to stand up and repeat along with him that “Microsoft Dynamics GP is going nowhere.

Microsoft then displayed a slide showing the continuing development of Dynamics GP (and NAV and AX and SL alongside Dynamics 365):

RoadmapMicrosoft Dynamics GP roadmap

That was followed up more recently with a roadmap for Dynamics GP with the release of 2016 R2 at the start of December this year and GP 2018 at the start of December next year, with GP “NExt” following a year later:

RoadmapMicrosoft Dynamics GP roadmap

My reference to Project Green in the post title, was slightly tongue in cheek. Back in 2008, a merger of the Dynamics ERP was looked into briefly be Microsoft, before being discarded. That was Project Green.

It still comes up in conversations now; last year we had a prospect in who mentioned a competitor selling another ERP mentioning that GP would be merged with NAV. He stopped at that point when he saw my huge roll eyes, and confirmed it as Project Green when I asked. I then explained what it was and when it ended.

That’s the problem with rumours. When they start they can be difficult to stop. The message on Dynamics 365 from Microsoft hasn’t been great and needs to improve.

My MVP Renewed for 2016 And Jen Kuntz Awarded

Microsoft MVPWhile in America on vacation following reIMAGINE 2016, I received the notification email that I had been awarded the Microsoft Most Valuable Professional award for the fourth year running. It’s very nice to receive the award as it shows I am still contributing in a meaningful way to the Dynamics GP community.

There was another new MVP for Dynamics GP added to the roster this month as well; Jen Kuntz.

Jen has been a great contributor to the Dynamics GP community for a while now and I’m delighted to see that this has been officially recognised by Microsoft with her MVP award.

A Diary of reIMAGINE 2016: Part 7 – MVP Count = 4

reIMAGINE2016One of the nice things about coming to one of these conferences is meeting all of the people I have been speaking to online for the last few years.

Before now, I had only met Tim Wappat, so it is good to add some more names. Especially when you consider I have never met any of my fellow MVPs.

So far today, my MVP count is at four (and should increase later this evening):

  1. John Lowther who came in for a chat while I was setting up for my pre-conference training session on Workflow 2.0
  2. Belinda Allen who was setting up for her training session in the room next door; I popped through to see her when I was finished setting up.
  3. Mariano Gomez and David Musgrave who came in together to see me during the first break in the training.

I also met Jen Kuntz (who was helping Belinda with her session) at lunchtime, which was good as I have spoken to her online multiple times.