You can prevent one or more accounts from being uploaded by using the Do Not Upload List.
...
To specify a single account to exclude, select the source Source and enter an account idAccount Id to match. For example, entering 'ACCOUNTXYZ' and selecting Sterling as the source will exclude all activity for that account when importing data from Sterling:
...
Note that the Account Id is checked for exclusion before any rename rules are applied. Once an account is excludedadded to the list, all uploads for that account will be excluded: executions, adjustments, locates, positions (for reconciliation) and buying power entries (if enabled). Data that has already been loaded Any already loaded will not be affected.
Tip: To exclude multiple accounts, you can specify a pattern in the Expression boxto match. Here are some examples:
| Expression | Will Exclude |
|---|---|
| .* | All accounts. |
| ABC.* | All accounts that start with ABC |
| (?!^ABC).* | All accounts that do not start with ABC |
| (?!^ABC)(?!^XYZ).* | All accounts that do not start with ABC or XYZ |
| ^[0-9]+$ | All numeric accounts |
| ^.*CAD$ | All accounts ending in CAD |
| ABC[0-9][0-9][0-9] | All acounts starting with ABC followed by three digits |
The patterns used are Perl Compatible Regular Expressions. Their syntax is described in detail here.
Testing the List
To test see whether or not an account was successfully excluded, select the sourcewill be excluded:
Step 1: Click on the Test an Account Id
Step 2: Select the Source, enter the account name Account Id and press test Test:
