Sure. Since NetSuite Ask an Expert Live is public, I would remove the account name, account ID, bank-specific confidential details, and any internal screenshots. Keep it generic enough to get useful technical guidance.
Title: SFTP Bank Integration – Import Successful but No Data in Match Bank Data
We are facing an issue with a bank integration using SFTP for automated bank statement imports.
The integration was configured successfully, and the Banking Import History showed successful execution for several days. However, no transaction data was available on the Match Bank Data page for reconciliation.
We have also verified that valid bank statement files are available in the configured SFTP directory.
Recently, the import process started failing with the following message:
"Bank server directory is empty."
This is occurring even though the expected files are present in the SFTP location.
Questions:
- If Banking Import History shows a successful execution, but no transactions appear in Match Bank Data, what could be the possible reasons?
- How can we verify whether NetSuite actually downloaded and processed the files from SFTP?
- What logs or records should we check to trace the file processing from SFTP to Match Bank Data?
- What could cause NetSuite to report "Bank server directory is empty" when files are available in the SFTP directory?
- Are there any specific configuration settings or file-format requirements we should verify for the SFTP bank integration?
Any guidance on troubleshooting this issue and identifying the root cause would be appreciated.
