SAP Knowledge Base Article - Public

3708885 - "You have duplicate invoices in your worklist" in Import Supplier Invoices App - SAP S/4HANA Public Cloud Edition

Symptom

When importing supplier invoices in Import Supplier Invoices app (F3041), an error message is displayed: "You have duplicate invoices in your worklist".

Environment

SAP S/4HANA Public Cloud Edition

Reproducing the Issue

  1. Open the app "Import Supplier Invoices".
  2. Upload a supplier invoice template.
  3. Select Check
  4. In the Information message pop up window check the error via "Show Log".
  5. In the Log Details observe the error "You have duplicate invoices in your worklist. Please resolve them".

Additional information:

When jumping to the duplicated invoices in the template to create and post supplier invoice (manually), a warning message appears "Inv. not automatically created, potential duplicate exists (acc doc XXXXXXXXXX YYYY). The invoice(s) can be posted. 

Cause

When checking duplicate invoices, the system compares the specific attributes in the standard system. The system checks always the following attributes:

  • Supplier
  • Currency
  • Gross invoice amount
  • Reference

We have to separate two check rules:

Rule A

The checkbox "Check Double Invoice" in BP master is set. It is checking duplicate entries in the worklist and it is triggered if more than 2 items are duplicated in the worklist. 

Rule B

In Configuration Activities 102091 and 102092 error message types M8 804 and M8 805 are set.

  • M8 804 - Inv. not automatically created, potential duplicate exists (acc doc & &)
  • M8 805 - Invoice not automatically created, potential duplicate exists (inv. & &)

These checks are verifying if the draft invoice is a duplicate with the existing accounting doc, and the error message is "Inv. not automatically created, potential duplicate exists (acc doc XXXXXXXXXX YYYY)" It will be triggered even though only 1 entry in the worklist exists but it is duplicated with the existing accounting doc. you can control it to be E/W/-.

Resolution

For 'Rule A', there is no message control for the error. By removing the duplicate invoice check flag in BP master, the system allows the duplicate postings.

For 'Rule B', M8 804 and M8 805 can be controlled in the Configuration Activities for E/W/-.

If the 'Rule A' is active and 'Rule B' is set to W (Warning), the error message "You have duplicate invoices in your worklist. Please resolve them." will be displayed when there are duplicate entries in the worklist, it is working as design.

See Also

Keywords

duplicate check, import supplier invoices, error message, supplier invoice upload, Config Activity 103518, SAP S/4HANA Cloud Public Edition, invoice management, duplicate detection settings, upload, import, F3041, F3 041, M8804, M8805, Configuration 102091, 102092, check double invoice, check duplicate invoice , KBA , FI-FIO-AP-TRA-2CL , Transaction Apps: Public Cloud , Problem

Product

SAP S/4HANA Cloud Public Edition all versions