SQL Scripts for Microsoft Dynamics GP: SQL View to Return Segments Not Linked to Accounts

Microsoft Dynamics GPThis script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posting the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP.

This script returns segments which exist, but which are not linked to accounts; specifically it is checking segment 2 which the client used to store the cost centre.

CREATE VIEW [dbo].[uv_AZRCRV_UnlinkedCostCentres] AS
Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk) This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int). */
SELECT ['Segment Description Master'].SGMNTID ,['Segment Description Master'].DSCRIPTN FROM GL40200 AS ['Segment Description Master'] WITH (NOLOCK) --Segment Description Master (GL40200) LEFT JOIN GL00105 AS ['Account Index Master'] WITH (NOLOCK) --Account Index Master (GL00105) ON ['Account Index Master'].ACTNUMBR_2 = ['Segment Description Master'].SGMNTID WHERE ['Segment Description Master'].SGMTNUMB = 2 AND ['Account Index Master'].ACTINDX IS NULL GO GRANT SELECT ON uv_AZRCRV_UnlinkedCostCentres TO DYNGRP GO

MVP Alumni from Microsoft Next Generation Experiences

MicrosoftI was a Microsoft MVP between 2013 and 2018 and then part of Microsoft Reconnect, which is for former MVPs. Reconnect seemed to die a quiet death a couple of years ago when all communications ceased and they became impossible to contact; it now seems that there is a new recognition of former MVPs from Microsoft Next Generation Experiences in the form on an MVP Alumni badge awarded to former MVPs via Credly.

Certificate confirmation

All the information I’ve had of this was an email from Credly inviting me to accept the badge, so I’m not sure if there is more to come and if indeed if this is a replacement for the Reconnect program (I did a search and found a small smattering of posts online with a copy of an email from Microsoft seemingly confirming the end of the Reconnect program, but I’ve not personally received this email).