Setting Up Payment File Formats

The Electronic Bank Payments SuiteApp provides payment file formats for payments, receivables, and Positive Pay transactions.

Before you can use a file format, you need to set it up with the relevant bank details and other information that the system requires. For more information, refer to the Payment Formats topic for your country.

Be sure to create folders in the file cabinet where you can store the payment format files. For more information, see Creating Folders in the NetSuite File Cabinet.

You can also customize the payment formats that come with the SuiteApp.

Using Standard Payment File Formats

The Electronic Bank Payments SuiteApp provides payment file formats that you can use for payments, receivables, and Positive Pay transactions.

For a list of available standard payment formats, see Supported Payment Formats.

Before you can use a payment file format, you must set up the relevant bank details and other information that the system requires. For information about setting up bank records for your company, vendors, employees, customers, and partners, see the Payment Formats topic for your country.

Using Custom Payment Templates

You can use custom templates for bank payment formats that are not currently supported by the Electronic Bank Payments SuiteApp. You can either customize an existing payment file template or create a new custom template.

For more information, see Creating Custom Payment File Templates.

Payment File Template Changes in NetSuite Electronic Bank Payments 2019.1

Depending on the payment template, the Electronic Bank Payments SuiteApp uses the tax information on the entity record when processing payments and generating bank payment files. To ensure compatibility with the SuiteTax feature, the Electronic Bank Payments version 2019.1 includes an update to the Payment File Template that will source the default tax registration number of the entity record. The Bank File Template field is going to be deprecated soon, and in preparation for this change, a new SuiteTax Bank File Template is added to the payment file template form.

For more information about the SuiteTax feature, see Enabling the SuiteTax Feature.

Accounts with SuiteTax feature

Accounts with the SuiteTax feature provisioned will use the SuiteTax Bank File Template field by default when processing payments and generating bank files. If left blank, the value from the Bank File Template field will be used.

Accounts without SuiteTax feature

If you do not have SuiteTax feature provisioned in your account, the value from the Bank File Template will be used by default when processing payments and generating bank files.

In addition, the following payment templates that source tax information of the entity record have been updated to be compatible with SuiteTax and non SuiteTax accounts:

Payment templates that use bank payment formats not mentioned above do not source tax information, and therefore are automatically compatible with SuiteTax and non SuiteTax accounts. To view the list of supported payment formats, see Supported Payment Formats.

Payment File Template Changes in NetSuite Electronic Bank Payments 2019.2

The following standard SEPA Direct Debit (DD) Payment Templates are enhanced with a new sorting logic that helps improve performance when processing payment transactions.

• SEPA Direct Debit (ABN AMRO)

• SEPA Direct Debit (CBI)

• SEPA Direct Debit (Germany)

If you are using custom SEPA DD payment templates, you must update your templates after the upgrade to Electronic Bank Payments SuiteApp 2019.2. Otherwise, you will be restricted from creating new payment batches by using Invoice Payment Processing and Generate Customer Payment files.

The Bank File Template field on your custom SEPA DD template must be updated with the new sorting logic.

A new Use Advanced SEPA DD Sorting box is available on the payment template record to enable grouping of payment transactions for single payment run.

Payment File Template Changes in NetSuite Electronic Bank Payments 2020.2

The following mandatory fields are available in the DTAZV payment templates on the Company Bank Details page. The same fields are added to the Bank Details page as optional fields:

• Meldenummer

• State Number

• Zip Code

In the Electronic Bank Payments SuiteApp version 2020.2, all functions for setting up bank records on the Bank Details page now use SuiteScript 2.0. This change does not have any impact on existing processes. A role based restriction is introduced, in which a user cannot view or edit Entity Bank Details. This happens when the user does not have permission for the subsidiary attached to the entity record. Administrator must provide the access to the respective users for editing the bank details.

This update also removes old scripts and deploys new scripts. The scripts are listed in the following table:

As a part of SuiteScript 2.0 implementation, the custom fields are hidden and script fields are used. The internal IDs of these new script fields on the Bank Details page are added with custpage_eft prefix. For the existing workflow available in your accounts, you can create UE/CS scripts. These scripts can be deployed on the Entity Bank Details page.

The Electronic Bank Payments SuiteApp validates the customer entity record during the bank file creation. Hence, you must provide all the required fields for customer records, if you want to process invoice payments.

You can add custom help text for the Entity Reference field on custom templates. This field is similar to the Reference field on a Payment File Template when defining XML content. The custom help text is provided to help you in using these fields more efficiently.

Payment File Template Changes in NetSuite Electronic Bank Payments 2021.2

The company bank and entity details are processed using SuiteScript 2.0. To avoid changes to the existing behavior of the SuiteApp, any customizations you perform using SuiteScript 1.0 must be repeated using SuiteScript 2.0 as well. The following table has SuiteScript 1.0 and SuiteScript 2.0 details:

General Notices