Versions Compared

Key

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

...

  1. On the configuration record, check ‘Disable Automatic Matching on Import’

  2. If you wish to limit the Bank Statement Transactions that are matched, create a saved search based on this default search: Unmatched Bank Statement Transactions (customsearch_bs_unmatch_bs_trans) (do not remove column). For most use cases, the default search will suffice.

  3. Go the the Map/Reduce script BS MR Single Value Matching

  4. Create a deployment (button Deploy Script) with an appropriate schedule to run (you may also create an After Submit script on the Bank Statement record that automatically triggers this M/R script). Please note the different type of IDs requested on the deployment>Parameters subtab section - the internal ID of the Bank Account Configuration is a number, whereas the saved search ID is usually a string of text. The internal ID of the Bank Account configuration can be found at Setup>Bank Reconciliation Setup>Bank Account Configurations. If the list of the Bank Account Configurations do not display the internal ID, go to Home>Set Preferences and in the Defaults section mark the checkbox “Show Internal IDs“, save the changes and return to the previous page.

  5. On the deployment > Parameters, enter the internal ID of a Bank Account Configuration record. Only Bank Statement Transactions linked to this configuration record will be auto-matched.

  6. On the deployment > Parameters, enter the saved search ID ‘customsearch_bs_unmatch_bs_trans’ or a search you defined based on the default search.

...