topic Re: Duplicate Invoice check issue in Application Development and Automation Discussions

Duplicate Invoice check issue

Former Member — Thu, 29 Dec 2011 11:30:05 GMT

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

Re: Duplicate Invoice check issue

nabheetscn — Thu, 29 Dec 2011 11:43:06 GMT

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

Nabheet

Re: Duplicate Invoice check issue

Former Member — Thu, 29 Dec 2011 11:53:22 GMT

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

Re: Duplicate Invoice check issue

Former Member — Thu, 29 Dec 2011 12:20:07 GMT

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

Re: Duplicate Invoice check issue

Former Member — Thu, 29 Dec 2011 14:14:16 GMT

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

Re: Duplicate Invoice check issue

nabheetscn — Thu, 29 Dec 2011 14:45:15 GMT

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

Re: Duplicate Invoice check issue

Former Member — Fri, 30 Dec 2011 01:31:33 GMT

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

Re: Duplicate Invoice check issue

madhu_vadlamani — Fri, 30 Dec 2011 02:45:17 GMT

Hi Vikas,

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

Regards,

Madhu.

Re: Duplicate Invoice check issue

Former Member — Fri, 30 Dec 2011 08:00:49 GMT

Hi Madhu,

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

Thanks,

Vikas

Re: Duplicate Invoice check issue

nabheetscn — Fri, 30 Dec 2011 08:05:14 GMT

<<linkfarm removed by moderator>>

Please Check these

Nabehet

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