This guide will show you step by step on how you how to set up the configuration to retrieve the Direct Debit Reversal Code (DDR Code) when dealing with from a bank statement file and copy it to the invoice for which the payment was reversed.

This configuration only applies to the import of the following types of bank statement files: 

• CAMT 53.053
• CAMT 54.054
• PAIN002
• CSV

Steps

1. Go to Setup → Bank Reconciliation Setup → Bank Account Configuration.
2. Click on the Edit the Bank Account Configuration you will use want to process configure the Statement containing retrieving of the DDR Codes for.
3. Scroll down and click on the go to Additional Parameters & Fields → Additional Fields subtab.
4. Click on the Additional Fields sublist.Click on New New Bank Statement Additional Fields button.Image Added
5. The Bank Statement Additional Fieldfields page opens.Image Removed 
   1. If using your bank statement file has a CAMT 53 .053 or CAMT 54 file .054 format: Populate the XML Path field with the following query:
      

      1. Copy the below query and paste it to the XML Path field:

         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

      Image Removed

      If using a CSV file format:

      1. ']

         
         

      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. 
      6. Image Added
   2. If your bank statement file has a CSV format:
      
      1. Populate the CSV column field with the number of the
      CSV column number.Image Removed
      1. column containing the DDR code in your 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. 
      6. Image Added

...

...

...

Optional Steps

This optional step will show how to display the DRR Code filed in the invoice form.

1. Go to Customization → Forms → Transaction Forms.
2. Edit the invoice form you want the DDR Code field to be displayed in.
3. Go to the Screen Fields subtab→ Main subtab.
4. Check the Show box for the DDR Code field and select the Field Group.
5. Save the record.