Query
We are planning to setup Auto Bank Statement Import (ABSI) to automatically retrieve the bank statement file from our bank. and I would like to confirm following.
- Download file pattern: do we have to specify the reserved words for the file pattern? For example, can we remove {DateToday} from the pattern: MyBank_[0-9]{5}_{DateToday}.txt?
- How many files can be imported one time?
- Can we schedule the import? if not, what is the preset schedule?
Solution
- As per checking, you will need to set the file name pattern using regular expressions and reserved words because the system will use this to match bank statement files from your financial institution’s server.
- It is currently a system limitation and is filed as enhancement. The SuiteApp will only fetch 1 bank statement file per day automatically and any additional files may be manually fetched by doing either updating the Format Profile Record or the Match Bank Data page. (Refer to SuiteAnswers ID: 103771)
- Typically, the scheduled imports in NetSuite occur from 4:00 a.m. – 7:00 a.m., Pacific Time (UTC -8). Schedule can change at any time to account for load performance on NetSuite systems.
As per checking, only file names are stored on our system at the SFTP Connectivity File Import List page and not the actual transactions/imported file.