Managing SFTP Connectivity File Imports
Read the following topics to learn more about managing your bank statement file imports in NetSuite:
Viewing the SFTP Connectivity Import Details
Every time you save a format profile, you’ll see a progress message on the financial institution record. Click the Track your status link to check how your import's going.
You can also go straight to the Banking Import History page to check the status and details of each imported bank statement. To get to the Banking Import History page, go to Transactions > Bank > Banking Import History.
SFTP Connectivity File Import Record
Check the SFTP Connectivity File Import List page if you want to see all the bank statement files you've imported into NetSuite using SFTP Connectivity.
To view an SFTP Connectivity File Import record
-
Go to Customization > Lists, Records, & Fields > Record Types.
-
On the Record Types page, click List on the SFTP Connectivity File Import line.
-
Click View next to the SFTP Connectivity File Import record you want to view. Each imported file record contains the following information:
-
Filename
-
Configuration ID
-
URL
-
Deleting SFTP Connectivity Failed Import Record
The SFTP Connectivity plug-in uses the file name pattern you set to look for files to import from your bank’s server. It imports the first file that matches. If files aren’t uploaded because of parsing errors, you’ll need to delete the failed import records before you can upload them again.
To delete failed SFTP Connectivity file import records:
-
Go to Transactions > Bank > Upload File > List.
-
On the Imported Statement List, you’ll see all the SFTP Connectivity imports and their status. Make note of any import detail record with a Failed status.
-
Check the error details to find out what went wrong. Fix the error, then move on to delete the records.
You can also check the execution logs of your failed import to figure out which SFTP Connectivity File Import to delete. To do this:
-
Using the Administrator role, go to Customization > Plug-ins > Plug-In Implementations.
-
Click the SFTP Connectivity plug-in implementation.
-
Click the Execution Logs subtab to see the audit log details for your imports.
-
-
Go to Customization > Lists, Records, & Fields > Record Types.
-
On the Record Types page, click the List link on the SFTP Connectivity File Import line.
-
On the SFTP Connectivity File Import List page, find the records you want to delete and click Edit.
-
On the SFTP Connectivity File Import page, hover over Actions, and click Delete.
Note:If Inline Editing is enabled on your account, click the Edit slider to turn on inline editing. Hover under the New column to see more options, then click Delete Record.