The Future of Microsoft Dynamics GP, or “Project Green: Revenant”

Microsoft Dynamics GPLike the lich which won’t die and stay dead, Project Green rears it’s head once again. This time from former Dynamics NAV MVP Mark Brummel.


Image courtesy of hyena reality at FreeDigitalPhotos.net

Dynamics GP MVP Belinda Allen has responded with a blog post, The Future of Microsoft Dynamics GP, rebutting Mark’s statement about the future of Dynamics GP.

I’d encourage you to read Belinda’s post in full, but a couple of passages seem worthy of quoting:

Is GP Retired and in Maintenance Only Mode?

Microsoft Dynamics GP is NOT retired, or in maintenance only mode. I’m not sure from where Mark heard this rumor, but it is not anywhere close to being correct. This has been made very clear by the Microsoft team at every customer and partner facing event that has been held over the years, with the sharing of the Roadmap. The GP Roadmap always shows 2-3 versions out, unlike other Microsoft products (which are also not retiring) that show 1-2 versions out.

And the second quote:

Before I began writing this article, I reached out to Jeff Trosen, Engineering Manager at Microsoft, sharing Mark’s post. Jeff quickly replied: GP Engineering is happily working on features for the fall release of GP, we did not go into maintenance mode. If you look at our communications on GP, nothing has changed.

I’ve been working with Microsoft Dynamics GP for almost 15 years now (and have been blogging for 6 and a half years) and this story has come and gone several times in those years and Dynamics GP still has a presence on the roadmap.

It would be nice to see it die a final death, but, unfortunately, I’m sure the same conversations will be had again in future.

SQL View to Return Prior Day Logins

Microsoft Dynamics GPMicrosoft Dynamics GP is licensed, for full users, on a concurrent user basis. This means that you can create more users than can be logged in at the same time; unfortunately, this means that if users don’t log out correctly, that the license remains in use.

The below script can be plugged into a SmartList Designer to give easy visibility of who logged in before the current day.

CREATE VIEW uv_AZRCRV_GetPriorDayLogins AS
/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (https://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 2.0 UK: England & Wales (CC BY-NC-SA 2.0 UK).
*/
SELECT
	['User Activity'].USERID AS 'User ID'
	,ISNULL(['Users Master'].USERNAME, 'User Master record not found') AS 'User Name'
	,ISNULL(['Company Master'].INTERID, 'Company Master record not found') AS 'Inter ID'
	,['User Activity'].CMPNYNAM AS 'Company Name'
	,FORMAT(['User Activity'].LOGINDAT, 'yyyy-MM-dd') AS 'Login Date'
	,FORMAT(['User Activity'].LOGINTIM, 'hh:mm:ss') AS 'Login Time'
FROM
	ACTIVITY AS ['User Activity']
LEFT JOIN
	SY01400 AS ['Users Master']
		ON
			['User Activity'].USERID = ['Users Master'].USERID
LEFT JOIN
	SY01500 AS ['Company Master']
		ON
			['User Activity'].CMPNYNAM = ['Company Master'].CMPNYNAM
WHERE
	['User Activity'].LOGINDAT <= DATEADD(DAY, -1, GETDATE())
GO
GRANT SELECT ON uv_AZRCRV_GetPriorDayLogins TO DYNGRP
GO