Skip to Content
avatar image
Former Member

configuring double invoice check for vendor invoices posted through FB60

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Feb 08, 2011 at 09:52 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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..

  • avatar image
    Former Member
    Feb 08, 2011 at 10:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 08, 2011 at 11:11 AM

    please tick "click double inv" on vendor master data

    t code FK02 and payment transaction tab in co code data

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 08, 2011 at 02:48 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 06, 2012 at 10:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded