This notice is intended for customers who are using the NetSuite Electronic Bank Payments (EBP) SuiteApp. The change identified in this notice will affect OneWorld accounts that use multiple subsidiaries.
What is Changing?
The Electronic Bank Payments version 2021.1 will enable the assignment of a subsidiary to the entity bank details for multi-subsidiary customer and vendor records. A new dropdown field, Subsidiary, will be available in the Bank Details page.
Electronic Bank Payments SuiteApp version 2021.1 lets you perform the following tasks:
- Use the Subsidiary field to assign a subsidiary to a bank. For accounts with multiple subsidiaries, this will enable you to assign one subsidiary to each entity bank.
- Create multiple bank records per entity based on the account’s base country of operation.
- Process transactions belonging to a different subsidiary.
- Note: You can do this only if the transaction’s company and entity bank templates match the subsidiary, and the entity bank is set to primary.
- Process transactions related to all the subsidiaries that match the criteria if the subsidiary field of the entity bank is blank. If the Subsidiary field is not blank, then transactions related only to that subsidiary will be processed in the Suitelets.
All Search filters in the Electronic Bank Payments Suitelets will be modified to retrieve the transactions based on subsidiary, template, and primary bank combination. This change will affect the following pages:
- Bill Payment Processing
- Invoice Payment Processing
- Instant Bank File
- Customer Refund Processing
- Auto-Batch Processing
- EP-API Custom Suitelet
There is no impact on saved searches used for Instant Bank File and Batch processing Suitelets.
Important Information
During the SuiteApp update, a Map Reduce (MR) script labeled Global Entity Migration Script MR will automatically run. This MR script updates the File Format field on your existing Bank Details page. You can view the script status by going to Customizations > Scripting > Map/Reduce Script Status.
When the MR script is triggered:
- EFT (Electronic Funds Transfer), DD (Direct Debits) and CR (Customer Refunds) file formats along with subsidiary attached to entity bank will be updated in the custom fields for the respective templates of each entity.
- The MR Script will run independently of the SuiteApp update. For example, when the SuiteApp update is completed, the MR script will still be running in the background until all the records are updated.
- In OneWorld accounts, file formats along with subsidiary attached to entity bank will be updated in the custom fields for the respective templates of each entity. These Values will be used to retrieve the transactions in the Suitelets.
Recommended Actions
- If you have any customizations on the Bank Details page, you should revisit them based on the new Subsidiary field.
- If you are using any web services to create an entity bank, you must add the Subsidiary field in the web service request, if you want to populate subsidiary field.
- Refer to the following sample syntax for populating the Subsidiary field when creating bank details using a script.
- rec.setFieldValues('custrecord_9572_subsidiary', [1]); //Subsidiary Internal Id
- After bundle upgrade, you must check the status of the MR Script before submitting any Payment File or Batch for Processing. If the script status has an error, then you must trigger the script manually. Once you trigger the scripts and status is completed, then the Payment Files or Batches for Processing can be processed.
To trigger the MR script manually:
- Go to Customizations > Scripting > Script Deployment.
- Click Edit beside the Script ID customdeploy_9572_migration_script_mr.
- On the Script Deployment page, click Save and Execute to run the MR.
- Click OK.
To check the successful execution and completion of MR:
- Go to Customizations > Scripting > Map/Reduce Script Status.
- Click Details on the Details column for the Global Entity Migration Script MR.
Check if status of all the stages of MR are complete.
For More Information
Additional information about this enhancement will be available in the Help Center and SuiteAnswers by February 19, 2021.
If you have more questions, please contact NetSuite Customer Support.