Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Duplicate Invoice check issue

Former Member

‎2011 Dec 29 11:30 AM

0 Likes
1,431

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

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

Reply
9 REPLIES 9
Read only

nabheetscn
SAP Champion
SAP Champion

‎2011 Dec 29 11:43 AM

0 Likes
1,352

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

Nabheet

Read only

Former Member
In response to nabheetscn

‎2011 Dec 29 11:53 AM

0 Likes
1,352

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

Read only

Former Member
In response to nabheetscn

‎2011 Dec 29 12:20 PM

0 Likes
1,352

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

Read only

Former Member
In response to nabheetscn

‎2011 Dec 29 2:14 PM

0 Likes
1,352

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

Read only

nabheetscn
SAP Champion
SAP Champion
In response to nabheetscn

‎2011 Dec 29 2:45 PM

0 Likes
1,352

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

Read only

Former Member
In response to nabheetscn

‎2011 Dec 30 1:31 AM

0 Likes
1,352

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

Read only

madhu_vadlamani
Active Contributor

‎2011 Dec 30 2:45 AM

0 Likes
1,352

Hi Vikas,

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

Regards,

Madhu.

Read only

Former Member
In response to madhu_vadlamani

‎2011 Dec 30 8:00 AM

0 Likes
1,352

Hi Madhu,

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

Thanks,

Vikas

Read only

nabheetscn
SAP Champion
SAP Champion
In response to madhu_vadlamani

‎2011 Dec 30 8:05 AM

0 Likes
1,352

<<linkfarm removed by moderator>>

Please Check these

Nabehet

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