Netsuite electronic payment batch (additional field)


On this page, we explain how to enable reconciliation for the NetSuite Electronic payment batches


Introduction

In Netsuite, you have the option to install an additional Suite App Bundle named “Electronic Bank Payments” (id 339110). This bundle is also often named “EFT module” or “Batch payments”. The bundle allows the user to create payment batches or direct debit batches that can be imported directly into your online bank portal by hand or with the use of the Fast Four SFTP Connector. During the installation of the Bank Reconciliation, the system can’t create additional fields on records from other bundles and the Bank Reconciliation Suite App does need a parameter to check if a particular batch is reconciled.

Adding additional field

To create the additional field navigate to CUSTOMIZATION->LIST, RECORDS & FIELDS->RECORD TYPES. On this page search for the record named “Payment File Administration” and click on the name to open the record. The overview page does use in most cases several pages so potentially you must navigate to one of the following pages.

On the page that opens after clicking on the record name you will see a grey button labeled “New Field”. Press this button to start the process of adding the additional field.

On the payment file administration field page populate the following fields

  • Label: Bank Statement

  • Id: _bs_ep_bankstatement

  • Type: List/Record

  • List/Record: Bank Statement

When these values are populated you can save the new field by pressing the blue button “Save”.