Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / EFT (Canada) - Bank Br...
Business Central forum

EFT (Canada) - Bank Branch # and Transit # not showing in output EFT file

(0) ShareShare
ReportReport
Posted on by Terry Schmidt 52

We are on one of the latest builds (25251) of Business Central.  I have been working on testing out the EFT configuration for Canada, using the CA EFT DEFAULT data exchange definition.  The generated EFT file is nearly perfect, except the "Bank No." and "Transit No." fields in the definition are not pulling from the Vendor's bank account and are just padded zeros.  My understanding is that the "Bank No." pulls from the Vendor Bank Account's "Bank Branch No." field and the "Transit No." pulls from the Vendor Bank Account's "Bank Transit No." field.  Note that the "Recipient Bank No." definition field is correctly pulling from the Vendor Bank Account's "Bank Account No." field.  Is there a way to adjust/configure what definition fields pull from what entity fields?

DED-Example.png

Categories:
Financial Management
  • Terry Schmidt Profile Picture
    Terry Schmidt 52 on at
    RE: EFT (Canada) - Bank Branch # and Transit # not showing in output EFT file

    PJK, I have contacted you on LinkedIn to share some documents that outline configuration and usage.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: EFT (Canada) - Bank Branch # and Transit # not showing in output EFT file

    Thanks for sharing!

    Do you know where I can find instructions on how to setup EFT in Canada? When I attempt to Generate EFT Files, I am getting no lines populated (see image). Trying to figure out what steps I missed. The only documentation I can find is regarding SEPA or using extensions or local specific information for other countries such as Australia, Spain, Belgium, but nothing for Canada.

    I appreciate any insight you can offer.

    Thank you,

    PJK

    Generate-EFT-Files-Screenshot.png

  • Verified answer
    Terry Schmidt Profile Picture
    Terry Schmidt 52 on at
    RE: EFT (Canada) - Bank Branch # and Transit # not showing in output EFT file

    For those of you running into this problem, it turns out that the Vendor Bank Account needs to have the Country / Region Code set to CA, in order for the bank # and transit # to populate in the EFT file.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans