N/APosted on - 09/13/2013
I got this error message while creating the supplier invoice. The error shows “Invoice Id for this supplier already exists”. Is it a double entry or anything else? I just need your suggestion to resolve this issue. Thanks in advance.
Invoice Id for this supplier already exists.
Duplicate detected while creating the supplier invoice
You are correct in your analysis that a duplicate does exist. The report generator is trying to check for the uniqueness of the supplier id and it is finding more than one record with the same supplier id. If the data is on Excel, you can easily point out the conflicting record by selecting the entire column, go to Data tab > Remove Duplicates > Select the column and click OK. This will highlight the duplicates in red.