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. 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"
- 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 30 mins 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.
Related articles