Open Forum

Expand all | Collapse all

Best Tool to Merge GP Vendors?

  • 1.  Best Tool to Merge GP Vendors?

    Posted 18 days ago
    We need a tool to merge GP Vendors.
    We'd like something that is ideally 1. Easy to Use and 2. Provides tracking/audit history of the merges.
    What have you used that you recommend and are there any lessons learned you would pass along? :)

    #Functional #Admin #GP2016and2016R2
    ​​​

    ------------------------------
    Allison Briden
    Business Systems Analyst
    Energy Trust of Oregon
    Portland OR
    ------------------------------


  • 2.  RE: Best Tool to Merge GP Vendors?

    SILVER CONTRIBUTOR
    Posted 18 days ago
    There is a tool within GP for this.  Speaking from experience, this should be done in smaller batches.

    ------------------------------
    Deanne Rasmussen
    ePlanPartners
    Houston TX
    ------------------------------



  • 3.  RE: Best Tool to Merge GP Vendors?

    TOP CONTRIBUTOR
    Posted 18 days ago
    Hi Allison,

    Like Deanne said, the built in Vendor Merge in GP works great.

    Lessons:
    1. Run it on a test company
    2. Use the csv file import to Merge multiple vendors.  Each line should be    MergeFromVendorID,MergeToVendorID   with no headers in the file.
    3. The tracking/audit history doesn't really exist.  You'll get a report that basically lists the contents of the csv merge file.

    If you have any questions or problems, I'm about 1/2 north of you in Vancouver.  Just give me a yell!

    ------------------------------
    John Arnold
    Senior Software Engineer
    US Digital
    Vancouver WA
    ------------------------------



  • 4.  RE: Best Tool to Merge GP Vendors?

    Posted 17 days ago
    It's in GP > Tools > Utilities > Purchasing

    The CSV uploads work extremely well.

    One thing we have noticed is that if certain connectors don't push, pull, and reconcile often, there can be some orphaned vendor numbers in other resources that end up not referencing anything within GP.  Just a thought that might help you avoid some errors and pain, and one more thing to test.  This can happen similarly when you work in the other modules with merges or modifications.

    ------------------------------
    KEITH KOOPMANS
    Controller
    GURTLER INDUSTRIES INC
    SOUTH HOLLAND IL
    ------------------------------



  • 5.  RE: Best Tool to Merge GP Vendors?

    GOLD CONTRIBUTOR
    Posted 17 days ago
    Allison,

    You will want to verify that your ISV's are not impacted or conflicted with.  ISV's support the tool differently.  Some not at all.  As someone mentioned, try it in a test company first.

    It's a great tool.

    Chris

    ------------------------------
    Chris Donnelly
    Sr Mgr of Info Systems and Financial Reporting
    Healthmark Industries
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role