Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

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 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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans