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. Click on the Bank Account Configuration you will use to process the Statement containing the DDR Codes.
3. Scroll down and click on the Additional Parameters & Fields subtab.
4. Click on the Additional Fields sublist.
5. Click on New Bank Statement Additional Field. 
   1. If using a CAMT.053 or CAMT.054 file format: 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']

1. 1. 

   2. If using a CSV file format: 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.

   If for any reason there are more than one DDR Code field available, you'll have to select them and see what the field next to it gets populated with. The right one has the field ID CUSTBODY_FF_DDR_CODE

4. Select Body for the Body or Line level field.
5. Save the record.