Skip to main content
Solved

PO Approval Notification GI

  • 11 June 2024
  • 2 replies
  • 33 views

Hey All,

I’m trying to create a generic inquiry for PO approvals. My goal is to link the GI to a business event to send to multiple approvers, owners etc. I have everything working except that the email address for the approver does not pull onto my GI. 

 

Tables:

 

Joins:

POOrder to EPApproval

 

 

 

EPApproval to Contact

Results: Email address is blank. Email is from the contact table. The contact table for the employee stores their email address. 

 

 

 

Thanks!

2 replies

craig2
Rank
Userlevel 5
Badge +1

Hey @etrojan28,

Try using using OwnerID in your EPApproval to Contact joins instead of ApprovedByID.  As you have it now, it will only pull the Email address of the Contact after it’s been approved.

Hope that helps!

E
Rank
Userlevel 3
Badge

@craig2 thanks for the speedy reply Craig. That was it. 

 

Thanks!

Reply


Terms & ConditionsCookie settings