Keep up to date with the latest information about Microsfot Dynamics GP through articles from the Perfect Image and azurecurve blog.
SQL Trigger To Automatically Enable Email Documents In Purchasing – Purchase Orders
November 9th, 2015 by Ian Grieve
When creating a new vendor there is a fair bit of information which needs to be entered and it is sometimes nice to reduce the amount which needs to be done manually; in the last post I had a script to enable the email document for Check Remittances.
The below script creates a trigger on the SY04905 table to automatically flag the purchase orders to be emailed out in PDF format and using a Message ID of PURCHASEORDER respectively.
/* Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (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_Update_SY04905_Activate_PO ON dbo.SY04905 CREATE TRIGGEAFTER Insert AS -- Enable Purchase Order UPDATE Email SET EmailDocumentEnabled = 1 ,EmailMessageID = 'PURCHASEORDER' ,EmailDocumentFormat = 3 FROM SY04905 AS Email INNER JOIN inserted ON Email.EmailDictionaryID = 0 AND Email.EmailSeriesID = 4 AND Email.MODULE1 = 12 AND Email.EmailCardID = inserted.EmailCardID AND Email.EmailDocumentID = 1 GO