Page Comparison

...

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.

   1. The processed folder may not be a sub folder of the unprocessed folder! Note the folder ID for both folders.

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

   1. Go to Setup > Bank Reconciliation > Bank Statement File Processing

   2. 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 - Bank Statement File Processing MR

   1. Go to Customisation > Scripting > Scripts and find a script called "Bank Statement File Processing MR". See more details here.

   2. Click on the subtab Deployments and click on the title deployment: "Bank Statement File Processing MR Deployment"

   3. 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.

   4. This script will move the file from the unprocessed folder to the Processed folder & create the auto import record

   5. The auto import record will be set to “No”

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

   1. Go to Customisation > Scripting > Scripts and find a script called "BS SC Import".

   2. 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.

   3. This script will create the bank statement from the auto import record

   4. The auto import record will be set to “Yes”

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

6. NOTE: if you have set the last script to split the statements only, you will find the statements in the Statements to Process list

Related articles

...