PSTL Vendor Combiner

(0) Share

Report

Posted on by cynthia dappah

1,065

Is PSTL the best tool to use to combine vendors? When you run the "Vendor Combiner" tool you enter the "Starting Vendor ID" and the "Combine into Vendor ID" but the "Combine into Vendor ID" is what is kept right?

Also the history in the "Starting Vendor ID" will be added to the ID in "Combine into Vendor ID" right?

Thanks for your responds.

*This post is locked for comments

I have the same question (0)

All responses (27)

Answers (1)

Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Cynthia,

yes you are correct please take a backup before doing the Vendor Combining. Please refer the following from isolutions describing the steps.

www.isolutionspartners.com/gp-2013-r2-vendor-combiner-and-modifier

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

Cynthia

You are right, the starting vendor will be removed while its associated data will be linked to the vendor on the "Combined to" field. The manual is always a must-read in such case.

I have once analyzed the combine process for the "customers" from a technical perspective on Customer Combiner Utility . For the vendors, the combine process is similar.

Let us know if you need any further assistance,

Was this reply helpful? Yes No
Suggested answer

Ian Grieve 22,784 on at

Like (0)

Report

The above responses are correct, but please ensure you have a good backup before combining any vendors and check the results afterwards.

It is also worth considering any third party add-ons you may have for GP and verifying their tables afterwards as you may need to change any fields holding the vendor id manually.

Was this reply helpful? Yes No
Suggested answer

Tom Cruse 1,477 on at

Like (0)

Report

Cynthia,

Babu and Mahmoud are right. One thing that you might want to make a note of are the mailing addresses for the 'source vendor' because the information for this vendor will no longer be available after it's combined so if you're maintaining a fairly large list of mailing addresses under that particular vendor you'll want to add those to the destination vendor prior so you don't forget because these do not move to the new vendor.

Wireless carriers and utility companies would be a good example of this.

Regards,

Tom Cruse

Was this reply helpful? Yes No
cynthia dappah 1,065 on at

Like (0)

Report

Thanks Everyone very good information.

I have about 200 vendors to combined. I am testing about four vendors at a time to see how the process works. The PSTL document does not give you how to prepare the text file. do you need a header? All the Vendors exist in GP am not modifying any names. I am combining the "Starting Vendor ID to the" Combine ID". When I do this manually it works but not the .txt file. I receive and error and the validation error have nothing in it.

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Cynthia,

if you receive report with no error mean data is fine. Please use a CSV with 2 column source vendor id and destination vendor id with no header file which supported by GP.

Was this reply helpful? Yes No
cynthia dappah 1,065 on at

Like (0)

Report

Babu,

I saved the excel file as .csv file with two columns. First column is the starting vendor ID and the second column is the Combine ID. Please note that I am on GP 10 if that means anything. I received an error that "source and destination vendor not found" Also, both vendors ID's appeared in one column on error report.

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Cynthia,

For GP 10 please save the file as text only and just put only one source and vendor id on two column and validate it. Just for sure please check whether both vendor are active.

Was this reply helpful? Yes No
cynthia dappah 1,065 on at

Like (0)

Report

Babu,

Using a .txt file I receive Invalid Vendors report with nothing in error description

Was this reply helpful? Yes No
Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Cynthia,

Can you please confirm that no header on the text file and please try a source and destination a different vendor.

Was this reply helpful? Yes No