Menu
GP

Tip: Vendor Combiner & Modifier in Microsoft Dynamics GP

In some cases, there is a need to combine two vendors into a single vendor. For instance, if two vendors were set up independently but should only be a single vendor, and both have open or historical documents.

Additionally, you may want to rename a vendor to streamline your vendor list or correct a typo.

With the Vendor Combiner and Modifier Utility, you can perform these functions.

As with any master record manipulation, it’s recommended to have a restorable backup of the company database before making any changes.

Combiner

In the purchasing area page, under utilities, open Vendor Combiner and Modifier.

 

Vendor Combiner

 

Make sure the Vendor Combiner button is selected.

You will notice there is a field for an import file, you can use this if you are doing mass changes. Otherwise, you can select a Source Vendor ID and Destination Vendor ID. 

  • Source Vendor ID – This Vendor ID is removed from the system after the process is run and all records from this vendor will be combined into the Destination Vendor ID.
  • Destination Vendor ID – This is the Vendor ID that the records will be combined into and will remain in GP going forward.

You can select just one Source and Destination Vendor at a time, or you can run multiple at a time using the scrolling window.

 

Vendor Combiner

 

When the process is finished, you have the option of keeping a Report of the changes that were made for reference.

As previously mentioned, if you need to combine a large set of vendors, you can use the import file function.

The first thing you will need to do is create a two column Excel sheet with the first column being the Source Vendor ID, and the second column being the Destination Vendor ID. Save this file as a .CSV file.

In the Vendor Combiner and Modifier window, select the Import File folder, and browse to your .CSV file. When it’s selected, Validate the file.

 

Vendor Combiner

 

The Validate button will verify the following:

  • Each source vendor exists in GP
  • Each destination vendor exists in GP
  • The same vendor is not set as both source and destination
  • The same currency ID is assigned to both source and destination vendors

If the file passes the validation, you will get a popup to verify it was successful.

 

Vendor Combiner

 

Choose process, and the file will process in GP and print out a report for reference.

Search in All Title Contents
2018 Dec  9  5
2018 Nov  34  7
2018 Oct  45  4
2018 Sep  36  3
2018 Aug  48  5
2018 Jul  19  5
2018 Jun  48  6
2018 May  33  5
2018 Apr  315  6
2018 Mar  78  7
2018 Feb  42  5
2018 Jan  101  5
2017 Dec  89  9
2017 Nov  40  6
2017 Oct  73  8
2017 Sep  31  5
2017 Aug  152  11
2017 Jul  165  9
2017 Jun  121  11
2017 May  242  10
2017 Apr  28  6
2017 Mar  295  9
2017 Feb  153  11
2017 Jan  420  11
2016 Dec  166  10
2016 Nov  132  12
2016 Oct  20  11
2016 Sep  32  15
2016 Aug  33  16
2016 Jul  28  11
2016 Jun  35  12
2016 May  30  20
2016 Apr  35  5
2016 Mar  21  10
2016 Feb  44  3
2016 Jan  6  4