1905786 - Duplicate entry error when creating new Supplier Invoice from Excel

SAP Knowledge Base Article - Public

1905786 - Duplicate entry error when creating new Supplier Invoice from Excel

Symptom

On attempting to create new invoices via Microsoft Excel, the system throws an error message: Error : Duplicate entry. Fix errors and submit data again.

The new invoice is consequently not created in the system as expected.

 

Reproducing the Issue

  1. In the Supplier Invoicing work center.
  2. In the Invoice Entry view.
  3. Press New > Import from Microsoft Excel.
  4. Logon in 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 error Error : Duplicate entry. Fix errors and submit data again is shown

Cause

The problem is caused by the fact that the upload template can only be used once.
If it is reused, even if the visible data is deleted, some hidden fields still contain references to the previous upload and the system will throw the duplicate error.

Resolution

Simplest solution is to use a fresh template every time and not reuse the template after it was used to upload invoices before.

Keywords

KBA , SRD-CC , Cross Components , How To

Product

SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1302 ; SAP Business ByDesign 1305 ; SAP Business ByDesign 1308 ; SAP Business ByDesign 1311 ; SAP Business ByDesign 1711