Commonly, the following process is observed in a NetSuite vendor payment flow. The customer processes purchase order bills and makes payments in NetSuite. These payments are processed by the Banks and are called Accounts payable in accounting terms.
The customer generates the outgoing accounts payable file (NACHA, Wire, etc.) that will then be transferred to the bank via FTP for further processing. The user can send any allowable file format. Vendor Payment Manager allows the transfer of multiple files in a single flow run until the folder is empty. Usually, there is only one file in the outbound folder.
In this use case, the file is generated by the Vendor Payment Manager through a user-defined (NetSuite) Saved Search as a source. The integration app generates a CSV file from the Saved Search and then transfers it to the Bank FTP server. The number of saved search flows is governed by the license.
The following sample automated data flows are provided in the Vendor Payment Manager to facilitate the above process. The flows are rendered based on bank license and file formats.
Transactions SavedSearch Export
- NetSuite SavedSearch to Bank File Transfer
The data flow represents the bank and the payment file format. You need to set up the FTP parameters for each flow before running the flow (or flow can be set up to run automatically after user-defined scheduled intervals). The data flow comes with prebuilt field mappings that can be modified or new field mappings can be added. Refer to the topic ‘How to use the data flow’ for further learning.
Search Export Parameters
- NetSuite Record: Record Type on the NetSuite SavedSearch.
- NetSuite SavedSearch: Click Refresh and select the NetSuite Saved Search that should be exported as a file to the bank.
-
SavedSearch Export Type: Choose from different export options that allow you to filter the records for transfer.
- All: This option selects all the records that meet the Saved Search criteria for transfer.
- Once: This option selects only those records from the Saved Search results which haven't been transferred before.
- Delta: It selects any record that has been changed or created since the last flow run, for transfer.
-
CSV Export File Name (without extension): Enter the name of file that will contain saved search data for export to the Bank. The file will be generated as a comma-separated value (CSV) file. You can add a timestamp to the generated filename by using handlebar expressions. Examples : filename_{{timestamp}}, filename_{{timestamp(FORMAT)}}. Supported timestamp formats: Refer to Moment.js formats (DD-MM-YYYY, MM-DD-YYYY, YYYY-DD-MM, etc.)
-
FTP Import Folder: Please provide the path of the Directory in the Bank FTP server where the files will be stored after transfer.
Comments
Please sign in to leave a comment.