SAP Knowledge Base Article - Public

1905786 - Duplicate Entry Error When Creating new Supplier Invoice From Excel

Symptom

You are attempting to create new Invoices via Microsoft Excel, but the system shows an error message: 'Duplicate entry. Fix errors and submit data again.'.

Consequently, the new Invoice is not created in the system as expected.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Supplier Invoicing work center.
  2. Go to the Invoice Entry view.
  3. Press New, and then Import from Microsoft Excel.
  4. Logon to the system using the SAP Add-In.
  5. Fill the Supplier Invoice Header and the Supplier Invoice Lines.
  6. Press Save Data To.
  7. The system displays the error message: Duplicate entry. Fix errors and submit data again.

Cause

The problem is caused by the fact that the upload template can only be used once. Once you have uploaded data with the template before, and you try to reuse it, the system will show the duplicate error. Even though you have deleted the visible data, some hidden fields still contain references to the previous upload, and so the system is reporting the data as duplicate.

Resolution

The simplest solution is to use a fresh template every time and not reuse the template after you have used it to upload Invoices.

Keywords

Fix, errors, submit, again, duplicate, entry, demand, plan, template , KBA , duplicate entry. fix errors and submit , supplier invoicing , SRD-SRM-SI , Supplier Invoicing , How To

Product

SAP Business ByDesign all versions