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.

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To automate the import of bank statement files such as BAI2 files for use in the Match Bank Data page, you can create a batch script that reads the files from your inbound folder (or directly from your sftp connection), imports the bank data, and then moves the file to an archive folder. This process can be scheduled to run on a regular basis, thus automating the import of your bank statement files. However, it's important to note that this process will require a good understanding of SuiteScript and batch scripting. You might also need to install and set up a Parser plugin and the Bank Connectivity plugin in NetSuite. Here is a high-level overview of the steps you might need to follow: 1. Set up your Financial Institution in NetSuite. 2. Install and set up the Parser plugin. 3. Install and set up the Bank Connectivity plugin. 4. Create a batch script that reads the bank statement files from your inbound folder (or directly from your sftp connection), imports the bank data into NetSuite, and then moves the file to an archive folder. 5. Schedule this batch script to run on a regular basis. Please note that this is a high-level overview and the exact steps might vary based on your specific requirements and setup. Also, please be aware that even after importing the BAI2 file, you might still need to create GL for those transactions to see the bank statement balance in NetSuite. For more detailed information, you can refer to the official NetSuite documentation: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/article_1107042047.html