How to Set up EFT Payments Within Dynamics GP

In this article I am going to show you how to set up EFT for Payables in Dynamics GP from the initial setup to retrieving the file you send to your bank. This will include:

  • Registering for EFT Payables
  • Setting your checkbooks up for EFT payments
  • Setting your vendors up for EFT
  • Emailing remittances to your vendors
  • Generating actual EFT files and emailing remittances to vendors

First check that your GP company is registered for EFT for Payables

(Administration > Setup > System > Registration)

Make sure that the EFT Payables box is checked. If not, select it and click OK.

Dynamics GP EFT Payments

Set up your EFT File Format

(Financial > Cards > EFT File Format)

This is where you set up the EFT file format according to the specifications of the bank you use. You will need to get this information from the bank, which will tell you what features you need. Typically, you can use one of the default ones in GP, but you can create a customized one under User-Defined in Format Type.

US – NACHA PPD and PPD+ are intended for payments to individuals/personal checking accounts. US – NACHA CCD and CCD+ are intended for payments to organizations/corporate accounts.

Dynamics GP EFT Payments

You can edit the descriptions for each line, but remember that you will be the only one that sees that. To see where the information is pulling from, click the double arrow in the right-hand corner to see the GP fields being used in the format or to type in a unique value.

Set up your checkbooks that you will use for EFT payments

(Financial > Cards > Checkbook)

In the Checkbook Maintenance window, select a Checkbook ID and click EFT Bank.

Dynamics GP EFT Payments

In the Checkbook EFT Bank Maintenance window, enter the bank information relating to that checkbook.

Dynamics GP EFT Payments

After you’ve entered the bank information, click Payables Options.

Dynamics GP EFT Payments

Select an EFT File Format under Single Format and your EFT Payment Number choice. Select the EFT File format that you created earlier. I recommend selecting EFT numbers as it marks a clear difference in your system.

Dynamics GP EFT Payments

Select file locations for prenote and EFT ACH output. (Hint: Sometimes adding spaces, characters, or periods can give you an error message when generating files so try to avoid those!) You can click Generate Prenotes to test the output.

Set up for EFT Vendors

(Purchasing > Cards > Vendor)

Set up the vendors you would like to pay via EFT files. Click on the blue underlined Remit To to update the address to include EFT options.

Dynamics GP EFT Payments

Click EFT Bank in the right-hand corner.

Dynamics GP EFT Payments

Enter the necessary bank information for the EFT transfer. Make sure the Currency ID and Bank Country match with the vendor and checkbook. Click OK in this window and then Save in the Vendor Address Maintenance window. Repeat these steps for every vendor you would like to pay via EFT.

Dynamics GP EFT Payments

Configure Email and Emailed Remittances to Vendors

Now let’s set up email remittances (Dynamics GP > Tools > Setup > Companies > Email Settings). Click the formats you would like to allow then select Purchasing Series.

Dynamics GP EFT Payments

In the Purchasing Email Setup window, check enable at the top of the screen and then Click OK in this window and the next.

Dynamics GP EFT Payments

Open the Vendor card you would like to configure email for (Cards > Purchasing > Vendor). Click on the World button next to the Address field to open the Internet Information window.

Dynamics GP EFT Payments

Type your own email in this Internet Information window to test. You can change this to the Vendor’s email address later. Save and close the window.

Dynamics GP EFT Payments

After saving your email, click the Email button on the Vendor card.

Dynamics GP EFT Payments

In the Vendor Email Options window, check that the Vendor Remittance box is checked under Send Forms as Email and confirm the format you would like. Click OK and then click Save.

Dynamics GP EFT Payments

Enter Payables Transaction

(Purchasing > Transactions > Transaction Entry)

Enter a transaction entry for the EFT Vendor you just set up. Put in your amount and the document number. Post that transaction.

Dynamics GP EFT Payments

Navigate to the Build Payment Batch/Select Checks window. Enter a new batch in the Batch ID field and tab off the field.

Dynamics GP EFT Payments

Click Add to create a new batch.

Dynamics GP EFT Payments

Select EFT for Payment Method in this window. Select the EFT Checkbook. Click Save.

Dynamics GP EFT Payments

Enter in the Vendor ID restriction and click Insert. Click Build Batch.

Dynamics GP EFT Payments

The dollar amount of open invoices for that vendor should populate in the Batch Total field. Click the Edit Payment Batch button.

Dynamics GP EFT Payments

Tab off the field to see all open vendors. Scroll down until you see the Vendor we just posted the invoice for. Check the box next to the Vendor ID.

Select the invoice you just posted. Click Process.

Dynamics GP EFT Payments

Once you’ve created the batch, you can post it as you normally would. You can only use Vendors that you have previously set up as EFT vendors.

In the Print Payments window, you will see some check fields greyed out since GP knows not to print a physical check. Verify the Check Date and GL Posting Date. Click Process.

Dynamics GP EFT Payments

The Process Payables Remittance window will open.

In this window, you can print or email remittances or do both. To email remittances to your vendors, select the Remittance Form option and click Process. If you do not have this set up in GP, then the remittances will print.

Dynamics GP EFT Payments

To post the EFT batch (whether or not you choose to email remittances), you must select the Post radial button and then click Process.

Dynamics GP EFT Payments

Generating the EFT ACH file

(Purchasing > Transactions > Generate EFT File)

Open the Generate EFT File window. Choose the checkbook you have set up for EFT and click Redisplay. Then select the batch you have posted. Click Generate EFT File.

Dynamics GP EFT Payments

Look for this window confirming that your EFT file has been generated in the path you specified earlier in your Checkbook EFT Payables Options window.

Dynamics GP EFT Payments

Now you can browse out to the location to see your electronic payment. And that’s it! Now you have fully set up your GP system for EFT payments and know how to pay your vendors!

Need help maximizing your Dynamics GP solution? We have a team of experts ready to help!

By |2019-04-10T10:06:10+00:00April 10th, 2019|Dynamics GP, ERP, Technology|0 Comments

About the Author:

Elaine Foley
Elaine Foley is an functional Dynamics GP consultant in the firm’s technology group. She joined Sikich in June of 2018 for her first job after college. Elaine is from the Chicago area and works in the St. Louis office, supporting clients with financial and technical assistance as well as demonstrating reporting tools for Great Plains.
This material has been prepared for general informational purposes only and is not intended to be relied upon as accounting, tax, or other professional advice. Please refer to your advisors for specific advice.

Privacy Information

We use cookies to personalize the website for you and to analyze the use of our website. Click 'Privacy Options' to configure how we can interact with you and your device or computer.

Privacy policy | Close
Settings
private equity services construction accountants Agriculture Services Construction Services Non-Profit Services Government Services