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.
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:
-
If you have the SuiteTax feature enabled:
-
We recommend entering your custom template body in the SuiteTax Bank File Template field.
-
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.
-
-
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.
-
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.
-
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:
|
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
- Czechia 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