...

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 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
         language xml theme Confluence title XPath 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. 
   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. 

...

Optional Steps

This optional step will show how to display the DRR Code filed in the invoice form.

...