topic Re: Regarding invoice Duplication in Application Development and Automation Discussions

Regarding invoice Duplication

Former Member — Tue, 11 Sep 2007 06:04:15 GMT

Hi All,

Got struck with a issue. please help me out in this. I need to check the duplication of invoice when i post a document in F-42. It also a country specific as well. so can anyone pls suggest me which method i can use and how to use it. I appericiate if u can guide me with some sample codes.

Thanks

Sathish

Re: Regarding invoice Duplication

Former Member — Tue, 11 Sep 2007 06:15:45 GMT

Hi Sathish

There are some configuration in FI Module (IMG->Set Check for Duplicate Invoices)that checking the duplicated invoice or not but you can use the same method to clarify the invoice is exist or not by

checking this condition in your program , if there are the same below condition in two document , you can pop up the message.

1. Companya Code

2.Invoice Date

3. Reference.

4. G/L Account Customer or Vendor

5.Amount in G/L Account Customer or Vendor

if you have any question ,please let me know.

Regards

Wiboon

Message was edited by:

Wiboon Chaiyabutsakul

Re: Regarding invoice Duplication

Former Member — Tue, 11 Sep 2007 06:24:42 GMT

Hi,

In my program inocence i dont get it. Can u pls be more clear. Since its a standard transaction we need to implement user exit for it? so ur asking me to check those conditions in the user exit program? If thats the case can u pls guide me where i have to implement the user exit? or is that enough if i just do the configuration in IMG.

Thanks

Sathish

Re: Regarding invoice Duplication

Former Member — Tue, 11 Sep 2007 06:45:42 GMT

Dear Sathish Kumar

you have two way to do for this requirement .

First : IMG : Validation in Accounting Documents (T Code : OB28) or substitution ( Tcode : OBBH )

I will explain about substitution.

in the configuration , you can create substiution for your company code after that

you will see sub tree

- Document header

- Line item

- Complete Document

That are a trigger , for example if you create substitution in Document header , system will check when you entry data in Document header or If you create substituion in Line item , system will check after you entry data in line item.

If your requirement is checking duplicate invoice , you have a condition which identify that the new invoice is duplicate .

For example the differenet document should be the different reference.

and the doc date should be different too.

in substitution you can use exit .

Coding like this

select XBLNR into v_XBLNR from bsis where bukrs = 'CXXX' and budat = '20070805'

if v_xblnr = bseg-xblnr.

......" Do anything that you would like

endif.

Regards

Wiboon

Re: Regarding invoice Duplication

Former Member — Tue, 11 Sep 2007 07:02:36 GMT

Thanks a lot Wiboon will try wht u suggested me and will get back to u if i stuck some where. Once again thanks for your kind help.

Regards

Sathish