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 Bank Account Configuration you will use to process the Statement containing the DDR Codes.
  3. Scroll down and click on the Additional Parameters & Fields subtab.
  4. Click on the Additional Fields sublist.
  5. Click on New Bank Statement Additional Field. 
    1. If using a CAMT.053 or CAMT.054 file format: 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']



    1. If using a CSV file format: Populate the CSV column field with the CSV column number.
  1. From the drop-down under Bank Statement Transaction Field, select Additional Fields.
  2. From the drop-down under NetSuite Field, select DDR Code.


    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.


  3. Select Body for the Body or Line level field.
  4. Save the record.

...