web

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

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Bank File with Double ...

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

Suggested Answer

Bank File with Double Quotes-Data Exchange Definitions

(0) Share

Report

Report

Posted on by Thilari Hettiarachchi

83

Can someone explain how to setup to import a bank statement with double quotes?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Valentin Castravet 31,481 Super User 2025 Season 2 on at

Like (1)

Report

In your data exchange definition you can use a Transformation Rule with the Transformation Type Replace. This will simply replace the quotation marks to nothing to remove them. For example:

Valentin Castravet
Zander ERP Services

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

Hi, just add some information, if you also need some special handling, this may need to be customized. Please follow the event and table below.

[EventSubscriber(ObjectType::Codeunit, Codeunit::"Process Bank Acc. Rec Lines", OnAfterImportBankStatement, '', false, false)]

BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line";

DataExchField: Record "Data Exch. Field";

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 2,664

#2

YUN ZHU 960 Super User 2025 Season 2

#3

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans