This guide will show you step by step on how to retrieve the Direct Debit Reversal Code (DDR Code) when dealing with the following types of files: 

• 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 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:

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