Skip to main content
Solved

Acumatica Report Designer - how to display the Purchase Order along with the last person who approved it?

R
Freshman II
Forum|alt.badge.img

I need to display Purchase Order approved and the last person who approved the PO.

In a GI or SQL it is simple to return the data for this as an Aggregated value Max on the ApproveDate.

 

The table relationships: EPApproval Table and link it to POOrder using RefNoteID = POOrder.NoteID.

How can this be achieved on the Report designer? Where will the Filter be applied?

Retha

Best answer by ricoybanez

​@rethavanalphen11 

Hi, try using this on the condition:

=MAX([EPApproval.ApprovedDate])

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

2 replies

ricoybanez
Jr Varsity III
Forum|alt.badge.img+1
  • ricoybanez
  • Jr Varsity III
  • 43 replies
  • Answer
  • March 10, 2025

​@rethavanalphen11 

Hi, try using this on the condition:

=MAX([EPApproval.ApprovedDate])

Rico P. Ybanez
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
A
Jr Varsity I
Forum|alt.badge.img

Hi @rethavanalphen11,

 

  1. 1. Add the POOrder and EPApproval table and join them on POOrder.NoteID = EPApproval.RefNoteID.
  2. Group by POOrder.OrderNbr.
  3. Get the Latest Approval Date:In the Sorting and Grouping section of the Report Designer, sort EPApproval.ApproveDate in descending order.
  4. Add EPApproval.ApproveDate and EPApproval.ApprovedByID to the report layout.

Hope, it helps!

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett

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