azurecurve

This 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

Click to show/hide the Series Index


New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1Specify Dimensions on Posted Entries Applications With Realized Gains or Losses
New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1Specify Dimensions on Posted Entries Applications With Realized Gains or Losses
New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1Specify Dimensions on Posted Entries Applications With Realized Gains or Losses

I 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.

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).