This page is for users to setup auto processing of files that are already imported into the file cabinet. The user will need to setup 2 file folders in Netsuite, 1 for files that need to be processed and another for files that have been processed.
This process replaces the need for the user to import a file manually and create and match a bank statement.
Instructions
Create a new File Cabinet Folder for both unprocessed and processed files. The processed folder may not be a sub folder of the unprocessed folder! Note the folder ID for both folders.
Create a "Bank Statement File Processing" record. Go to Setup > Bank Reconciliation > Bank Statement File Processing
Create a New Bank Statement File Processing record and select either the Bank Account Configuration for single file imports or the Multiple Configuration Record for multi file imports. (Save)
Go to Customisation > Scripting > Scripts and find a script called "Bank Statement File Processing MR". See more details here.
Click on the subtab Deployments and click on the title deployment: "Bank Statement File Processing MR Deployment"
Schedule this to run daily after you know the new file will be available in the file cabinet. Eg 8am if you know the file is expected at 07.30am.
Go to Customisation > Scripting > Scripts and find a script called "BS SC Import".
Schedule this to run daily at least 1 hour after the previous script. This will give the first script time to execute before running the next one.
Go to Transactions, Bank Reconciliation, Statement list to find the statements that have been imported.