Customizing CPA-005 Payment Files in NetSuite’s Electronic Bank Payments SuiteApp

The Electronic Bank Payments SuiteApp supports the CPA-005 format for Canadian banks. When specific bank requirements necessitate modifications, the following steps outline the process for customizing the payment file template:

1. Navigate to Payments > Setup > Payment File Templates.

2. Locate and open the "CPA-005" payment file format.

3. From the "More Actions" menu, select "Make Copy" twice. This creates a backup of the original template and a working copy for modifications. It is crucial to work on a copy, as default files within a managed bundle can be overwritten during updates.

4. Modify the working copy of the "CPA-005" file. Customizations to payment file templates are performed using FreeMarker syntax. Detailed instructions for FreeMarker template customization are available in NetSuite's official documentation.

5. Save the changes to the working copy. Ensure that any necessary modifications are also applied to the backup copy if it is intended to reflect the customized version.

6. To test the customized payment file generation:a. Go to Payments > Payment Processing > Payment File Administration.b. Open the most recent Payment File Administration record configured to use the relevant Bank Detail and the customized CPA-005 template.c. Click the "Recreate File" button at the top of the page. This action may redirect to a status page.d. Once the file recreation is complete, return to the Payment File Administration record and open the same record again.e. Next to the "File Reference" field, download or edit the generated file to validate the applied changes.