Skip to main content
Solved

How to get Approved Employee to the Report

  • 17 June 2024
  • 1 reply
  • 27 views

Can someone help me with the joinin to get the Approved Employee from this screen ?

I want to get the approved employee related to this Refnbr. I tried so many ways but none of it is working.

This is the joinin that im currently using in my report schema builder.

Also the dac mentioned in the inspect element of the approved employee is hidden. Therefore i am trying to get it through its base dac which is EPEmployee. Also once the record is approved the name and id goes to EPApproval dac. How can i navigate from APPayment to EPEmployee/EPApproval in order to get the approved employee name ? Please help!

1 reply

meganfriesen37
Rank
Userlevel 7
Badge +10

To link the AP Invoice to the approval record, you’ll need to join EPApproval.RefNoteID to APPayment.noteID.  Depending on the approval map, there may be multiple EPApproval records for one payment.

To link the Approval record to the Assigned Approver Employee record, you’ll need to join EPApproval.OwnerID to EPEmployee..defContactID

To link the Approval record to the Approved By Employee record, you’ll need to join EPApproval.ApprovedByID to EPEmployee.defContactID

Hope this helps.

Megan

Megan Friesen, Contego Software Solutions, Canada

Reply


Terms & ConditionsCookie settings