I 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
The web client was a god addition to Microsoft Dynamics GP and I do like the HTML 5 version introduced in Microsoft Dynamics GP 2016 RTM. While we have a few clients using it, and some only use the web client, we’ve not had any clients using both the web client and Account Level Security.
MVP Jen Kuntz is different; she’s currently looking at the web client for the company she works with and has come across an interesting problem.
The short version is printing the standard report version of the Trial Balance doesn’t work in the web client when Account Level Security is enabled:
Related to this problem, is another problem whereby user’s don’t have access to any accounts and so can’t do anything around transaction entry, enquiries or reports.
For full details of both of these issues, read Jen’s blog.
As Jen notes, both of these issues have written up as outstanding quality issues:
- Bug #1 is Trial Balance report does not work when signing into Web Client with Windows Authentication if Account Security is enabled.
- Bug #2 is Web Client users not able to post if Account Security is turned on. The user receives the error “Access denied/Account Missing”
The bad news is there is no timeline for fixing them, and from the sounds of it, it’ because there aren’t a lot of customers reporting this issue back to Microsoft. A “product suggestion” has been added to the new Ideas site for this which Jen encourages you to vote for:
Bug #1 aka product suggestion #1 link is here.
Bug #2 aka product suggestion #2 link is here.
Newly 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):
Microsoft 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:
Microsoft 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.
While 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.
One 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):
- John Lowther who came in for a chat while I was setting up for my pre-conference training session on Workflow 2.0
- 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.
- 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.