Setting Up Outbound Configuration Records
You can create new outbound configuration records to connect NetSuite to the bank servers and initiate the payment file transfers.. You must have an Administrator role or Set Up role to configure the records.
To setup a new Outbound Configuration record:
-
Go to SFTP > SFTP Records > Outbound Configurations.
-
From the Outbound Configuration List page, click New Outbound Configuration.
-
In the Name field, enter the name of the bank server.
-
In the Remote URL field, enter the URL of the SFTP server.
Note:You must enter the URL without the protocol https:// and must not include a specified path to the SFTP folder.
-
Enter the port of the SFTP server in the Port field.
The port must be provided by the SFTP owner.
-
In the Host Key Type field, enter any of the following host key types.
-
RSA
-
DSA
-
ECDSA
-
-
In the Host Key field, enter the host key of the bank’s server. The host key must be provided by the SFTP owner. You can cross check the host key by using the ssh-keyscan -t rsa -p <port number> <URL> command in power shell for Windows and in terminal for Mac operating systems.
-
From the Authentication Method list, Select any of the following methods.
-
Username / Password:
-
When you select this method, you can enter a user name in the Username field and click the Set Password button. In the Set Password pop-up window, enter a password in the Password field and click Submit to save.
-
If your password changes or you save an incorrect password, you can recreate it by changing from the Set Password pop-up window.
-
-
Certificate / SSH Key:
When you select this method, a Certificate field appears from which you can select a previously saved certificate or SSH key.
Only the following SSH keys are supported. To know more about saving SSH private key in NetSuite, see Uploading Private SSH Keys.
-
RSA
-
DSA
-
ECDSA
Only the following digital certificates are supported. To know more about saving a certificate in NetSuite, see Uploading Digital Certificates.
-
PFX
-
P12
-
PEM
-
To create the Certificate/SSH key, use the ssh-keygen -m PEM -t rsa command.
-
To generate p12 format certificate, use the openssl pkcs12 -export -in <filename.txt> -out <filename.p12> command.
-
To generate PEM format certificate, use the cat test.key publicKey.cer > digCert.pem command
Note:To run openssl command you can use the cmder tool.
-
-
Multi-Factor Authentication (MFA) – When you select this method, you can enter a Username and click the Set Password button. In the Set Password pop-up window, enter a Password and click Submit to save the password. In the Certificate /SSH field, select a supported certificate or SSH key.
You must enable MFA as an authentication method at the bank server before using it in the SFTP Connector SuiteApp.
Important:The SFTP test connection and file transfer fails, if the username, password, certificate or SSH key you enter is invalid.
-
-
In the Outbound Mapping subtab, add the appropriate information in the following columns:
-
SFTP – Folder Mapping Name: Enter the name of a folder mapping.
-
NS Folder ID – For Processing – Enter the Internal ID of the file cabinet folder that has unprocessed files for SFTP file transfer
-
NS Folder ID – Processed – Enter the Internal ID of the file cabinet folder that has processed files by SFTP Connector.
-
Bank Folder – Enter the path of a folder to which the files are required to be transferred by the SFTP to bank servers. If the path is not provided, the files are transferred to the root folder of the bank servers.
-
-
Click Save.
Guidelines for Creating an Outbound Configuration Record
-
When you save a record for the first time, you must test the connection of the Outbound Configuration record. To do this click Edit next to the record and click the Test Connection button. A confirmation message appears if the test connection is successful. During this connection test, no files are transferred to the SFTP server.
-
When you save a record after a successful connection test, the Outbound – Manual and Outbound – Schedule buttons are displayed on the Outbound Configuration page. To know more about the functions of these buttons, see Manual Payment File Transfer and Schedule Payment File Transfer.
-
If the connection test is unsuccessful, an error message appears displaying the link to the Suitelet script. Click on the this link to go to the Suitelet script deployment under execution log. Here, you will find detailed information on the connection failure.
-
You can transfer files by using the following file formats. You can also transfer the files without an extension.
-
.csv
-
.pdf
-
.xls
-
.txt
-
.xml
When the processed and processing folders have the same file name, the file name is appended with _1 during the file transfer. The files are transferred after the file name is renamed.
-
-
Related Topics
- SFTP Connector SuiteApp
- Setting Up the SFTP Connector SuiteApp
- Roles and Permissions for SFTP Connector SuiteApp
- SFTP Connector Limitations
- Creating SFTP Connector Folders in NetSuite File Cabinet
- Encryption and Decryption Using Node Forge
- Setting Up Inbound Configuration Records
- Setting Up Decryption Configuration Records
- SFTP Connector Error Codes