Versions Compared

Version Old Version 17 New Version 18
Changes made by

Andrei Dediu (Unlicensed)

Tania Hudig (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 file names (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

FieldDescription

Field ID

Un-processed folder

The ID of the Folder where the files you want processed will be deposited and picked up for evaluationand processed.

Note

Mandatory


custrecord_fp_unprocessed
Processed folderThe ID of the Folder where the processed files will be deposited after processing. If not specified, the files will not be moved from the Un-processed folder.custrecord_fp_processed

Sublists

Child RecordDescriptionSublist ID
Bank Statement File Processing Rule

A record holding the file name (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

FieldDescriptionField ID
Matching Rule

A field that holds a valid JavaScript flavour regex.

Tip

Defaults to  .*  This is only useful if a single file is to be picked up for processing.


custrecord_fp_rule_regex
Bank Account Configuration

The Bank Account Configuration record that record or reference number 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 RecordDescriptionField 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

Creating the Bank Statement File Processing records

  • Go to Setup > Bank Reconciliation Setup > 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 selection of the file name (matching rule) on the file name 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. Using Regex101 file names gives the user more flexibility in selecting the 


  • 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 showing you the error.


  • Repeat the three previous steps for each rule.

Scheduling the Bank Statement File Processing feature

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




Table of Contents
stylesquare