How to automatically or via suitescript or workflows, import bai2 bank statement files for use with the Match Bank Data page, using the NetSuite default parser, and not using any format profiles, financial institutions, etc.? This would just be an automation of the manual process of using the Bank Statement file import feature that feeds data into the Match Bank Data page.

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 BAI2 bank statement files for use with the Match Bank Data page in NetSuite, you would need to create a SuiteScript that performs the following steps: 1. Retrieve the BAI2 file from the bank. This could be done via SFTP, email, or another method depending on the bank's capabilities. 2. Parse the BAI2 file. This would involve reading the file and converting it into a format that NetSuite can understand. 3. Import the parsed data into NetSuite. This would involve creating a CSV import file and using the

N/file

and

N/csvimport

SuiteScript modules to import the data. Here is a high-level example of what the SuiteScript might look like:

javascript
var file = N/file.load({
    id: 'path/to/bai2/file'
});

var parsedData = parseBai2File(file);

var csvFile = N/file.create({
    name: 'import.csv',
    fileType: N/file.Type.CSV,
    contents: convertToCsv(parsedData)
});

var csvImport = N/csvimport.create({
    name: 'Bank Statement Import',
    mappingId: 'customimport_bank_statement',
    primaryFile: csvFile
});

csvImport.submit();

Please note that this is a simplified example and does not include the

parseBai2File

and

convertToCsv

functions, which would need to be implemented based on the BAI2 file format and the requirements of your NetSuite instance. Also, please note that this approach does not use any format profiles, financial institutions, or other features of the Bank Statement Parser SuiteApp. It is a direct automation of the manual process of using the Bank Statement file import feature that feeds data into the Match Bank Data page.