Hi there,
we got duplicate Vendor appeared in Vendor list. Not sure which generic inquiry duplicates in the relationship tab. I have exported AP vendor in xml. Could you please review and advise? Thank you.
Answer
Duplicate Vendor in Vendor generic inquiry
Best answer by ejmillar
It is like the screen shot below…..
+1There are duplicate vendors as you are linking to the contact table. Therefore if the has vendor has 3 contacts the vendor will be displayed 3 times.
You should probably amend the condition to only show the primary contact shown below.
Ewan ~ Rubech IT ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
Thanks
+1The relationship would be Vendor.PrimaryContactID=Contact.ContactID
Sorry
I looked the relationship below. I can’t find primary contact ID in the drop-down menu. Thank you.
+1It is like the screen shot below…..
Ewan ~ Rubech IT ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.