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!
Best answer by craig2
Hey
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!
+3Hey
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
