Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

EFT bank country/region conflict

Posted on by 1,540

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

  • Verified answer
    Accounting Department Profile Picture
    Accounting Department 1,540 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans