Duplicate invoice posting due to archived accounting documents

[Former Member]

Hi,

Duplicate invoice posting is allowing against the below two Invoice reference nou2019s

In transaction MIRO.

00082 and 00072.

After investigation I have found that these invoice reference nou2019s are used in 2002 for accounting documents 3300130419 and 3300135574 and these two documents are archived, and found that these accounting entries are missing in the table BKPF and existing in the table BSIP.

We donu2019t want to allow the system to post duplicate invoices (For Example: against 00082 and 00072 Invoice reference Nos.)

Could you please look into this

[former_member581212 · Accepted solution]

hi,

Have you archived the material document...If not then its for sure that system will check it even if you use the deletion for it...just becoz the system stores the header level data in the system and will not be traced when you do archive it...

Regards

Priyanka.P

[Former Member · Accepted solution]

Hi Priyanka,

This archived account document is Type KR - Vendor invoice.

This doc dont have material document.

and entries are found in BSIP table and not in BKPF table.

If we archive any accounting document does it mean that it will disappear from BKPF table?

If life span of BSIP table is over does it create probelm for duplicate invoice checking?

Thanks

Vikas

[Former Member]

Solved problem by implementing SAP Note 924769

[JL23]

SAP can only check against numbers that you have in your system, if the documents are archived then you dont have the numbers anymore in your tables.

How can SAP then know that is would be a duplicate.?

Do you really think that the invoice is a duplicate after that many years?

[Former Member]

Hi Priyanka, Kishore, Jurgen!

Thanks for The Reply,

During debugging the MIRO transaction, I found that System is seraching for duplicate invoices and finds accounting document with the same referance nos.(i.e. 00082) for the same vendor.

1) system finds these old archived document in BSIP table.

2) again system searces this document in BKPF table and there is no entry in BKPF table.

So system come out from the program and allowing to post Duplicate invoices.

(I have tried to delete this archived document entry from BSIP table, and system shows error message successfully for duplicate invoice during debugging.)

My problem is that I cant delete this BSIP table entries because there may be problem in FI Reports.

and I cant replicate this enties in BKPF table.

Please help.

Vikas

[JL23]

What release do you have?

According to OSS Note 305201 - Description: Check for duplicate invoices

it should be different to your examination.

"If all the cited characteristics match, the system displays a customizable message. M8462 (if logistics invoice documents are found) or M8108 (if accounting documents are found)."

[Former Member]

Hi Jurgan!

Thanks for the reply,

We are using ECC6,

Support pack : SAPKH60013

Settings for Duplicate Invoice Check In Vendor Master is correct

Customization setting OMRDC transaction, tick mark for invoice reference no. only

If all the cited characteristics match, the system displays a

customizable message. M8462 (if logistics invoice documents are found) or M8108 (if accounting documents are found).

I have ensured that message M8108 (if accounting documents are found) is maintained as an error message in OMRM.

Still system is allowing duplicate invoices for the reference nos. 00082 and 00072.

For other reference Nos. which are previously used for other documents, system issues error message successfully.

I dont want to delete archived accounting doc. and if I maintaind BKPF entris of this archived doc manually it will create probelm in FI.

is this happen due to life span of secondory index of archived accounting doc. is completed ?.

Please Help

Many Thanks

Vikas

[Former Member]

Hi

As per your details, are you saying that the sytem is not checking as per standard.

The system performs the check comparing both the invoice with below fields.

RBKP_V-BUKRS

RBKP_V-LIFNR

RBKP_V-WAERS

RBKP_V-XBLNR

RBKP_V-BLDAT

RBKP_V-RMWWR

RBKP_V-XRECH

If all the fields are similar then the sytem will issue the error of duplicate invoice.

Please check if all the criteria is met. If met but still sytem is not giving an error then thats a genuine problem

Thanks & Regards

Kishore