Setup Schedule Matching
When using scheduled matching, existing bank statements are re-matched using the settings on the Bank Account Configuration (Setup > ZoneReconcile Setup > Bank Account Configuration) record.
The result is the same as matching on import, but it can handle more data.
Steps to setup:
- On the configuration record, check “Disable Automatic Matching on Import”
- On the configuration record, check “Enable re-matching of existing statements”
- Go to the scheduled script ‘BS Scheduled Matching’. On the deployment record, set the status to “Scheduled”, set an appropriate schedule (f.i. every hour) and mark the check “No end date”
Now all statements, that are not fully matched or reconciled, will be automatically evaluated for re-matching by the scheduled script. Also on the statement record a button appears to run the matching in the background.
Customize the Scheduled Matching
The ZoneReconcile tool allows customizing the scheduled matching setup to run it for only selected records. This can be done by customizing the default saved search named “Not Matched Bank Statement Transactions for Scheduled Matching“. This saved search is included by default in the bundle.
By default, the ZoneReconcile SuiteApp will try to load all unmatched bank statement transaction lines. A custom search can be set in this field to limit the number of results to a specific bank account configuration or to a specific date range. It is recommended to use this if scheduled matching is only needed for a specific bank account configuration or when time-outs occur.
Under the Parameters subtab of the deployment record, enter the internal ID of a search of bank statement transactions that should be matched by this script.
The custom search should be created by making a copy of the default search and adding further criteria to limit the records.
No other changes are recommend as this could lead to incorrect results.