Versions Compared

Key

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

...

  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 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. 
    1. If your bank statement file has a CAMT.053 or CAMT.054 format:
      1. Copy 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 your bank statement file has a CSV format:
      1. Populate the CSV column field with the number of the 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 Modified



Note

In case there are 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.

...