AP Invoice Import - Duplicate invoices exist. No invoice entries were created



Description of Issue

When attempting to import, popup error message states Duplicate invoices exist. No invoice entries were created 



Context
  • EERP

  • Accounts Payable

  • Invoice Import



Cause

Import file contains duplicate invoice numbers of other invoices within the import file



Resolution

Review the import file for duplicated invoice numbers and adjust them to be unique



Additional Information

Finding duplicate invoice numbers on invoice import file

Highlight Invoice Number Column – header only

  • Conditional Formatting

  • Highlight Cell Rules

  • Duplicate Values

  • Hit OK

  • Duplicates will show in Red