Check Invoice Duplication
In our SAP system, there are several companys.
I would like to check the invoice duplication between companys with criteria Vendor and Reference Field.
I have set the Check Duplication Invoices setting by the following path:
SPRO-> Materials Management -> Logistics Invoice Verification -> Incoming Invoice -> Set Check Duplication Invoices
As I would like to check the invoice duplication with same vendor and same reference field, I have only select the "Check Reference" box in the screen of all companies.
I have created an invoice in company A with vendor 1 and reference #REF1. I then create another invoice in company A with vendor 1 and reference #REF1.
I found that no duplication can be checked. Can I ask anything is missing in the setting?
If you are referring to duplicate invoices in MIRO, then for avoiding check based on invoice date, then remove the tick from "invoice date" field against the co. code in which you want in SPRO->Materials Magement -> Logistics invoice verification -> Incoming invoice -> Set check for Duplicate invoices.
If you are referring to FI invoices, then you may have to activate BTE 1110 by creating your own Z function module (by copying FM SAMPLE_PROCESS_00001110).
In FI,when checking for duplicated invoices, the system compares the following :Vendor, currency, company code, gross amount of the invoice, reference document number and Invoice document date.
SAP Note 305201 clarifies this in a more details; please read it.
The following fields must be identical for Duplicate invoice check
Company code (BUKRS)
Vendor number (LIFNR)
Reference number (XBLNR)
Amount in document currency (WRBTR)
Document date (BLDAT)
If the document is having any one of the above filed different then the
system does not consider it as a duplicate invoice.
Also It will check duplicate invoice check in vendor master data and in posting key is there check box selected for sales related
The setting you making in OMRDC i.e Materials management->Logistics Invoice Verification->Incoming Invoice ->Set Check for Duplicate Invoices is only valid for MM and not FI invoices posted via FB60/FB65
You should check the F1 help on field "Chk double inv." (LFB1-REPRF) in the relevant vendor master record (transaction FK03).
Please also check, that message F5 117 has been set correctly in the IMG using this path:
Financial Accounting -> Financial Accounting Global Settings -> Document -> Default Values for Document Processing -> Change Message Control for Document Control For Document Processing
Finally & mainly, go to the relevant posting key is defined as sales related in transaction OB41. You have to flag this field if the
duplicate invoice check should work.