Skip to main content
Answer

List of Transaction (Pending for Workgroup Approval)

  • May 7, 2025
  • 9 replies
  • 106 views

Forum|alt.badge.img

Hi Acu Community,

Is there documentation on creating a Generic Inquiry showing the List of Pending for Approval, specifically for Workgroup Approval?

Thank you!

Best answer by ricoybanez

@Fie 

Table
PX.Objects.RQ.RQRequest (Parent Child = noteID)
PX.Objects.EP.EPApprovalProcess+EPOwned (Child Field = refNoteID)

 

 

 

9 replies

DipakNilkanth
Pro III
Forum|alt.badge.img+13

Hi ​@Fie,

Have you checked attached DB-Approvals GI from Sales Demo data?
 


Forum|alt.badge.img
  • Author
  • May 8, 2025

Hi Nikanth,

!--startfragment>

I used this GI, but it only works with Individual Approvers.

I tried linking this GI to the Business Event, but it didn’t capture the Workgroup Approvers.

Please see the screenshot below.

!--endfragment>

 

At the document level, this warning appears.!--endfragment>!--startfragment>

 

!--startfragment>

The warning states: 'Unable to Process Approval Notification. Create Message Failed. Email Receipt should be defined.'

In my analysis, since the approver belongs to a workgroup, it should request approval from the assigned approver for that workgroup rather than the Assignee ID.

Therefore, I am seeking a Generic Inquiry that reflects which workgroup the approver belongs to.

!--endfragment>

Thank you!

 


Forum|alt.badge.img+1
  • Varsity I
  • May 8, 2025

Which kind of transactions pending approval are you looking at?

I have created a GI for a list of AP Bills pending by approval workgroup.

The one caveat to note is that by including the workgroup it will show duplicate lines for a single invoice if more than one workgroup is set to approve it at the same time.
Also note that some of the lines in the screenshots below are not active so you don’t really need them in there.

 

 

 


Forum|alt.badge.img
  • Author
  • May 9, 2025

Hi Hgilbert,

I'm looking for a Generic Inquiry that can display all approvers from the workgroup setup on the Request screens.!--endfragment>!--startfragment>

Thank you!


Forum|alt.badge.img
  • Author
  • May 12, 2025

Hi Hgilbert,

I'm looking for a Generic Inquiry to display the (workgroup approver) setup on the Purchase Request and Purchase Orders Screen.

Thanks!


ricoybanez
Jr Varsity III
Forum|alt.badge.img+3
  • Jr Varsity III
  • May 13, 2025

@Fie 

Are you looking something like this?

 


Forum|alt.badge.img
  • Author
  • May 14, 2025

Hi ​@ricoybanez

Yes, that's right

 

 


ricoybanez
Jr Varsity III
Forum|alt.badge.img+3
  • Jr Varsity III
  • Answer
  • May 14, 2025

@Fie 

Table
PX.Objects.RQ.RQRequest (Parent Child = noteID)
PX.Objects.EP.EPApprovalProcess+EPOwned (Child Field = refNoteID)

 

 

 


Forum|alt.badge.img
  • Author
  • May 14, 2025

I’ll try this. Thanks!