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

...