Vendor Payment Manager can generate a CSV file from a NetSuite saved search and send it to your bank's FTP or SFTP server. This is useful when you need to create a custom payment file based on a NetSuite query rather than transferring a pre-generated file. This reference covers the settings for configuring a saved search flow.
Saved search flows generate a CSV file from a public, active NetSuite saved search and transfer it to the bank. The number of saved search flows available in your account is determined by your subscription.
For instructions on running the flow after configuration, see Run and schedule data flows in Vendor Payment Manager.
Before you begin
The saved search you plan to use must meet the following requirements in NetSuite before the flow can access it:
- The saved search must be set to Public.
- The saved search must be set to Active.
- The saved search must be based on one of the supported NetSuite record types: Vendor or Transactions.
Search Export Parameters
| Field | Description |
|---|---|
| NetSuite Record | The record type of the saved search. Supported values are Vendor and Transactions. |
| NetSuite SavedSearch | The saved search to use as the data source. Select Refresh to load the list of available public, active saved searches, then select one. |
| SavedSearch Export Type | Controls which records from the saved search are transferred. See SavedSearch Export Type options for details. |
| CSV Export File Name | The name of the CSV file generated from the saved search. Enter a name without the file extension. To include a timestamp in the filename, use a Handlebars expression, for example, payment_file_{{timestamp}} or payment_file_{{timestamp(DD-MM-YYYY)}}. For supported timestamp formats, see the Moment.js display documentation. |
| FTP Import Folder | The directory path on the bank's FTP or SFTP server where the generated CSV file is sent. |
SavedSearch Export Type options
| Option | Behavior |
|---|---|
| All | Transfers all records that meet the saved search criteria on every flow run. |
| Once | Transfers only records that haven't been transferred before. Records that have already been sent are skipped on subsequent runs. |
| Delta | Transfers only records that were created or changed since the last flow run. |
Notes
- Saved search flows always output a CSV file. The file format cannot be changed.
- PGP encryption is not supported for saved search flows.
- The After Transfer Action settings available in standard NetSuite to Bank flows are not available for saved search flows.
- Field mappings are pre-built but can be modified. See Map source data fields to destination for details.