EFT processing

(0) Share

Report

Posted on by Community Member

just recently upgraded to GP 2015. trying to set up vendors to process EFT directly to bank. after selecting invoice to process payment, we get this message when EFT was selected instead of Check book. Vendor card appears to have the country listed. what are we missing? Also not sure what is meant by "Activate the format"

The Bank country/region assigned to the vendor's remit-to address is missing or inactive. Assign the bank country/region to the address or activate the format.
Thank you!

*This post is locked for comments

All responses (6)

Answers (2)

quattr0 185 on at

Like (0)

Report

RE: EFT processing

Would like to add another possible issue is when the invoice was posted without the remit to address (meaning remit to for EFT was added after the fact), you might run into this error as well.
Verified answer

Community Member on at

Like (0)

Report

RE: EFT processing

thank you this was very helpful!
Community Member on at

Like (0)

Report

RE: EFT processing

thank you! this was very helpful
Community Member on at

Like (0)

Report

RE: EFT processing

Thanks for this. It answered my question too. It applies to GP 2010 as well. Just setting up EFT and could see the Vendor record bank data in the table (SY06000) after a 'save' but it would not redisplay until I plugged in the country code for the vendor as you described.
Suggested answer

Justin Sutton on at

Like (1)

Report

RE: EFT processing

Hello Sabprice,

Lyn is completely correct!

Just to add a bit more to what she stated, the Address ID used is the one in the Remit To slot. You can get to this Address ID a bit quicker by simply clicking Remit To on the Vendor Maintenance window.

Please let me know if you have any additional questions on this.

Justin Sutton

------------------------------------------------------------------------------------

Microsoft Dynamics GP Support

------------------------------------------------------------------------------------

**This posting is provided 'AS IS' with no warranties and confers no rights.**
Verified answer

Lyn Barr on at

Like (2)

Report
RE: EFT processing

Certain fields between the checkbook and vendor (or customer) must match in order for the EFT file or EFT prenote file to generate. These fields include the Currency ID (if you have multicurrency installed), Country Code, and Bank Country/Region. These fields are not required, but if they are filled in on either side, the other side must match. To verify, use one the following steps:

Go to Cards >> Financial >> Checkbook.

In the Checkbook Maintenance window, select the appropriate checkbook ID (TD BANK).

Verify whether a Currency ID is filled in or not on the Checkbook Maintenance window. Take note of the Currency ID field.

Click EFT Bank.

In the Checkbook EFT Bank Maintenance window, take note of what the Bank Country/Region field is set to, and whether a Country Code is filled in.

Click OK to close the window, and then click Save.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Now verify that those fields have the same values on the Vendor.

Go to Cards >> Purchasing >> Vendor.

In the Vendor Maintenance window, select the appropriate Vendor ID.

Click the Address button and select the appropriate Address ID used for EFT.

Verify the value in the Country Code field matches what you found on the checkbook above. (This is not a required field, so it must either match or be blank on both sides.)

Click EFT Bank.

In the Vendor EFT Bank Maintenance window, verify what value is in the Bank Country/Region field and the Currency ID field to make sure these values match what you found on the checkbook. Change any values as needed.

Click OK to close the Vendor EFT Bank Maintenance window. Click Save to close the Vendor Address Maintenance window.

In the Vendor Maintenance window, click the Options button.

Verify the value in the Currency ID field, and the Checkbook ID field.

Click OK to close the window. Click Save to close the Vendor Maintenance window.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Now test the EFT file again.