News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Bank File with Double ...

Business Central forum

Suggested answer

Bank File with Double Quotes-Data Exchange Definitions

(0) Share

Report

Report

Posted on by Thilari Hettiarachchi

61

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

Categories:

Financial Management

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 68,480 Super User 2024 Season 2 on at

Like (1)

Report

Bank File with Double Quotes-Data Exchange Definitions

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
Suggested answer

Valentin Castravet 21,699 Super User 2024 Season 2 on at

Like (1)

Report

Bank File with Double Quotes-Data Exchange Definitions

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,263 Super User 2024 Season 2

#2

Martin Dráb 228,112 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans