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
If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.