This guide will show you step by step on how to setup a Bank Statement File Processing configuration record.
Overview
The Bank Statement File Processing Record contains a sublist of Bank Statement File Processing Rules. The rules are used to determine if the file within the specified folder, that we will call un-processed folder,
matches with any of the regexes within the rules. A Bank Statement Auto-Import record will be created for any files that matches as long as the rule has a Bank Account Configuration or a Multiple Statement Configuration specified.
Record Description
Bank Statement File Processing
Fields
| 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. Mandatory | custrecord_fp_unprocessed |
| Processed folder | The ID of the Folder where the processed files will be deposited. | 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 |
Bank Statement File Processing Rule
Fields
| Field | Description | Field ID |
|---|---|---|
| Matching Rule | A field that holds a valid JavaScript flavour regex. Defaults to ' .* ' | 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
This part of the user guide will show you how to set up the File Processing feature step by step.
Steps
- Create a new Bank Statement File Processing record.