Prevent duplicate vendor

[Former Member]

Hi,

Is there any efficient way to prevent the duplicate creation of vendor via FK01 or XK01? 

I know we can incorporate a system check via user exit.  However, the problem is that this check is only activated upon saving and not on the screen where user enters the vendor name and address.

Best regards.

[former_member613174]

T-CODE - OBA5

application area f2 msg 144, 145 set error but its not working on same name, address, pin code, city.

[Former Member]

This message was moderated.

[Former Member]

Hi Tan,

I hope you need some ABAP help to write some code for message creation.

Go to-

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

Here we can create the message base on if same address for vendor,VAT registration number..etc.

Hope this should help.

Thanks

SP

[former_member1203934]

Hi all

I want to create new messages i.e. to restrict vendors with same name, address, tax number, contact number etc. Further, I only have 'I' indicator active. I want to activate 'E' indicator for some restrictions particularly tax number. I am unable to find any transaction to create new messages.

Thanks

[former_member1203934]

Further, I want to restrict users to use specific format for entering registration numbers i.e. 8 digit, 13 digit. In addition, I need to edit names of fields as well i.e. i needs to replace tax number with NTN.

[narasimhulu_konnipati]

The best thing is keeping the message a error in OBA5.

Application area is F2

Message no      Message description                                     Online      Batch split

144	Vendors found with same address; check          E             E

You can also restrict to one each user by specifying the user name

Thanks

[former_member182098]

Please follow the suggestion given by Narasimhulu.

However, the system will not stop you if you are creating with, for example:

ABCD Limited

ABCD Ltd.

Then the system will not stop you in creating the duplicate vendor. It would check for exactly the same name.

Meanwhile, I would suggest, you test in your test system by trying to create duplicate vendor by using all permutations and combinations (like vendor name, address, post code etc.)