How to automate the import of bank statement files such as bai2 files for use in the Match Bank Data page? I'm asking because we already have sftp set up which is how we get the files in the first place, and we don't want to hassle with setting up connectors. We do want to be able to import the statements on a scheduled basis like you can with the connectors though. We would want to import these files either directly via the same sftp connection that pulls them to our on-premises folders, or pull them in from those folders themselves. I want to have this scheduled process automatically upload the bank statement files in such a way that their data shows up in the Match Bank Data page, just as it would if I had manually clicked the Upload file button on the Match Bank Data page and uploaded the bank statement files from there. We want to do this with NetSuite's native default parser, so don't give answers that require setting up Financial Institutions or Parser plugins or Bank Connectivity plugins. I just want it to automatically do a file upload in the Match Bank Data page like we would manually do (which doesn't require any of those other plugins or components to be set up).

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that automating the import of bank statement files such as bai2 files for use in the Match Bank Data page can be achieved using SuiteScript. You can create a batch script that reads the bank statement files from the inbound folder, imports the bank data, and then moves the file to an archive folder. However, it's important to note that this process is not as straightforward as a classic CSV import. The bank statement files can be in various formats such as CSV, CAMT053, BAI2, or OFX. Here is the suggested process: 1. Store the bank statement files in a file cabinet folder in NetSuite. 2. Create a batch script that reads the files from this folder. 3. The script should then import the bank data into the banking import history for reconciliation. 4. After the import, the script should move the file to an archive folder. Please note that this process requires a good understanding of SuiteScript and batch scripting. You might need to customize the script based on the specific requirements of your bank statement files and your NetSuite setup. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******