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

61

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

Categories:

Dynamics 365 Business Central

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 75,673 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 25,025 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... 291,661 Super User 2024 Season 2

#2

Martin Dráb 230,379 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans