EFT for Payables in GP 2010

(0) Share

Report

Posted on by Larry Cummings

150

We are in the process of enabling EFT for payables. But there are no predefined formats in our system. Does anyone know where I can get these.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Larry, there are no pre-defined formats. You create them in Vendor Address Maintenance>>EFT Bank using the spec your bank provides.

Was this reply helpful? Yes No
Verified answer

soma 24,410 on at

Like (0)

Report

1. Go to Cards-->Finance-->EFT File Format.

2. Enter your own Format ID and Description.

3. Then choose the module and select predefined Format Types on your bank.

4. Click save.

5. Now open Checkbook EFT Payables or Receivable Options window(Cards-->Financial-->Checkbook and click EFT button and choose Bank then click Payables\Receivable Option button) to assign the EFT Format.

Note: You can create prenotes EFT files from this window.

6. Create EFT checks for EFT vendors.

7. Finally Generate EFT files.

Hope this helps!!!

Was this reply helpful? Yes No
sueconrod 337 on at

Like (0)

Report

Double check what the bank gave you as a format against the format you come up with. I have Wells Fargo and they had a couple things that I had to change on the NACHA file.

So, you want to Generate the EFT file and verify against what they gave you, you can always go in and make changes to the File format if you have to.

Sue

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Yeah - what Soma said - LOL. The computer that sits atop my shoulders had a glitch when I responded :)

Was this reply helpful? Yes No
steveendow 2,281 on at

Like (0)

Report

Hi Larry,

I would recommend avoiding the CCD+ / CTX file format due to a bug in GP. I've written a blog post about the issue, which exists in both GP 2010 and 2013:

dynamicsgpland.blogspot.com/.../problem-with-gp-2010-eft-payables-ccd.html

dynamicsgpland.blogspot.com/.../dynamics-gp-2013-appears-to-still-have.html

Just stick with the basic CCD format, and as Susan noted, make sure to carefully go through every field in the format spec provided by your bank. Even though banks say they use a "standard" NACHA format, each one seems to have at least one or two fields that are different from the default format provided by GP.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi! Do you know if this bug has been fixed in GP2015? THANKS!

Was this reply helpful? Yes No
steveendow 2,281 on at

Like (0)

Report

Hi Sally,

I'm told the bug does still exist in GP 2015 RTM and 2015 R2. Here is an update I received from someone who confirmed the issue in GP 2015 and was told it would be fixed in R3, or whatever they will call it.

I will believe it when I see it.

Microsoft responded back that it is tentatively set to be resolved with GP2015 R3. See Below.

“There is a known Quality Issue #69589, “Count lines only work in footer rows in PM EFT, but are available to pick for any Line type and don’t work” that currently makes the CTX EFT format unusable in GP.

The bad news is that there are currently no know workarounds apart from manually entering in the addenda count.

The good news is that this Quality issue is tentatively set to be resolved with the release of the third service pack for GP 2015.”

Was this reply helpful? Yes No