Streamline Payments in Dynamics GP: A Quick Guide to E-mail PM EFT Remittances

Table of Contents

Efficiently managing vendor payments is crucial for any business, and Microsoft Dynamics GP offers powerful tools to streamline this process. One of the most effective methods for modernizing your payment operations is by utilizing Electronic Funds Transfer (EFT) remittances sent directly via email. This not only accelerates payment notifications but also significantly reduces administrative overhead and paper usage. This comprehensive guide will walk you through the essential steps to configure and execute email EFT remittances in Dynamics GP, ensuring a smooth and reliable payment workflow.

Step 1: Laying the Groundwork – Verifying Email Functionality¶

Before diving into EFT-specific configurations, it is paramount to ensure that your Dynamics GP email functionality is robust and operational. This initial verification step, performed using the standard Check Remittance, helps isolate any potential issues with email setup from those related to custom EFT Word Templates. By confirming basic email sending capabilities first, you can efficiently troubleshoot any subsequent challenges.

Configuring Security for Report Access¶

To begin, you need to verify the security settings that control access to various forms and reports within Dynamics GP. Incorrect settings here can prevent users from accessing or sending the necessary remittance forms. This step ensures that the system is properly configured to recognize and utilize the correct report versions for your remittances.

1. Navigate to Microsoft Dynamics GP > Tools > Setup > System > Alternate/Modified Forms and Reports.
2. Within this window, select the REPORT ID currently in use for your Dynamics GP environment, such as “DEFAULTUSER” or another specific user role. This ensures that the correct security profile is being adjusted for report access.
3. Leave the Product field set to “All Products” to encompass all available modules. For the Type field, select “Reports,” and for the Series, you can either leave it as “All” or specifically choose “Purchasing” to narrow down the options relevant to vendor payments.
4. In the Report List section, expand the Purchasing module to reveal its sub-reports. Scroll down to locate the “Check Remittance” report. Ensure that Microsoft Dynamics GP is marked next to it. If the report is not listed or if an alternative version is marked, it indicates that a modified check remittance might not be in use or that the wrong version is selected. Finally, select Save to apply these changes. This confirms that the standard Dynamics GP Check Remittance report is accessible for testing email functionality.

This initial check is critical. If email sending fails even with the standard Check Remittance, the problem lies with your core Dynamics GP email configuration (e.g., MAPI or Exchange setup) rather than the remittance template itself. Addressing these foundational issues first will save considerable time in the overall setup process.

Step 2: Preparing Your Vendors for EFT Remittances¶

Once the general email functionality is confirmed, the next crucial step is to configure your vendor records for Electronic Funds Transfer. This involves setting up their bank account details and specifying how they will receive their remittance notifications. Proper vendor setup is the backbone of a successful EFT payment process, ensuring payments are directed to the correct accounts and notifications reach the right contacts.

Establishing Vendor EFT Information¶

For each vendor you intend to pay via EFT, specific banking details must be accurately recorded in their vendor master file. This information is essential for generating the NACHA file for your bank and for sending the corresponding email remittance. Without this setup, Dynamics GP cannot process EFT payments for the vendor.

1. Go to Purchasing > Cards > Vendor. Select the relevant vendor ID for whom you want to set up EFT.
2. In the Vendor Maintenance window, select the Address button to open the Vendor Address Maintenance window. Here, you will typically find the address used for purchasing.
3. On the Vendor Address Maintenance window, locate and click the EFT Bank button. This opens the Vendor EFT Bank Maintenance window, which is dedicated to storing the vendor’s banking information.
4. Enter the vendor’s bank country/region, bank name, bank account number, and routing transit number. Crucially, ensure the EFT Address ID field is correctly populated. This ID links the vendor’s bank details to specific payment addresses or remittance types. Verify that the bank account is marked as Active.
5. Within the Vendor EFT Bank Maintenance window, also locate the Email Address field for remittances. Enter the email address(es) where the vendor wishes to receive their EFT remittance notifications. You can often enter multiple addresses separated by a semicolon if necessary. This email address is distinct from the primary vendor contact email and is specifically used for payment notices. Save your changes before exiting these windows.

Assigning Remittance Options¶

Beyond just bank details, you need to specify the preferred method for sending remittance notices to your vendors. Dynamics GP allows flexibility in how these notifications are handled, whether through email, traditional print, or a combination. Selecting the correct option ensures that your vendors receive timely and accurate payment information in their preferred format.

1. Still in the Vendor Maintenance window for the selected vendor, navigate to the Options button. This opens the Vendor Options window.
2. Within the Vendor Options window, locate the EFT Options section. Here, you will find settings related to EFT payments and remittances.
3. Select the desired Remittance Type. For email remittances, choose Email. You might also see options for “Print,” or “Both” (Print if mail cannot be sent). Ensure “Email” is explicitly selected to leverage the email functionality.
4. Verify that the Send Remittance In field specifies “Email” and that a valid email address is entered in the associated field, matching the one set in the EFT Bank Maintenance or another designated remittance email. This ensures that the system knows to generate and send an email notification when an EFT payment is processed for this vendor. Save your changes and close all vendor-related windows.

By meticulously completing these vendor setup steps, you establish the foundation for accurate and automated EFT payment processing and remittance delivery. Each detail, from bank account numbers to email addresses, plays a critical role in the smooth operation of your payment system.

Step 3: Customizing the EFT Remittance Word Template¶

While the previous steps ensure email functionality and vendor setup are in place, the visual presentation and content of your EFT remittance email are controlled by a Word Template. Dynamics GP utilizes Word Templates for most of its document generation, offering significant flexibility in customization. An effective template enhances professionalism and provides clear, concise payment information to your vendors.

Understanding Word Templates for EFT¶

The EFT Remittance Word Template dictates the layout, branding, and data fields displayed in the email sent to your vendors. It allows you to include essential details such as the invoice numbers being paid, payment amounts, discount taken, and your company’s branding. While Dynamics GP provides a default template, businesses often customize it to align with their specific needs and corporate identity. This customization is key to a professional and informative remittance.

Dynamics GP leverages Microsoft Word’s content controls to pull data directly from the system into your remittance document. This means you can design the template in Word, adding your company logo, custom text, and arranging data fields as required. The system will then populate this template with actual payment data during the remittance process.

Considerations for Template Modification¶

Modifying Word Templates can be a detailed process, often requiring a good understanding of Word’s developer tools and Dynamics GP’s report writer functionality. If your business requires extensive customization beyond simple logo placement, it might be beneficial to consult Dynamics GP documentation or a specialist. The goal is to create a template that is both informative and visually appealing, without compromising the integrity of the data.

• Branding: Incorporate your company’s logo, colors, and fonts to ensure brand consistency.
• Essential Data: Make sure all critical payment details are clearly visible, including vendor name, payment date, EFT transfer amount, and a detailed breakdown of invoices paid (invoice number, amount due, discount taken, net amount).
• Contact Information: Include clear contact information for any payment-related inquiries.
• Legal Disclaimers: Add any necessary legal disclaimers or notes relevant to the payment.
• Testing: Thoroughly test any modified template by sending test remittances to ensure all data populates correctly and the layout is as intended.

For in-depth instructions on how to modify Word Templates, refer to the Dynamics GP Report Writer manual. Assistance from Microsoft support professionals regarding Word Template modifications falls under specific guidelines. These guidelines help determine when a support case becomes a consulting engagement for more complex customizations. It is important to be aware that extensive modifications may incur consulting expenses beyond standard support.

Step 4: Executing the EFT Remittance Process¶

With your email functionality verified, vendor EFT details configured, and remittance template prepared, you are now ready to process your Payables EFT payments and send out email remittances. This step integrates all prior configurations into a seamless payment execution process within Dynamics GP, culminating in the electronic delivery of payment notifications.

Building and Processing the EFT Batch¶

The process begins with building a computer check batch, similar to how you would for printed checks, but with the critical difference of selecting EFT as the payment method. This distinction tells Dynamics GP to prepare electronic payment files and generate email remittances instead of physical checks. Ensuring all relevant invoices are keyed against the correct EFT Address ID for the vendor is a prerequisite for them to be included in this batch.

1. Navigate to Purchasing > Transactions > Select Checks. In the Select Checks window, create a new batch. When prompted, select EFT as the Payment Method for this new batch. This is a crucial step that differentiates it from a standard check batch.
2. Proceed with building the computer check batch as usual, selecting the invoices you wish to pay. Dynamics GP will automatically identify eligible invoices based on vendor EFT setup. Once the batch is built, ensure all selected payments are accurate.
3. After building the batch, when you typically would print checks, you will instead encounter the Process Payables Remittance window. This window replaces the “Print Checks” window because the system recognizes an EFT payment method is in use.
4. In the Process Payables Remittance window, mark the radio box for Remittance Form. Critically, also mark the checkbox for Send Document in E-mail (Print if mail cannot be sent.). This instruction explicitly tells Dynamics GP to generate and send the remittance via email. Select Process to continue.

Finalizing and Reviewing the Remittance¶

After you initiate the processing, Dynamics GP will prepare the email remittances using your configured Word Template. The system provides a final opportunity to review the output type and offers a report to confirm successful delivery or identify any exceptions. This ensures that you have full visibility into the remittance process and can address any issues promptly.

1. The Report Destination window will appear. If a Word Template is being used for your remittances, the Report Type will automatically default to Template. This confirms that the system is using your customized template for the email content. Select OK to proceed.
2. Complete and post the checkrun as you normally would. This will finalize the EFT payment transactions in Dynamics GP and prepare the electronic payment file for your bank.
3. Upon completion, the Send Remittance Exception Report will be displayed. This report is your critical tool for verifying the success of your email remittances. Ideally, each entry should state “Document sent successfully.” Carefully review this report for any entries indicating emails that did not send successfully. Common reasons for failure include incorrect email addresses, issues with the email server, or problems with the template itself.

Troubleshooting Email Delivery Issues¶

If the Send Remittance Exception Report shows failures, immediate investigation is required. Check the vendor’s email address for typos, confirm your Dynamics GP email server settings (SMTP configuration), and verify that the Word Template is valid and not corrupted. Often, a small error in the email address or a temporary network issue can prevent successful delivery. Resolving these issues quickly ensures vendors receive their payment notifications without delay.

Benefits of Streamlined EFT Remittances¶

Implementing email EFT remittances in Dynamics GP offers numerous advantages that contribute to greater operational efficiency and improved vendor relationships. Moving away from manual processes and paper-based communications brings a host of benefits that directly impact your bottom line and administrative workload.

Enhanced Efficiency and Cost Savings¶

Automating the remittance process significantly reduces the time and resources traditionally spent on printing, folding, stuffing, and mailing physical documents. This translates into substantial savings on postage, paper, and labor costs. Furthermore, the electronic nature of EFT and email remittances drastically speeds up the notification process, ensuring vendors are informed of payments almost instantaneously. This efficiency allows your accounts payable team to focus on more strategic tasks rather than repetitive manual processes.

Improved Accuracy and Reduced Errors¶

Digital remittance processes inherently reduce the risk of human error associated with manual data entry and handling. Information is pulled directly from Dynamics GP, ensuring consistency between the payment data and the remittance notice. Automated systems are less prone to mistakes, leading to greater accuracy in payment notifications and fewer discrepancies for your vendors. This enhanced accuracy fosters trust and reduces potential disputes.

Better Vendor Relationships¶

Providing prompt and clear payment notifications is key to maintaining strong vendor relationships. Email EFT remittances offer vendors timely access to detailed payment information, helping them reconcile their accounts more quickly. The professional and consistent delivery of these notices improves transparency and builds confidence, potentially leading to better terms and stronger partnerships. Vendors appreciate efficiency and clarity, and this system delivers both.

Environmental Responsibility¶

By reducing paper consumption, your organization also contributes positively to environmental sustainability efforts. Opting for digital remittances aligns with green initiatives and reflects a commitment to environmentally friendly business practices. This can also enhance your company’s public image and appeal to partners and customers who value corporate social responsibility.

Enhanced Security¶

While email itself can be vulnerable, Dynamics GP’s integration with secure email protocols and the ability to control access to sensitive payment information within the system provide a robust framework. EFT payments, by their nature, are more secure than physical checks, which can be lost, stolen, or fraudulently altered. The audit trails within Dynamics GP also provide a clear history of all payment and remittance activities, enhancing overall security and compliance.

Conclusion¶

Streamlining your payment processes with email PM EFT remittances in Microsoft Dynamics GP is a strategic move that enhances efficiency, reduces costs, and strengthens vendor relationships. By following these steps—from verifying core email functionality and configuring vendor details to customizing templates and executing the payment run—you can fully leverage the power of Dynamics GP for modern payment management. The investment in setting up this system will pay dividends through improved accuracy, faster notifications, and a more sustainable operational footprint.

What are your experiences with EFT remittances in Dynamics GP? Do you have any tips or challenges you’ve encountered during the setup or daily use? Share your insights in the comments below! Your feedback can help other users optimize their payment processes.