Not allowing Vendor Name to be same for any vendor in Vendor Card

(0) Share

Report

Posted on by riya patel

Hello Experts,

we have a requirement for not allowing same vendor name for any vendor in vendor card in business central. what is the best way to achieve that?

Any help would be appreciated.

Thanks.

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

JAngle 119 on at

Like (0)

Report

RE: Not allowing Vendor Name to be same for any vendor in Vendor Card

With a modification. The OnValidate of the field will need altering so it runs a procedure to check the name value against all other records. I’m sure your Microsoft partner can help with this requirement.

Alternative would be to control onboarding outside of BC. I have clients who use a Microsoft Form and it then goes through an approval process with power automate. A name check could form part of that. On approved data gets into BC

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,043 Moderator on at

Like (0)

Report

RE: Not allowing Vendor Name to be same for any vendor in Vendor Card

Is there really a business need for this? You now have functionality to merge vendors if someone by accident should create any doublets.

And using some kind of company registration no. would be a better way to avoid doublets. People can type the "same" name in lots of various ways.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 92,764 Super User 2025 Season 2 on at

Like (0)

Report

RE: Not allowing Vendor Name to be same for any vendor in Vendor Card

Hi, Vendor Name is not a primary key, so the standard cannot do this.
Unless you put the Vendor Name directly in the No., but I don't think the length is enough, so this may require a little customization.

When you enter a new Vendor Name, or modify the Vendor Name, search all the vendor lists, if there are duplicates, it will prompt an error.

A simple example:

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
riya patel 82 on at

Like (0)

Report

RE: Not allowing Vendor Name to be same for any vendor in Vendor Card

Thank You,

YUN ZHU

I was thinking the same but was bit confused if this was right approach

Was this reply helpful? Yes No
riya patel 82 on at

Like (0)

Report

RE: Not allowing Vendor Name to be same for any vendor in Vendor Card

Thank you,

Josh Anglesea

We will go with modification on onvalidate of the field

Was this reply helpful? Yes No
riya patel 82 on at

Like (0)

Report

RE: Not allowing Vendor Name to be same for any vendor in Vendor Card

Thank you Inge M. Bruvik for the reply ,Yes the customer wants to have that customized functionality

Was this reply helpful? Yes No