Skip to main content

Retrieve the Direct Debit Reversal Code (DDR Code)

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.

zonereconcile_ddr_code_additional_field.JPG

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.

zonereconcile_ddr_code_additional_field_settings.JPG

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

zonereconcile_ddr_code_additional_field_settings_csv.JPG

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.
Was this article helpful?