Duplicate Vendor records

(0) Share

Report

Posted on by Julie Bernard

230

I need to clean up my Vendors. I have duplicate Vendors and need to remove transaction history from one Vendor. That is documentation and easy to understand, what I am having trouble finding is how to add the transaction history to the other (remaining) vendor. Can anyone assist with adding transaction history?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Bill Campbell 12 on at

Like (0)

Report

RE: Duplicate Vendor records

Leslie, you are correct - I was just running on auto pilot - Julie, can you go back to my comment above and remove the tag for 'answered question'

I was actually just inquiring and clicked the 'suggested answer' button in error.

Was this reply helpful? Yes No
Julie Bernard 230 on at

Like (0)

Report

RE: Duplicate Vendor records

Thank you.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

RE: Duplicate Vendor records

Bill,

I don't understand why this is considered a 'Suggested Answer' to Julie's question. This kind of thing has happened quite a bit lately and I'm curious as to why it was marked.

Kind regards,

Leslie

Was this reply helpful? Yes No
Suggested answer

Bill Campbell 12 on at

Like (0)

Report

RE: Duplicate Vendor records

Julie, has this been resolved? If not do you require more assistance - feel free to reach out and ask.

If you are done with the case, you might mark one of the answers provided as the solution.

Was this reply helpful? Yes No
Julie Bernard 230 on at

Like (0)

Report

RE: Duplicate Vendor records

Thank you. I am getting that installed in my GP2010 system.

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Duplicate Vendor records

In case you have already detected the duplicated vendors, then you can proceed to use the "vendor combiner" utility to merge vendor transaction and summary records. I have previously analyzed the Process of this utility for the customer (which is the same), here is the link Customer Combiner Utility

If you have not detected the duplicated vendors yet, you might need to consider data cleansing tools such as SQL Data Quality services.

Let us know if you need any further assistance,

Was this reply helpful? Yes No
Tim W 2,925 on at

Like (0)

Report

RE: Duplicate Vendor records

This is handled best with the Vendor Combiner feature of GP. Depending on version this is either part of the product (2013 anyway) or available as an add on from the professional tool suite.

In 2013 it's Tools -> Utilities -> Purchasing -> Vendor Combiner and Modifier

Was this reply helpful? Yes No