Enabling Email Cheque Remittances For All Suppliers

Microsoft Dynamics GPIn 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?

Your Name (required) -
Your Email (required) -

(Visited 412 times, 1 visits today)

3 thoughts on “Enabling Email Cheque Remittances For All Suppliers

Leave a Reply

Your email address will not be published. Required fields are marked *