Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Is there a way to push...
Microsoft Dynamics GP (Archived)

Is there a way to push address updates from Customer to Vendor when Customer/Vendor relationship exists?

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

In this case, the Vendor is really the same as the customer.  However, the customers get paid out in cash prizes for which they need to report via 1099.  The Customer/Vendor relationships were created and have been in place.  But, when the Customer address is updated, it does not update the vendor address and 1099s are mailed to the wrong address.

Is there a way when the Customer address is updated to push this to Vendor card to update the address at the same time?

Thanks.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Is there a way to push address updates from Customer to Vendor when Customer/Vendor relationship exists?

    Thank you!  These response have been very helpful.

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Is there a way to push address updates from Customer to Vendor when Customer/Vendor relationship exists?

    If you want it to update automatically, you'll want to do it using a SQL update trigger on those customers/vendors found in the relationship setup table.

    Kind regards,

    Leslie

  • Verified answer
    26P2ER Profile Picture
    26P2ER 1,773 on at
    RE: Is there a way to push address updates from Customer to Vendor when Customer/Vendor relationship exists?

    Hello Valerie:

    This can be accomplished from the Customer/Vendor Relationships window found under Sales|Cards|Customer/Vendor,

    After you update the address of a given customer, you click on the create vendor button that can be found at the bottom and click on continue at the "The ID already exists, choose Continue to update the existing record;choose cancel to enter a new ID".

    I am able to do this with GP 2010 SP1 (long overdue for an upgrade, I know.) and with GP 2016 RTM.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans