Symptoms

Microsoft Dynamics GP 2010 offers new functionality to email out the EFT Remittance in Payables Management.

Cause

PREREQUISITES:
•Microsoft Office 2007 or Office 2010.

•Microsoft Outlook must be 32 bit. (Click File|Help and you should see '32-bit' written next to the Version number on the right side.)

•Verify in Control Panel|Programs and Features that the 'Open XML SDK 2.0 for Microsoft Office' is installed. (Required)

•The "Microsoft Dynamics GP Add-in for Microsoft Word' is only needed if you will be modifying the Word Template. (Optional)

For testing, set the security in Dynamics GP to the original unmodified Check Remittance. (Tools|Setup|System|Alternate Modified Forms and Reports). It is easiest to use the original check remittance for the sake of testing and make sure you can get the emails to send successfully first, before you introduce a modified Check Remittance into the picture.

 

NOTE:  If you have Mekorma MICR installed, make sure the Mekorma MICR System Options are set to have email enabled, or else the "Send Document in email' checkbox in the Remittance window will not be available to mark (or grayed out).  To check this setting, go to Microsoft Dynamics GP | Tools | Setup | System | Mekorma MICR | System Options.  Mark the checkbox for 'Enable Email Remittance' and click Save

Resolution

STEPS:


Step 1.  Go to Microsoft Dynamics GP|Tools|Setup|Company|Email Settings.

    a. Mark the Document Options and File Formats you want to allow.  (This creates the pick-list you see when you set it up for each vendor.)

    b. Click on the Purchasing Series link and mark the checkbox for Vendor Remittance. (Keep it simple as possible for testing.  Don't use a Message ID yet.)  Click OK.  Click OK again to close the window.

Step 2.  Go to Cards|Purchasing|Vendor.  Select the Vendor ID that you want to send the remittance to.

   a.  Next to the Address ID, click on the 'i' button to open the Internet Information window.  For testing, enter your own email address in the TO: section for E-Mail Addresses at the top.  (Once it is working, you can edit it later to be the vendor's email address.)  Click Save
        and close the Internet Information window.

   b.  On the Vendor Maintenance window, click the E-mail button.  In the bottom section, mark the checkbox for Vendor Remittance and choose which Format to use.  (We recommend to test with .docx or .html first just to get it working.)

Step 3.  During the Payables checkrun process:

 a. Outlook must be open on the same workstation that Dynamics GP 2010 is on.

 b. Build a computer check batch and select EFT as the Payment Method for the new batch.

 c. When you click to print checks, you will get a Process Payables Remittance window instead of a Print Checks window, since it is an EFT and not a check.  Mark the radio box for Remittance Form, and also mark the checkbox for Send Document in E-mail.  Click Process.

Step 4.  You should receive the test email for review.  Once you have tested and the emails are working successfully, make sure to change the email address on the vendor to be their email address and not yours.

Step 5.  Verify in your Sent Items folder in Outlook that the emails went out.  (They could still be in the Outbox too, so make sure they are not stuck there due to Outlook settings.)

If these steps don't work for you, please open a support incident or refer to the Report Writer manual for more information on using Word Template functionality.  If you have questions on how to modify the Word Template, refer to the Report Writer manual or open a support case.  Please note that the assistance we will provide with Word Template modifications is outlined in Knowledge Base (KB) #850201.  Anything beyond what is outlined in this KB article may be considered a consulting expense, and beyond what we can do in a regular support case.  Please refer to our policy outlined below:

850201 Guidelines that Microsoft support professionals use to determine when a support case becomes a consulting engagement for Report Writer, SSRS, Word Templates, SmartList Builder, SQL scripts, Business Alerts, VB Script, Modifier/VBA and Configurator Files
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;850201

More Information

The above article has also been published externally on the blog site:

https://community.dynamics.com/gp/b/dynamicsgp/archive/2012/06/19/quick-step-guide-to-e-mail-eft-remittances-in-payables-management-for-microsoft-dynamics-gp-2010.aspx

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×