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. Click on the Edit the Bank Account Configuration you will use to process the Statement containing want to configure the DDR Codes retrievement for.
  3. Scroll down and click on the go to Additional Parameters & Fields → Additional Fields subtab sublist.
  4. Click on the New Bank Statement Additional Fields sublist.Image Added
  5. Click on New The Bank Statement Additional Fieldfields page opens.Image Removed 
    1. If using a CAMT.053 or CAMT.054 file format:
      1. Populate the XML Path field with the following query:

        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']
  6. Image Removed

      1. From the drop-down under Bank Statement Transaction Field, select Additional Fields.
      2. From the drop-down under NetSuite Field, select DDR Code.
      3. Select Body for the Body or Line level field.
      4. Save the record.
      5. Image Added
    1. If using a CSV file format:
      1. Populate the CSV column field with the CSV column number
  7. .Image Removed
      1. From the drop-down under Bank Statement Transaction Field, select Additional Fields.
      2. From the drop-down under NetSuite Field, select DDR Code.
      3. Select Body for the Body or Line level field. 
      4. Save the record.
      5. Image Added
Note

If for any reason 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 CUSTBODY_FF_DDR_CODE

...