web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... D365 F&O connectivity ...

Finance | Project Operations, Human Resources, ...

Unanswered

D365 F&O connectivity to bank

(4) Share

Report

Report

Posted on by CU21021423-0

10

Hi All,

My client is requesting an SFTP connectivity between the bank and D365 F&O for payment file generation and import of statements and payment status reports.

D365 will generate pain 001 xml file and send it to the bank's SFTP. The bank will then return payment status reports in pain 002 format and statements in CAMT 053 format which then need to be imported in D365 for reconciliation.

Could you please advise if this is possible through the D365 built-in functionality?

Thanks

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Vahid Ghafarpour 12,242 on at

Like (1)

Report
Copy link

Link copied!

You can use the Electronic Reporting (ER) framework in D365 F&O to generate electronic payment files in the pain.001 format. You need to configure the payment method and set up the ER format configuration

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/tasks/er-electronic-payments

You can set up periodic data export from D365 F&O to an SFTP server. This involves configuring the SFTP connection and setting up outbound message types for data export

https://denistrunin.com/integration-outboundsftp/

For importing payment status reports and bank statements, you can use the Advanced Bank Reconciliation feature in D365 F&O. This feature allows you to import electronic bank statements and reconcile them with bank transactions. You can set up the import functionality for the pain.002 and CAMT.053 formats using the Electronic Reporting (ER) framework

https://learn.microsoft.com/en-us/dynamics365/finance/accounts-payable/import-BAI2-ER

https://learn.microsoft.com/en-us/dynamics365/finance/cash-bank-management/reconcile-bank-statements-advanced-bank-reconciliation

Was this reply helpful? Yes No
CU21021423-0 10 on at

Like (0)

Report
Copy link

Link copied!

Thank you, VaHiX.

Could you please advise if it is possible for the payment files to be exported without any additional development to a specific azure blob storage container and then sent to the bank's SFTP?

Regarding the payment status reports and the bank statements, we would like to avoid manual upload and all files placed in the bank's SFTP to be fetched automatically to the azure blob storage and then automatically imported (no manual upload) to D365 for ABR. Is this possible without any additional development?

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Giorgio Bonacorsi 627

#2

André Arnaud de Cal... 615 Super User 2026 Season 1

#3

CP04-islander 301

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans