Finance | Project Operations, Human Resources, ...

D365 F&O connectivity to bank

(6) Share

Report

Posted on by CU21021423-0

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 (3)

Answers (0)

Sort by

Vahid Ghafarpour 12,266 on at

Like
a
(2)

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 14 on at

Like
a
(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
Suggested answer

Alireza Eshaghzadeh 15,225 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @CU21021423-0

One practical standard Microsoft-platform approach is to use SharePoint as the file staging location.

For outbound payment files:
D365 Finance can generate the pain.001 file using Electronic reporting, and the ER destination can save the file to SharePoint. Then Power Automate or Azure Logic Apps can transfer the file from SharePoint to the bank SFTP.

For inbound files:
Power Automate or Azure Logic Apps can fetch files from the bank SFTP and place them in SharePoint. From there, D365 Finance can import supported files such as pain.002 payment status reports, camt.054 settlement, and camt.053 bank statements, depending on the payment method and Advanced bank reconciliation setup.

So SharePoint + Power Automate / Logic Apps can be used as a standard Microsoft platform-based solution for both export and import scenarios.

If the business requirement is to send and receive files directly between D365 Finance and the bank SFTP without using SharePoint or middleware, then a customization or ISV banking connector should be evaluated.

Was this reply helpful? Yes No