We are setting up Automatic Bank Statement Import for Bank of America BAI2 files and Wells Fargo BAI2 files Problems: • We have a few concurrent issues and we're trying to determine whether they're related, as well as how to solve them: ◦ Automatic Bank Statement Import every day or every other day has both a successful import and an import that fails due to the file allegedly already having been uploaded. ◦ It imports twice a day for each bank despite us having only 1 Format Profile for each bank, set to run only 1 time per day. ◦ Three of our Accounts in NetSuite are not showing any activity on them, but it should be there according to the manual data entry and tracking process we've been using up to now. Questions: • Could the importer miss or ignore an entry in a BAI2 file or the entire file itself if the filename is the same as the day before (due to that already-uploaded-this-file error)? • Without having to talk to the banks themselves, does anyone know whether Bank of America or Wells Fargo would ever upload or update a file by the same name, with different information in it? • Does the Automatic Bank Statement Import feature ignore or filter out ZBA disbursement accounts because they either always balance to zero or always have what might look like duplicate transactions since they're transferring the same amounts from one account to another (this seems unlikely since what's the point of accounting if we only look at net resulting amounts)?

AI generated answer (using internal Slack threads):

Based on the conversations, here are the answers to your questions: 1. Yes, the importer could potentially miss or ignore an entry in a BAI2 file or the entire file itself if the filename is the same as the day before. This is because NetSuite uses filename-based duplicate detection and the import fails when the same filename has already been imported from that bank. It also imports only the first file matching the SFTP filename pattern during each run, so an older file remaining on the SFTP server could repeatedly block newer files. 2. The conversations do not provide specific information about whether Bank of America or Wells Fargo would ever upload or update a file by the same name, with different information in it. However, it's generally a good practice for banks to use unique filenames for each file to avoid confusion and potential import issues. 3. The Automatic Bank Statement Import feature should not ignore or filter out ZBA disbursement accounts. However, if the transactions are not present in the BAI2 files at all, it could be due to the bank not including them or due to some transactions still being pending at the time the BAI2 file is sent over. It's also possible that custom transaction codes were not mapped correctly in NetSuite, causing some transactions to be missed. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******