This reference covers the settings for a Bank to NetSuite data flow in Vendor Payment Manager. Use these settings to specify where on the bank's FTP or SFTP server the acknowledgment or payment summary files are located, where in NetSuite those files should be stored, and whether the files need to be decrypted after transfer. Configure these settings before running the flow for the first time.
Bank to NetSuite flows retrieve acknowledgment and payment summary files from the bank's FTP or SFTP server and store them in a NetSuite file cabinet folder. Only .txt files are supported.
For instructions on running the flow after configuration, see Run and schedule data flows in Vendor Payment Manager.
File Transfer Parameters
| Field | Description |
|---|---|
| FTP Outbound Folder | The directory path on the bank's FTP or SFTP server from which the acknowledgment or payment summary files are retrieved. |
| File Name Starts With | Filters which files are picked up from the bank server. Only files whose names begin with this value are transferred. Leave blank to pick up all .txt files in the folder. |
| File Name Ends With | Filters which files are picked up from the bank server. Only files whose names end with this value are transferred. Leave blank to pick up all .txt files in the folder. |
| After Transfer Action in FTP | What happens to the file on the bank's FTP or SFTP server after a successful transfer. See After Transfer Action in FTP options. |
| FTP Archive Folder | The directory on the bank's FTP or SFTP server where the file is moved after a successful transfer. Required when After Transfer Action in FTP is set to Archive. |
| Decrypt file with PGP Key after transfer | When selected, the app decrypts the incoming file using your private key stored in the General section. Select this only when the bank encrypts the files it sends. See Configure PGP encryption for Vendor Payment Manager to set up your private key. |
| NetSuite Import Folder ID | The file cabinet location in NetSuite where the transferred file is stored. |
After Transfer Action in FTP options
| Option | Behavior |
|---|---|
| Delete | The file is deleted from the bank's FTP or SFTP server after transfer. |
| Archive | The file is moved from its source folder on the bank server to the folder specified in FTP Archive Folder. |
| Mark as Processed | The file stays in its source folder on the bank server but is flagged as processed. On subsequent flow runs, flagged files are skipped. |
Notes
- Bank to NetSuite flows support
.txtfiles only. Other file formats are not transferred. - The Decrypt file with PGP Key after transfer option requires your private key to be stored in the General section. Decryption is not supported for files that are both encrypted and signed by the bank.
Troubleshoot PGP decryption errors
Error: The PGP signature could not be verified because the signature, or the signing key's own certification, uses an insecure hash algorithm (SHA-1, MD5 or RIPEMD-160). Ask the sender to sign files with SHA-256 or stronger
Cause: The bank signed the file with SHA-1, MD5, or RIPEMD-160, or the bank’s signing key is certified with one of them. Vendor Payment Manager doesn’t accept these hash algorithms.
Resolution: Ask your bank to sign files with SHA-256 or stronger, and then run the flow again.
Error: The PGP signature could not be verified because the sender's signing key or signature was expired, revoked or not yet valid when the file was signed. Ask the sender for a current Public Key
Cause: The bank’s signing key or the signature was expired, revoked, or not yet valid when the bank signed the file.
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.