SAP Knowledge Base Article - Public

1882313 - Unable to Upload Accounts From Microsoft Excel Due to Potential Duplicates

Symptom

Unable to upload accounts from Microsoft Excel due to potential duplicates.

Reproducing the Issue

1. Go to the Account Management work center.
2. Go to the Accounts view.
3. Select the New button and select the Corporate Accounts From Microsoft Excel option. 
4. Enter the Account Name similar to the name of existing ones.
5. Select the button Save Data To in the SAP Business ByDesign tab.

You the following error message occurs and the accounts are not uploaded: Potential Duplicates Found.

Cause

When attempting to upload new accounts via the excel template the duplicate check is more sensitive compare to the information which is entered manually.

Resolution

You have 2 possibilities to solve the issue if the data should be really uploaded via excel:

First Possibility:

You can deactivate the duplication check manually for specific business partners in the Microsoft Excel Template as follows:

  1. Go to the Account Management work center.
  2. Go to the Accounts view.
  3. Select the New button select the Corporate Accounts From Microsoft Excel option.
  4. In the Microsoft Excel Template select the respective account.
  5. Navigate to the column Duplicate Check Indicator.
  6. Select the No option.
  7. In the SAP Business ByDesign tab select the button Save Data To.


Second Possibility:

If you are sure that all the accounts in the excel are not duplicates, deactivate the duplicate check in Business Configuration, upload the data and activate it again afterwards.

Please follow the below steps to do the changes:

  1. Go to the Business Configuration work center.
  2. Select the Implementation Projects view and click on the button View Project Scope.
  3. Go to the chevron Questions.
  4. Select the scoping element General Business Data -> Business Partners -> Handling of Business Partners.
  5. Under question section expand the option Duplicate Check for Business Partners.
  6. Select Yes for the option Do you want to disable the duplicate check for business partners?

The error message does not occur and you are able to upload the account to your system.

Keywords

KBA , SRD-CC , Cross Components , How To

Product

SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1711