...
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
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)
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 subtab Deployments and click on the title deployment: "BS MR File Processing” (former Bank Statement File Processing MR Deployment)Deploy button
Schedule this to run daily after you know the new file will be available in the file cabinet. Eg 8am . 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”
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”
Go to Transactions, Bank Reconciliation, Statement list to find the statements that have been imported.
NOTE: The last script (BS SC import) holds two preferences under the Parameters tab:
...