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.
Solved
Duplicate Vendor in Vendor generic inquiry
+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.~
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.