This guide will show you step by step on how to retrieve configure the retrieving of the Direct Debit Reversal Code Reversal Code (DDR Code) when dealing with . This guide applies for the import of the following types of files only: 

• CAMT.053
• CAMT.054
• CSV

Steps

1. Go to Setup → Bank Reconciliation Setup → Bank Account Configuration.
2. Edit the Bank Account Configuration you want to configure the retrieving of the DDR Codes retrievement for.
3. Scroll down and go to Additional Parameters & Fields → Additional Fields sublist.
4. Click on New Bank Statement Additional Fields.
5. The Bank Statement Additional fields page opens. 
   1. If using a CAMT.053 or CAMT.054 file format:

      1. Populate the XML Path field with the following query:

         Code Block
         language xml theme Confluence title XPath for DDR Code
         /*[local-name()='Document']/*[local-name()='BkToCstmrStmt']/*[local-name()='Stmt']/*[local-name()='Ntry']/*[local-name() = 'NtryDtls']/*[local-name()='TxDtls']/*[local-name()='RtrInf']/*[local-name()='Rsn']/*[local-name()='Cd']

         
         

      2. From the drop-down under Bank Statement Transaction Field, select Additional Fields.
      3. From the drop-down under NetSuite Field, select DDR Code.
      4. Select Body for the Body or Line level field.
      5. Save the record.

...

1. 1. If using a CSV file format:
      
      1. Populate the CSV column field with the CSV column numbernumber of the column containing the DDR code in the CSV file.
      2. From the drop-down under Bank Statement Transaction Field, select Additional Fields.
      3. From the drop-down under NetSuite Field, select DDR Code.
      4. Select Body for the Body or Line level field. 
      5. Save the record.