Learn how to set up the configuration to retrieve the Direct Debit Reversal Code (DDR Code) 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.053
• CAMT.054
• PAIN002
• CSV

Steps

1. Go to Setup > ZoneReconcile 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 subtab.

4. Click on New Bank Statement Additional Fields button.

5. The Bank Statement Additional fields page opens.

• If your bank statement file has a CAMT.053 or CAMT.054 format:
  
  • Copy the below query and paste it to the XML Path field:

/*[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']

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

• If your bank statement file has a CSV format:
  
  • Populate the CSV column field with the number of the column containing the DDR code in your CSV file.
  • From the drop-down under Bank Statement Transaction Field, select Additional Fields.
  • From the drop-down under NetSuite Field, select DDR Code.
  • Select Body for the Body or Line level field.
  • Save the record.

In case there is more than one DDR Code field available under the drop-down of the NetSuite Field, make sure to select the field that populates the NetSuite Field ID with CUSTBODY_FF_DDR_CODE.

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.