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!
Answer
How to link document (SO/PO/etc) to EPApproval table to get doc approval date
Best answer by Naveen Boga
Hi
Use the DAC EPApproval and join based on RefNoteID with NoteID field in POOrder DAC.
+19Hi
Use the DAC EPApproval and join based on RefNoteID with NoteID field in POOrder DAC.
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?
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!')
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!')
Hi Marcia, How do you achieve this in the Report Designer.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.