SAP Knowledge Base Article - Public

2756581 - Account Advance Search with Employee Exclude Query Option

Symptom

You want to search Accounts that Owner is not assigned to a special employee, but find the query result still includes some Accounts assigned to that employee.

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to Customer work center.
  2. Go to Account work center view.
  3. Select All and click on Advance Search.
  4. Click on the + icon besides Employee field.
  5. Check “But exclude” option and set the search condition as “=Equal to Employee ABC” (ABC represents the Employee name).
  6. Click GO and find the query result still includes some Accounts assigned to that employee.

Cause

Via the query parameter "Employee", you search at 2 places:

  1. In the account team.
  2. In the team of the territory assigned to the account.

Resolution

If you would like the employee search should only consider the account team, or only the employee responsible sales role to be considered, set the query parameter Responsibility Source and Party Role field under Team area need to be filled.

Keywords

!(=;But exclude;Account Search;Employee Exclude; , KBA , LOD-CRM-ACC , Account , How To

Product

SAP Cloud for Customer add-ins all versions