In two previous posts I discussed testing Microsoft Dynamics GP 2010’s new Email Remittance functionality; first, by setting up creditors with an internal email address and, then, by transferring the email address from the INET1 field to the new EmailToAddress field.
The other script which I used, and forgot to post, was the one which configures all of the creditors, who are not currently configured for email remittances;
DECLARE @EmailMessageID VARCHAR(100)
SET @EmailMessageID = 'CREDITORREMITTANCE'
INSERT INTO SY04905
(EmailDictionaryID
,EmailSeriesID
,MODULE1
,EmailCardID
,EmailDocumentID
,EmailDocumentEnabled
,EmailMessageID
,EmailDocumentFormat)
(SELECT
0
,4
,19
,PM.VENDORID
,6
,1
,@EmailMessageID
,3
FROM
PM00200 AS PM (NOLOCK)
WHERE
(SELECT COUNT(*) FROM SY04905 SY
WHERE
SY.EmailCardID = PM.VENDORID
AND
SY.EmailDictionaryID = 0
AND
SY.EmailSeriesID = 4
AND
SY.MODULE1 = 19
AND
SY.EmailDocumentID = 6) = 0)
This script assumes you will be using the same Email Message for all creditors and, as always, when running a script, which updates tables, make sure you do a backup first in case of problems.
What should we write about next?
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.
3 thoughts on “Enabling Email Cheque Remittances For All Suppliers”