There seems to a be a lot of questions around setting up Electronic Funds Transfer (EFT) for Payables Management. First, you will need to obtain the requirements from the bank and adhere to their requirements. Hopefully one of the standard formats provided in Microsoft Dynamics GP will be what you need, but if not, then you need to map it as a customized format in GP. We only support the standard formats available in GP so any additional questions may be considered a consulting engagement which is a billable service. Support wanted to document the most common questions we receive in a Q&A format for you below, so I hope this information will be helpful to you and eliminate the need for a billable consulting engagement.
Q1: When does a support case for EFT assistance become a consulting expense? How long can I keep an EFT support case open?
A1: Setting up the EFT file format would be considered a consulting expense. Each support incident should be scoped to address 1 field or error message per case. Each new question or error message that can be researched separately from the original scope defined in the case should be put on a new support case. So if the bank rejects the test EFT file and gives you a new error message to troubleshoot, we ask that you open a new support case for the new issue. These guidelines are published in the Ebanking configurator section of KB 850201:
850201 Guidelines that Microsoft support professionals use to determine when a support case becomes a consulting engagement for Report Writer, SmartList Builder, SQL scripts, Business Alerts, VB Script, Modifier/VBA and eBanking Configurator Files
Q2: Are you able to send 'invoice' information in the EFT file?
A2: Yes, this is called the 'Addenda' line. You will need to map out the Line Type for the 'Addenda' line on the EFT file format according to your bank's specifications.
Q3: Are you able to send multiple addenda lines in the EFT file?
A3: The functionality for addenda lines works differently in different versions of Dynamics GP, so the answer will depend on what version you are using. In GP 10.0, you are able to send only 0 or 1 addenda line per payment. GP 10.0 does not have functionality to include multiple addenda lines for one payment. In GP 2010 RTM, you are only able to send 0 or All addenda lines per payment. However in GP 2010 SP2, additional functionality was added so you can send 0, 1, or All addenda records for each payment by utilizing the newly added checkbox for "Detail Line Addenda" found on the EFT File Format Maintenance window. More information on this topic can be found in KB 2551488.
2551488 Multiple Addenda Lines in the EFT file in Microsoft Dynamics GP
Q4: Are you able to put multiple invoice numbers in one addenda line?
A4: No. Each addenda line would store the information for each invoice that makes up the payment. So for example, if you have 6 invoices that make up the payment, you would get 6 addenda lines if you chose to include al the addenda lines. There is no functionality to include all 6 invoice numbers on the same addenda line.
Q5: Are you able to configure any EFT file format to produce a "Check Printing File" format? ( Many banks are now offering this service to print checks and require an XML format where each addenda line would be in its own remittance format.)
A5: No. At this time, Microsoft Dynamics GP does not offer or support "Check Printing File" formats. The xml format where the information for each remittance is listed in its own grouping would need to be a customization. If you would like to request a customization for this, please open a support case to ask to be put in touch with MBS Professional Services and include a copy of your bank's requirements for the file format setup. We also encourage you to vote on this product suggestion in the MS Connect product suggestion database so this functionality can be reviewed for a future enhancement:
Q6: Does the EFT banking information flow through an upgrade?
A6: The banking information on the vendor and the checkbook are brought through the upgrade. The banking information on the vendor will be written to the SY06000 table and will use the vendor's main address found on the Vendor Maintenance card. The only information that is not brought through the upgrade is the EFT file format. You will need to re-set up the EFT file format in GP 10.0 or GP 2010, by either setting it up from scratch yourself, or picking from one of the standard formats already supplied in the pick-list. It may be helpful to make screenprints of the file format setup in GP 9.0 to refer to. GP 10 and GP 2010 have standard file formats available to choose from, as published by the National Automated Clearning House (NACHA). We code to these standard published formats, so if your bank requires any other format, or a customization to the standard format, we would consider that to be a consulting request.
Q7: What EFT file formats are supplied in GP 2010?
A7: GP 10.0 and GP 2010 offer ten standard EFT file formats that are published according to the standard requirements set by the…