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 tabbles, make sure you do a backup first in case of problems.
Pingback: Enabling Email Cheque Remittances For All Suppliers | Interesting Findings & Knowledge Sharing
Pingback: Enabling Email Cheque Remittances For All Suppliers | azurecurve - DynamicAccounting.net - GP Technical Blogs - Microsoft Dynamics Community
Pingback: Everything Dynamics GP #41 | Interesting Findings & Knowledge Sharing