This guide will show you step by step on how to setup a Bank Statement File Processing configuration record.
...
| Field | Description | Field ID | ||
|---|---|---|---|---|
| Un-processed folder | The ID of the Folder where the files you want processed will be deposited and picked up for evaluation.
| custrecord_fp_unprocessed | ||
| Processed folder | The ID of the Folder where the processed files will be deposited. If not specified, the files will not be moved from the Un-processed folder. | custrecord_fp_processed |
Sublists
| Child Record | Description | Sublist ID |
|---|---|---|
| Bank Statement File Processing Rule | A record holding the regex used for the matching and the Bank Account Configuration or Multiple Statement Configuration used for the creation of the Bank Statement Auto-Import record. | recmachcustrecord_fp_processing_config |
...
| Field | Description | Field ID |
|---|---|---|
| Matching Rule | custrecord_fp_rule_regex | |
| Bank Account Configuration | The Bank Account Configuration record that will be used when the Bank Statement Auto-Import Record is created. | custrecord_fp_account |
| Multiple Configuration Record | The Bank Multiple Statement Import Config record that will be used when the Bank Statement Auto-Import Record is created. | custrecord_fp_multi |
Parent Record
| Parent Record | Description | Field ID |
|---|---|---|
| Bank Statement File Processing | The Bank Statement File Processing contains a set of Bank Statement File Processing Rules that are applied to all files within the Un-processed folder to create Bank Statement Auto-Import records. | custrecord_fp_processing_config |
Using the Bank Statement File Processing
...
- Create a new Bank Statement File Processing record.
- Specify a Name. Can be used to identify the set of rules you will attach to a folder.
- In the Un-processed folder field, insert the Folder ID from where the un-processed files will be picked up.
- If you want to move the files after they have been processed then populate the Processed folder with a valid Folder ID.
- Move to the Sublist beneath the fields.
You can change the matching rule from the default value to the one that matches your needs.
Tip Test your regular expressions on Regex101, remember to select the javascript flavour first.
- Specify either a Bank Account Configuration or a Multiple Configuration Record.
- If you specify both, the Bank Account Configuration will be used.
- If you specify none, the Bank Statement Auto Import record will not be created.
Click on Add.
Note If the regex was not valid you will get a pop-up telling showing you the error.
- Repeat the three previous steps for each rule.
- Click on Save when you are done.
- Go to Customization → Scripts → Scripting.
- Expand the Filters box and filter by Type Map/Reduce.
- Search for Bank Statement File Processing MR and click on deployments.
- You should see one deployment record. Click on Edit.
- If you want to do a testing run, put your mouse on Save untill a drop-down shows and click on Save & Execute.
- Set the Status to Scheduled.
- On the Schedule sublist, set a recuring date for the script to be executed.
- Click on Save.