Versions Compared

Version Old Version 12 New Version Current
Changes made by

Chloe Cocheteux

Anita Stamenkovska (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This guide will show you step by step on 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.053
  • CAMT.054
  • PAIN002
  • CSV

Steps

  1. Go to Setup → Bank Reconciliation Setup → Bank Account Configuration.
  2. Edit the Bank Account Configuration you want to configure the retrieving of the DDR Codes retrievement for.
  3. Scroll down and go to Additional Parameters & Fields → Additional Fields sublist subtab.
  4. Click on New Bank Statement Additional FieldsFields button.
  5. The Bank Statement Additional fields page opens. 
    1. If using your bank statement file has a CAMT.053 or CAMT.054 file format:

      1. Populate the XML Path field with the following queryCopy the below query and paste it to the XML Path field:

        Code Block
        languagexml
        themeConfluence
        titleXPath 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. 
      6. Image RemovedImage Added
    2. If using your bank statement file has a CSV file format:
      1. Populate the CSV column field with the number of the column containing the CSV column numberDDR 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 RemovedImage Added


Note

If for any reason In case 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 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.