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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Generate EFT Files

(3) ShareShare
ReportReport
Posted on by 210

Hello. I'm attempting to generate EFT files from Business Central so that I can import them into the Bank of America CashPro system for payment processing. However, I'm encountering an error during the process. Could you please assist me with troubleshooting this issue?

EFT Error in BC.png
  • Suggested answer
    YUN ZHU Profile Picture
    103,164 Super User 2026 Season 2 on at

    Hi, hope the following can give you some hints.

    https://yzhums.com/8319/

     

    Thanks.

    ZHU

  • Teagen Boll Profile Picture
    3,898 Super User 2026 Season 2 on at

    On your bank account card check the Country Export Format field and make sure it's set as US.

     

    Then in your data exchange definition format make sure you are using the ACH tables. In your field mapping for your data exchange definition, you need to use ACH tables (Table 10301, 10302 and 10303).

     

    Best,

    Teagen Boll, CPA
  • Suggested answer
    Assisted by AI
    OussamaSabbouh Profile Picture
    19,477 Super User 2026 Season 2 on at

    Hello Imari,

    This error indicates a Bank Account setup mismatch, not a Bank of America/CashPro connection problem: on the Bank Account Card → Transfer FastTab, the selected EFT Export Code is not compatible with the selected Payment Export Format. Recheck/reselect these two fields together using their lookups and make sure the export format is an EFT/ACH format supported by your localization; also verify Transit No. and Last Remittance Advice No., that the bank account is in local currency, and that the Payment Journal line has Bank Payment Type = Electronic Payment (or Electronic Payment–IAT for international ACH). Microsoft confirms that North American EFT requires specific Bank Account/Vendor Bank Account setup depending on the chosen export format. Once BC can generate the file, confirm that its ACH/NACHA format matches what Bank of America CashPro expects; if CashPro requires a bank-specific format that standard BC does not provide, use a Data Exchange Definition / AMC Banking 365 or customization. 

    Regards,
    Oussama Sabbouh

  • Imari Profile Picture
    210 on at

    Thank you for your responses. 
    @YUN ZHU , do you have a video that shows how to fix the attached error? 
    @Teagen Boll I don't have those ACH tables. 
    @OussamaSabbouh , Based on your message, I can confirm that my set up is the same. I would like to add that when I accessed the Data Exchange definition, I only have the following. 

    Data Exchange Definition set up.png
  • Suggested answer
    Teagen Boll Profile Picture
    3,898 Super User 2026 Season 2 on at

    Hi @Imari, you don't have any line or column definitions defined so there is nothing to setup. The data exchange definition setup can be quite complex so its recommended to work with a partner on this. Here is what a typical setup looks like:

    You then need to map those line definitions to a table:

     

    You don't seem to have any mapping so you will need to have that configured.

     

    Best,

    Teagen Boll, CPA

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 710 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 387 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 385 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans