Month: October 2023

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 sets the On Hold flag for a vendor as the record is created.

/*
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).
*/
CREATE TRIGGER 
	dbo.utr_AZRCRV_NewCreditorInactivate
ON 
	dbo.PM00200 --PM Vendor Master File (PM00200)
FOR INSERT
AS
UPDATE
	PM00200
SET 
	HOLD = 1
WHERE 
	VENDORID = (SELECT VENDORID FROM INSERTED)
GO

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 changes the On Hold flag on a vendor record if EFT details are added, updated or deleted.

/*
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).
*/
CREATE TRIGGER 
	dbo.utr_AZRCRV_HoldonUpdateEFTDetails
ON 
	dbo.SY06000 --Address Electronic Funds Transfer Master (SY06000)
FOR INSERT,UPDATE,DELETE
AS
UPDATE
	PM00200
SET 
	HOLD = 1
WHERE 
	PM00200.VENDORID = (SELECT VENDORID FROM DELETED)
GO

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 will activate horizontal scroll bars for all existing users

/*
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).
*/
UPDATE
		['Users Master']
	Set
		HSCRLARW = 1
	FROM
		SY01400 AS ['Users Master'] --Users Master (SY01400)
	WHERE
		HSCRLARW = 0

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 creates a trigger which activates horizontal scroll bars for new users as they are created.

/*
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).
*/
CREATE TRIGGER
	utr_AZRCRV_UpdateSY01400ActivateHorizontalScrollArrows
ON
	SY01400 --Users Master (SY01400)
AFTER INSERT AS
	UPDATE
		['Users Master']
	Set
		HSCRLARW = 1
	FROM
		SY01400 AS ['Users Master']
	INNER JOIN
		inserted AS INS
			ON
				INS.USERID = ['Users Master'].USERID
GO