Skip to main content
Solved

How to link document (SO/PO/etc) to EPApproval table to get doc approval date

  • 1 September 2021
  • 3 replies
  • 501 views

hayleehicks
Varsity I
Forum|alt.badge.img

I’m looking for any insight into how best to get the approval date for a document. I’m currently working on getting the approval date for a PO, but I would think it would be the same for an SO eventually. Approved date looks to be in the EPApproval table, and I’m not sure how to link the PO to the EPApproval table to grab the approval date for the document. There is a refNoteID field in EPApproval that contains the po type and po number in the same field, and I can’t get it to link to that field. Anyone successfully pulled approval date before and can share how? Thanks!

Best answer by Naveen Boga

Hi @hayleehicks18  
Use the DAC EPApproval and join based on RefNoteID with NoteID field in POOrder DAC.

 

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

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • Answer
  • September 1, 2021

Hi @hayleehicks18  
Use the DAC EPApproval and join based on RefNoteID with NoteID field in POOrder DAC.

 


Forum|alt.badge.img
  • Varsity I
  • 67 replies
  • April 4, 2022

I’m using this functionality to create a list of approvals for Sales Orders. My query is as follows:

 

When I filter on type “QT”, I’m only getting 5 approved sales order quotes:

 

 

But in reality there are 14 approved quotes:

 

 

Is there a more reliable way to get this data?

 


Forum|alt.badge.img
  • Varsity I
  • 67 replies
  • April 5, 2022

Replying to myself :-) but this information will be useful to others. I created an inquiry to help me understand this better.

The EPApproval record gets created once a record is awaiting approval and the ApprovedByID is populated once the approval has happened.  So the existence of the record on it’s own is not proof that an approval has taken place.

Also - very NB.  If a document goes back on hold, it will need to be approved again.  In that case, you want to find the last approval record (because it can be approved more than once) and make sure the approved boolean is true.

This formula will show you if the document is approved or not, and by who:

= IIf((len([EPApproval.ApprovedByID_description]) > 0) and [SOOrder.Approved],[EPApproval.ApprovedByID_description],'NOT APPROVED!')


Reply


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