configuring double invoice check for vendor invoices posted through FB60

[Former Member]

Dear all

Can anyone tell me how to configure double invoice check for vendor invoices posted through FB60.

for miro documents..we can use Tcode OMRDC

Is there any such tcode which can be used for configuring fi invoices for double checking..

regards

Expertia

[Former Member]

hi

you can avoid duplicate invoice check control in SAP.

An information message will be shown to user when he is creating Vendor master data which will inform him that Vendors already exist with the same data in address fields. Then the Vendors with the same address will be displayed to the user. From here if he selects continue button he will be allowed to create the Vendor, if he selects the cancel button he will be given the option of making changes to the address fields.

Configuration Steps:

Goto SPRO: SAP Reference IMG:

1. Financial Accounting(New)->Accounts Receivable and Accounts Payable->Vendor Accounts->Master Data->Preparations for Creating Vendor Master Data->Change Message Control for Vendor Master Data

2. The following screen will be displayed where you can define your message for Ex:

add message no 144 i i for both online and batch

add message no 272 i i for both online and batch

after that SPRO -> MM -> Logistics Invoice Verification --> Incoming invoice --> Set check for duplicate invoice.

If you want to make this check user specific then enter the User Name else leave it blank to make it applicable for all users.

This should resolve your query

Kind regards

Arman

SAP FICO

[former_member192897]

1. If a reference document number is given in the current invoice or credit memo, then the system checks for previously posted invoices or credit memos in Financial Accounting that match all the following attributes:

Company code

Vendor

Currency

Document date

Reference document number

2. If no reference document number is given in the current invoice or credit memo, then the system checks for previously posted invoices or credit memos that match all the following attributes:

Company code

Vendor

Currency

Document date

Amount in document currency

[former_member205946]

please tick "click double inv" on vendor master data

t code FK02 and payment transaction tab in co code data

[Former Member]

Hi Expertia,

In addition to what Mauri has mentioned, i would just like to add that, if at all you have your requirement anything other than the standard for Duplicate Invoice Check, then If you are referring to FI invoices, then you may have to activate BTE 1110 by creating your own Z function module (by copying FM SAMPLE_PROCESS_00001110).

Regards,

SAPFICO

[former_member207607]

Dear Expertia,

In FI,when checking for duplicated invoices, the system compares the

following :Vendor, currency, company code, gross amount of the invoice,

reference document number and Invoice document date.

SAP Note 305201 clarifies this in a more details; please read it.

The following fields must be identical for Duplicate invoice check

Company code (BUKRS)

Vendor number (LIFNR)

Currency (WAERS)

Reference number (XBLNR)

Amount in document currency (WRBTR)

Document date (BLDAT)

If the document is having any one of the above filed different then the

system does not consider it as a duplicate invoice.

Also It will check duplicate invoice check in vendor master data and

in posting key is there check box selected for sales related

The setting you making in OMRDC i.e Materials management->Logistics

Invoice Verification->Incoming Invoice ->Set Check for Duplicate

Invoices is only valid for MM and not FI invoices posted via FB60/FB65

You should check the F1 help on field "Chk double inv." (LFB1-REPRF)

in the relevant vendor master record (transaction FK03).

Please also check, that message F5 117 has been set correctly in the

IMG using this path:

Financial Accounting -> Financial Accounting Global Settings ->

Document -> Default Values for Document Processing -> Change Message

Control for Document Control For Document Processing

Finally & mainly, go to the relevant posting key is defined as sales

related in transaction OB41. You have to flag this field if the

duplicate invoice check should work.

I hope this helps You.

mauri

[Former Member]

Dear Friends

Thanks for your replies..

But my problem is system is checking duplicate invoices for all vendors except 1-2 vendors..

I have checked the master data of that vendors..check double invoice is tick there..

I m not able to figure our where actually the error lies with those particular vendors..

Any suggessions How to trace this..

Regards

Expertia..