I am very much an advocate for using the Microsoft Dynamics GP application for making changes to configuration or data rather than jumping straight to the SQL database. However, sometimes needs really must.
I was onsite with a client a few weeks ago to assist them in implementing Purchase Order Processing and, as part of this implementation, I needed to enable the emailing of the purchase order. Typically, I would do this through the Company E-mail Setup ()) window, but the client is configured to use Exchange for emails and I don’t have an Exchange account on their system.
Due to my location compared to the users, it was quicker to create an SQL script to enable the email rather than trying to locate a user with the relevant permissions to screen share with:
UPDATE SY04903 SET EmailDocumentEnabled = 1 ,EmailMessageID = 'PO' WHERE EmailDictionaryID = 0 AND EmailSeriesID = 4 AND MODULE1 = 12 AND EmailDocumentID = 1
The highlighted section is the name of the Message ID for the PO.
As always before running a script, ensure you test the script and have a good backup of your company database.