Small and medium business | Business Central, N...

EFT IAT export format, use for BAI2 pulls?

(3) Share

Report

Posted on by CU13010319-0

458

what is the difference between the payment export and EFT IAT payment export formats on the bank account? When does the EFT IAT payment export format get used, what does the EFT IAT Payment export format do?

I have a BAI2 file from JP Morgan, "pull" format, involving File header, group header, account identifier, transaction detail, continuation, account trailer, group trailer, and file trailer. In the file it mentions customer account number, customer reference. So it seems like money is being pulled from the customer bank accounts, instead of paying money via payment journal to vendors. But in this case, my bank account has already defined a payment export format, so I don't want to remove that for paying vendors. My idea is to use the EFT IAT payment export format field and setup another data exchange definition, this time for customers, to be able to pull funds. Then define a customer bank account, enable for electronic transfers, and use the payment journal to use EFT IAT format to generate the file to JP morgan to pull funds. Is this acceptable?

Categories:

Dynamics 365 Business Central

BAI2 format guide...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (1)

Report

Hi, You can try the following feature first

https://learn.microsoft.com/en-us/dynamics365/business-central/finance-make-payments-with-bank-data-conversion-service-or-sepa-credit-transfer?wt.mc_id=DX-MVP-5004336

Dynamics 365 Business Central 2021 release wave 1 (BC18): Simplified bank statement file import (Bank Statement File Format Wizard)
https://yzhums.com/11072/

Dynamics 365 Business Central: Add more custom processing when importing Bank Statement (Bank Export/Import Setup) – Customization

https://yzhums.com/44582/

If it does not meet your needs, you can consider customizing and building an API with the bank.

Thanks

ZHU

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,631 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

In Business Central, the Payment Export format is used for standard EFT payments to vendors, while the EFT IAT format is for international transactions, including additional compliance information. You can set up a new data exchange definition for EFT IAT to pull funds from customer accounts without altering your existing vendor payment setup. This involves defining customer bank accounts for electronic transfers and using the payment journal to generate the necessary file for JP Morgan to pull funds. This approach allows you to manage both vendor payments and customer fund pulls efficiently.

https://community.dynamics.com/blogs/post/?postid=4e4209a1-ad2b-4459-a65b-1fd987143274

https://learn.microsoft.com/en-us/dynamics365/business-central/finance-make-payments-with-bank-data-conversion-service-or-sepa-credit-transfer

Was this reply helpful? Yes No

Join the conversation

Community site session details

EFT IAT export format, use for BAI2 pulls?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

EFT IAT export format, use for BAI2 pulls?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates