web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

EFT bank country/region conflict

(1) ShareShare
ReportReport
Posted on by 1,552

I have entered the set up for EFT for payment from our US$ account at a Canadian bank (RBC).

We have vendors in Canada and in the US who we pay in US funds.

If I enter my chequebook country/region as Canada then both Vendors need to be set up with a bank country/region as United States.

The file that is created looks fine for the US Vendor but for the Canadian Vendor it is missing the bank and transit number.

This is in the IAT Entry Detail Record positions 04-12.  For the US Vendor it is pulling from the Vendor EFT Bank Mntc Transit Routing Number field.  For the Canadian Vendor, this field does not accept the bank and transit number, so I entered itin the "Bank Branch" field. I also tried using the Bank Code and Bank Branch Code fields.

Does EFT not allow paying a Canadian bank in US funds from another Canadian bank in US funds using the same file as a Canadian bank paying a US bank in US funds?

 

 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Accounting Department Profile Picture
    1,552 on at
    Re: EFT bank country/region conflict

    I just answered my own question.

    I will use the EFT Bank Branch field for both Cdn and US Vendors for the Transit Routing info.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans