Can the same vendor contact (email address) be associated with two different vendors?

Albert12
Kilo Contributor

Hi All,

I wanted to confirm that it is not possible to have the same contact associated with multiple vendors.   Based on my understanding and testing of the system, it appears that only a 1-to-1 relationship is allowed.

I see that when looking at a vendor contact, updating the vendor field will replace the existing vendor that the contact is linked to. There isn't an option to select multiple.

Additionally, when trying to add an existing vendor contact to a second vendor , as the system automatically chooses the email address as the username, it provides the following error:

1) java.sql.BatchUpdateException: Duplicate entry 'person@company.com' for key 'sys_user_u'

2) Invalid Insert

For example, I wouldn't be able to add jon.snow@targaryen.com (user/contact) to both Winterfell (company1) and KingsLanding (company2).

If anyone can confirm this, I'd appreciate it.

Thanks,

Albert Chen

1 ACCEPTED SOLUTION

Ashik3
Tera Expert

Hi Albert,

 

I tried this. It's one to one.

BR,
Ashik

View solution in original post

3 REPLIES 3

Community Alums
Not applicable

That is correct.  One to one only.

Ashik3
Tera Expert

Hi Albert,

 

I tried this. It's one to one.

BR,
Ashik

Amarjeet Pal
Kilo Sage
Kilo Sage

Hello Albert,

 

Did you figure out any way to add vendor contact to multiple vendors.

Appreciate for your inputs !!

Thanks,

Amarjeet Pal