Solved

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

  • 1 September 2021
  • 3 replies
  • 369 views

Userlevel 4
Badge

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!

icon

Best answer by Naveen Boga 1 September 2021, 21:37

View original

3 replies

Userlevel 7
Badge +17

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

 

Userlevel 4
Badge

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?

 

Userlevel 4
Badge

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


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