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.

Note:

Entering your custom template in both Bank File Template and SuiteTax Bank File Template fields does not affect the bank payment file generation.

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 Template

SuiteTax Accounts

Non SuiteTax Accounts

AEB – Norma 34 (EFT)

Yes

Yes

CBI Collections (DD)

Yes

Yes

CBI Payments (EFT)

Yes

Yes

CIRI-FBF (EFT)

Yes

Yes

CNAB 240 (EFT)

Yes

Yes

SEPA Credit Transfer (CBI) (EFT)

Yes

Yes

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.

Recommendations and Considerations when using the SuiteTax Bank File Template field:

  1. If you have the SuiteTax feature enabled:

    1. We recommend entering your custom template body in the SuiteTax Bank File Template field.

    2. For OneWorld accounts with subsidiaries that have more than one tax registration number, only the first Tax Reg. Number under the Tax Registrations subtab of the subsidiary record will be sourced.

  2. If you do not have the SuiteTax feature enabled, we recommend adding your custom template in both Bank File Template and SuiteTax Bank File Template fields. This way, you do not need to reenter your template once the Bank File Template field is deprecated.

  3. Custom body template in SuiteTax Bank File Template field must also use FreeMarker syntax. For more information, see Working with Advanced Templates.

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.

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:

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:

New Scripts

Old Scripts

Entity Bank Details CS - customscript_10782_entity_bank_ue

Generic Entity Bank Detail Initializer - customscript_2663_entity_bank_details_ue

Entity Bank Details UE - customscript_10782_entity_bank_cs

Generic Entity Bank Detail Validator - customscript_2663_entity_bank_details_cs

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:

SuiteScript 1.0 (Old Scripts)

SuiteScript 2.0 (New Scripts)

customscript_2663_entity_ue

customscript_14552_entity_ue

customscript_2663_entity_details_cs

customscript_14552_entity_details_cs

customscript_2663_bank_details_cs

customscript_14552_bank_details_cs

customscript_2663_field_validator_cs

customscript_14552_field_validator_cs

Related Topics

Creating Custom Payment File Templates
Using Standard Payment File Formats
Adding Field Validations to Custom Payment File Templates
Austria Payment Formats
Australia Payment Formats
Belgium Payment Formats
Brazil Payment Formats
Canada Payment Formats
Czech Republic Payment Formats
France Payment Formats
Germany Payment Formats
Hong Kong Payment Formats
Hungary Payment Formats
Ireland Payment Formats
Isle of Man Payment Formats
Italy Payment Formats
Japan Payment Formats
Luxembourg Payment Formats
Netherlands Payment Formats
New Zealand Payment Formats
Singapore Payment Formats
South Africa Payment Formats
Spain Payment Formats
Sweden Payment Formats
UK Payment Formats
U.S. Payment Formats

General Notices