In this post we’ll cover how to Set Up EFT’s for Payables and Receivables, in the next post, found HERE we’ll take a look at how to use them and the best practices around that!
You can set up and use Electronic Payments in Dynamics GP by setting up and using the EFT functionality that’s already part of your GP install!
EFT stands for Electronic Funds Transfer and it is meant to streamline the process of sending electronic payments to your vendors and receipts from your customers through whichever bank you currently use.
The process of creating and choosing payments in Payables Management is only a little different than cutting standard checks and the process of receiving funds from Customers is also only slightly different as well.
The absolute first step is to talk to your banking contact. Most business accounts must be activated in order to use electronic funds payments which means planning and working out the security for sending and/or receiving electronic funds on your account is the very first step.
The second step is to obtain the file format that your bank uses for electronic funds transfers so that you can set GP up to mimic that format to then successfully send or receive the payments. Most banks will send an informational packet with the format to you which can then be utilized to customize the format output from GP.
The format window contains two areas, the header area that contains setup and text information and the Field Detail area where once you have selected the Line Type to use (discussed later) you can tell GP very specifically what each of the digits or groups of digits represent in your file.
EFT Format ID:
First assign a unique ID for the EFT Format ID. In the format it would be a good idea for you to indicate if this format is for Purchasing or Sales and perhaps even more indicators in the event you may need several EFT Format ID’s.
Be even more specific in the Description if you’d like
Next, we’ll setup the Format Type. As you can tell from the screenshot below there are a good number of pre-formatted US File Types (there are also pre-formatted Canadian Types) that are setup for you right out of the box. Most banks will use one of the formats which means you will, possibly, only need to tweak it a bit to get it setup!
If your bank does not happen to use one of these pre-formatted types, you do have the option of using the “User-Defined” file format!
The format for IAT NACHA is specifically for use when paying international payments.
This will auto fill if you selected one of the pre-set Format Types. However, the choices are either a Flat file or an XML file.
If you select one of the pre-formatted types, many of the rest of the options will auto-fill for you except for Format Class – here you may choose whether it is a “Not Specified” or one of the following options:
Max Line Length:
The established maximum number of characters allowed per line of data in the file
Ah, now it gets interesting. Each file contains sections in it. The sections needed will be dependent upon your banks requirements.
As you use the drop down and select sections you can note that the bottom section of the window, the Field Detail area, changes to allow for the different data types that will be in the section.
Your section choices are:
Again, you do not need to fill each of these out – only the ones required by your bank! For instance, the US-NACHA-PPD only uses these sections:
Add Pad Blocks:
You can select this in the event you are setting up a User-Defined Format Type. Tell GP what the Pad Character is, the Number of Pad Characters and the multiple of pad lines in your file.
When setting up a User Defined Format Type, select what the field delimiter is in your file
You may also select the text qualifier which identifies text in the field by single or double quotes. The text qualifier is not required but if you select an option other than none, you can further let GP know which lines use the text qualifier using the scrolling window.
Generate Auto-Settlement for each Detail:
Select if you need GP to automatically generate settlements for each detail
Detail Line Addenda:
Select if you need detail line addenda
In this section of the setup window you will let GP know what every character of the number of characters entered in the Header Field “Max Line Length” means.
In the header area of the EFT setup window, in Line Type, use the drop down to select which of the lines of detail you require to setup and then let GP know what each of the fields and number of characters represent.
A unique numeric representation of the number of fields in this Line Type Row.
How many digits does this particular field in this row contain?
The starting character number to the ending character number which should total the Length of the characters in this field.
A description of what this particular group of digits represents
Here you tell GP more information of what this group of digits in this line represents. Use the expansion arrows to the right of the column names to open up the setup choices for the fields. Your choices are:
Once you have setup each Line Type that your bank requires you are ready to go to the next step: Keep in Mind that most banks in the US use the US-NACHA or US-NACHA-PPD + formats, so you may not have to adjust the lines that much or at all.
*Remember that if you will be using EFT for both Payables and Receivables that you will need to set up a Format ID for each of those.*
Now you’ll need to “teach” GP which bank account to use and how and where to send the files for the EFT Payments
Go to Financial>Cards>Checkbook and select the checkbook you want to use, then click on EFT
Next, Click on Payables Options or Receivables Options, they are similar, but require separate setups to use both. If you only intend to use one of them, the other is not required!
Here is where you teach Dynamics GP how you want the EFT to work and where you would like the output files saved.
Your options are:
The only difference in this setup from the Payables Options are that you cannot choose whether to use the Next Check Number from the Checkbook setup. Otherwise, see the above section for setup information
Not quite yet….
There is also setup at the Vendor and Customer level to complete.
*Keep in mind while reading this that these setups can be done with a Mail Merge Macro, which takes the pain out of changing each one individually – you can find information on using Mail Merge Macros by David Musgrave Here*
For both Customers and Vendors, the EFT Setup is controlled at the Address Level.
This is great as it opens up the flexibility to pay the vendor via EFT by selecting the address with the EFT information on transactions or not selecting it. Those transactions with the EFT address will be paid ONLY by EFT and those transactions that do NOT have the EFT address code will be paid as usual!
Once you have decided which Address ID to use for the EFTs, you’ll want to consider using that Address ID in the Remit To field on the Vendor Card.
To begin the setup, click on EFT Bank in the lower right-hand corner!
You will now see an image much like the Bank Setup for EFT
VENDOR AND CUSTOMER SETUP IS ALMOST IDENTICAL: with the exception that on vendor setup you may utilize the field for “Building Society Roll No”
Now you are setup and ready to use EFT to Pay Vendors or Get Receipts from Customers!
The Next Post on How to Use EFT’s in Dynamics GP Can Be Found Here!