Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Bank File with Double Quotes-Data Exchange Definitions

Posted on by 61
Can someone explain how to setup to import a bank statement with double quotes?
 
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 68,480 Super User 2024 Season 2 on at
    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 Profile Picture
    Valentin Castravet 21,699 Super User 2024 Season 2 on at
    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

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,112 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans