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)

Sort by

Suggested answer

JAngle 159 on at

Like (0)

Report
Copy link

Link copied!

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

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 102,932 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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

Was this reply helpful? Yes No