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

Like (0) Share

Report

Posted on 8 Feb 2017 17:27:04 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

All responses (3)

Answers (2)

Community Member on 15 Feb 2017 at 15:11:18

Like (0)

Report

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 65,271 on 10 Feb 2017 at 07:24:59

Like (1)

Report

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 1,775 on 08 Feb 2017 at 19:59:59

Like (2)

Report

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.