Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Vendor merge - need to undo it

Posted on by Microsoft Employee

client merged 2 AP vendors - wrong vendor chosen - what sql tables would be affected to undo this 'oops'

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Vendor merge - need to undo it

    Hi Deanne,

    I wholeheartedly agree with the others. If you want to convince yourself it is a job you can't win, do a search on the entire database for the merged item number and note just how many tables it's included in. Still, you will not see all of them because the related table doesn't necessarily include the item number - like the transaction distribution tables and the apply tables. Even if you could identify all of the tables, you would need some creative way to identify which transactions belong to the old vendor.

    If you do not have a backup, put in a support case - but just know that this is not a support issue, everything is working, they just picked the wrong vendor. If you can at least identify which of the outstanding transactions belong to the other vendor, you can void them or offset them and then re-enter them to the correct vendor. You can use this same method to void the historical transactions. I would not want to try this if there is an abundance of transactions that need to be split out.

    Good luck,

    Kind regards,

    Leslie

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Vendor merge - need to undo it

    Deanne,

    Kirk is right on this... Restore is pretty much the only quick way to fix this... There are so many tables involved.. It's not just the vendor master table.

  • Suggested answer
    KirkLivermont Profile Picture
    KirkLivermont 5,985 on at
    RE: Vendor merge - need to undo it

    Deanne,

    I would highly recommend not trying to fix this via the individual SQL tables. Restore the database from the backup taken before using the merge utility. If you don't have a backup open a support incident with Microsoft because this is going to be a mess to get sorted.

    Regards,

    Kirk

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans