Duplicate Invoice check issue

[Former Member]

Hi All,

Currently system checks below fields in order to give the duplicate invoice check . This is an standard functionality by SAP.

BUKRS

LIFNR

WAERS

XBLNR

WRBTR

BLDAT

We want system to behave as below

Currently for below examples system does not give any error as only currency has been changed but we want system to give error.

Company code (BUKRS) 1365 1365

Vendor number (LIFNR) 300000 300000

Currency (WAERS) USD EUR

Reference number (XBLNR) 334 334

Amount in document currency (WRBTR) 1000 1000

Document date (BLDAT) 15.11.2011 15.11.2011

As mentioned above if the currency is same then system throughs a error message for duplicacy. But if currency is different the system creates an duplicate invoice through MIR7.

Any suggestions how to achieve this.

Thanks,

Vikas

[nabheetscn]

We have done it in the past using a BTE Event 1110 or FI Validations for the same.

Nabheet

[Former Member]

Hi,

Can you please explain. We want system to check only XBLNR and LIFNR in this case. If both exist already system should through error message for duplicate invoice.

Thanks,

Vikas

[Former Member]

Hi friend,

I think these links will be useful for you,

<Link farm removed by moderator>

I think these links help you solving your problem or gives you an idea. If your problem still persist please revert back to me i will help you

Edited by: srihari.kumar on Dec 29, 2011 5:50 PM

Edited by: Vinod Kumar on Dec 29, 2011 11:08 PM

[Former Member]

Hi Srihari,

Thanks for your reply. Could you please suggest which approach is better BTE or FI Validations. But I am not sure where I have to do the validations. could you please suggest...

Thanks,

vikas

[nabheetscn]

I think go for FI VALIdations they are more easy and plus you do other validations later if needed where as BTE will be triggered for only one or two things but fi validations can be used always

Nabheet

[Former Member]

Hi ,

most of the time ..we use BTE for Duplicate Invoice Check.....as per my knowledge ...i think FI validation at Complete Document level is too late to put validations...

BTE = Tcode FIBF..

regards

Prabhu

[madhu_vadlamani]

Hi Vikas,

Please check there is a wiki available in sdn on this.Please check that else post.

Regards,

Madhu.

[Former Member]

Hi Madhu,

Could you please provide me the link to wiki. I am not able to find any wiki duplicate invoice check.

Thanks,

Vikas

[nabheetscn]

<<linkfarm removed by moderator>>

Please Check these

Nabehet

Edited by: kishan P on Dec 30, 2011 1:55 PM