Skip to main content
Answer

Remit to Email contact relationship to Vendor

  • January 30, 2024
  • 2 replies
  • 297 views

dsimmerly
Pro I
Forum|alt.badge.img+1

What is the correct GI Relations of Vendor and Contact to see the Remit Contact email shown below ?

(this is 23R1)

 

Best answer by jharris

  

What is the correct GI Relations of Vendor and Contact to see the Remit Contact email shown below ?

(this is 23R1)

 

Adding the Contact table to my Vendors GI, I was able to pull the Email using the following join and relation:
 

This gave me the ability to add the email field from the Contact Table.  However, this is a shared business logic and pulls the email from the vendor details tab.  If you don’t override this email, it will likely be the same as the payment tab.  I haven’t tested to see if it makes a difference yet on whether you need to use the location table for the payment tab’s email when the override checkbox is selected and a different email is entered.

 

2 replies

Forum|alt.badge.img+1
  • Varsity I
  • January 30, 2024

Hi @dsimmerly 

I added the Contact table to the Vendor Location GI in my instance of Acumatica and was able to pull in the Email Address from the Payment tab.

 

 

Hope this helps!

 

Sarah


jharris
Semi-Pro I
Forum|alt.badge.img+7
  • Semi-Pro I
  • Answer
  • February 6, 2024

  

What is the correct GI Relations of Vendor and Contact to see the Remit Contact email shown below ?

(this is 23R1)

 

Adding the Contact table to my Vendors GI, I was able to pull the Email using the following join and relation:
 

This gave me the ability to add the email field from the Contact Table.  However, this is a shared business logic and pulls the email from the vendor details tab.  If you don’t override this email, it will likely be the same as the payment tab.  I haven’t tested to see if it makes a difference yet on whether you need to use the location table for the payment tab’s email when the override checkbox is selected and a different email is entered.