This guide will show you step by step how to configure the retrieving of the Direct Debit Reversal Code (DDR Code). 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 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:

         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 number 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.