This reference covers the settings for a NetSuite to Bank data flow in Vendor Payment Manager. Use these settings to specify which NetSuite folder contains the outgoing payment files, where on the bank's FTP or SFTP server those files should be sent, and how the files should be handled after a successful transfer. Configure these settings before running the flow for the first time.
NetSuite to Bank flows transfer accounts payable files from a NetSuite file cabinet folder to the bank's FTP or SFTP server. The flows support ACH or NACHA, .txt, .xml, and other plain-text file formats. Multiple files in the outbound folder are all transferred in a single flow run.
For instructions on running the flow after configuration, see Run and schedule data flows in Vendor Payment Manager.
File Transfer Parameters
| Field | Description |
|---|---|
| NetSuite Outbound Folder | The file cabinet location in NetSuite from which the app retrieves outgoing payment files. You can specify more than one folder. |
| Bank FTP Import Folder | The destination directory path on the bank's FTP or SFTP server where the files are sent. |
| File Name Starts With | Filters which files in the outbound folder are picked up. Only files whose names begin with this value are transferred. Leave blank to pick up all files. |
| File Name Ends With | Filters which files in the outbound folder are picked up. Only files whose names end with this value are transferred. Leave blank to pick up all files. |
Advanced options
| Field | Description |
|---|---|
| File Suffix to Append | A timestamp format appended to each transferred filename. Select a format from the dropdown to make filenames unique per transfer. |
| Encrypt file with PGP Key | When selected, the app encrypts each file using the bank's public key stored in the General section before sending it. See Configure PGP encryption for Vendor Payment Manager to set up the key. |
| Sign Encrypted files | When selected, the app signs the encrypted file so the bank can verify its integrity. Only available when Encrypt file with PGP Key is selected. |
| After Transfer Action | What happens to the file in the NetSuite outbound folder after a successful transfer. Options are described in After Transfer Action options. |
| NetSuite Archive Folder ID | The file cabinet location in NetSuite where the file is copied after a successful transfer, for logging and audit purposes. Required when After Transfer Action is set to Archive. |
After Transfer Action options
| Option | Behavior |
|---|---|
| Delete | The file is deleted from the NetSuite outbound folder after transfer. |
| Archive | The file is moved from the NetSuite outbound folder to the folder specified in NetSuite Archive Folder ID. |
| Mark as Processed | The file stays in the NetSuite outbound folder but is flagged as processed. On subsequent flow runs, flagged files are skipped. |
Every file that transfers successfully is also copied to a dedicated audit folder within NetSuite. Manage the contents of that folder manually from the NetSuite file cabinet. It does not clear automatically.
Notes
- After Transfer Action settings are not available for saved search flows. See Configure a NetSuite saved search file transfer.
- PGP encryption is not supported for saved search flows.
- If no files in the outbound folder match the File Name Starts With or File Name Ends With filters, the flow completes with no files transferred.
Troubleshoot PGP encryption errors
Error: Encryption failed because the provided PGP Public Key has expired. Ask the recipient for a current Public Key and update the PGP settings
Cause: The bank public key stored in the General section has expired.
Resolution: Ask your bank for a current public key. In the General section, select Encryption (Bank Public Key) in Enter PGP keys for, enter the new key in PGP Public Key, and save. Then run the flow again.