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

1. 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.
• Make sure you use the ID of the processed folder as Statement folder ID for the Bank Account configurations subject to auto process statements for

2. Create a "Bank Statement File Processing" record.

• Go to Setup > ZoneReconcile Setup> 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)

3. Schedule Script 1: Type: Map/Reduce - BS MR File Processing (former Bank Statement File Processing MR)

• Go to Customisation > Scripting > Scripts and find a script called “BS MR File Processing” (former Bank Statement File Processing MR). See more details here.
• Click on the Deploy button
• Schedule this to run daily after you know the new file will be available in the file cabinet. Eg. 8.00am if you know the file is expected at 07.30am.
• This script will move the file from the unprocessed folder to the Processed folder & create the auto import record
• The auto import record will be set to “No”

4. Schedule Script 2: Type: Scheduled - BS SC Import

• Go to Customisation > Scripting > Scripts and find a script called "BS SC Import".
• Click on the Deploy button
• 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. In our example at 9.00am the earliest.
• This script will create the bank statement from the auto import record
• The auto import record will be set to “Yes”

5. Go to Transactions, ZoneReconcile, Statement list to find the statements that have been imported.

6. NOTE: The last script (BS SC import) holds two preferences under the Parameters tab:

• ONLY SPLIT FILES - if checkbox is enabled, you will find the statements in the Statements to Process list
• ENABLE AUTO IMPORT PROCESSING LIMITATION - if enabled, the script will ONLY process bank statements created from files inserted to the File Cabinet (by ignoring manually imported)