Do Not Upload List
You can prevent one or more accounts from being uploaded by using the Do Not Upload feature.
To view and edit the list, navigate to the Upload / Excluded Accounts:
Adding Accounts
To specify a single account to exclude, select the source and enter an account name. For example, entering 'AccountXYZ' and selecting Sterling as the source will exclude all activity for that account when importing data from Sterling:
Once the account is excluded, all uploads for account will be excluded: executions, adjustments, locates, positions (for reconciliation) and buying power entries (if enabled).
Existing data is not affected.
Tip: To exclude multiple accounts, you can specify a pattern in the Expression box. Here are some examples:
Expression | Will Exclude |
---|---|
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 pattern syntax used is described here.
Testing the List
To test whether or not an account was successfully excluded, select the source, enter the account name and press test: