Skip to main content
Solved

How to get Approved Employee to the Report

  • June 17, 2024
  • 1 reply
  • 54 views
I
Freshman I
Forum|alt.badge.img

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!

Best answer by meganfriesen37

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

View original
Did this topic help you find an answer to your question?

1 reply

meganfriesen37
Captain II
Forum|alt.badge.img+11

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
Laura02
Chris Hackett
I
3 people like this
  • Laura02
    Laura02
  • Chris Hackett
    Chris Hackett
  • I
    ifelix

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved