Testing Remittances By Email – Keeping Emails Internal

Microsoft Dynamics GPAs you’ve probably been able to tell from my previous posts, I’ve been assisting a client in configuring Microsoft Dynamics GP 2010 so they can test remittances by email.

One of the things I have done for them is produce two SQL scripts to ensure emails do not leave their organisation and reach suppliers telling them of payments being made in the test system.

The first script updates any creditor currently in Microsoft Dynamics GP with an email address in the Internet Information window accessible from the i button (Cards » Purchasing » Creditor) with an email address specified in the @TestEmail variable defined at the top of the script;

SET @TestEmail = ’email@example.com’

   INET1 = @TestEmail
   ,EmailToAddress = @TestEmail
   ,EmailCcAddress =
   ,EmailBccAddress =
   Master_Type = ‘VEN’

As the client didn’t have many creditors set up in GP with an email address, I created the second script to add an email address for all creditors on the system in bulk so, instead of spending their time doing data entry, the client could spend their time testing;

SET @TestEmail = ’email@example.com’

   PM00300 PM3
      SY01200 SY12
      SY12.Master_ID = PM3.VENDORID

This second script will eventually be amended to default in an internal email address into the bcc Email Address field on the live system so that a record is kept of all emails sent out of Microsoft Dynamics GP.

As always with SQL scripts, before running them please ensure you have a valid backup of the database in case of problems.

Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you'd like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.
Your Name (required):
Your Email (required):
Enquiry message:

What should we write about next?

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

2 thoughts on “Testing Remittances By Email – Keeping Emails Internal

Leave a Reply

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