How to find out duplicate invoices?

[Former Member]

Hi gurus,

What are the ways to identify duplicate payments for PO and non-PO invoices? Should we look for the unique combination of the below fields, or do we have to add more - intercompany. cancelled flags, what if ref doc number is blank etc

• Company Code
• Vendor
• Currency
• Invoice Date
• Reference document number

So basically wanted to see how you performed this task to get some new ideas.

Thanks

Tansu

[Gustavo_Vazquez · Accepted solution]

Hi Tansu,

S_ALR_87012341 - Invoice Numbers allocated twice

Kind Regards

[Former Member · Accepted solution]

Hello

Will this exclude the credit memos, down payments etc to show real duplicate payments?

Thanks

Tansu

[Gustavo_Vazquez · Accepted solution]

Hi Tansu,

You will have to try it. I'll check on monday on how it works.

Kind Regards.

[Gustavo_Vazquez · Accepted solution]

Hi Tansu,

The report will check all documents where Reference Number is the same, no matter if its a down payment or an invoice.

You will have to create diferent variants for invoices & credit memos. You can use the "Same document date" to distinguish invoices with the same date.

kind Regards