Skip to main content
Solved

List of Transaction (Pending for Workgroup Approval)

  • May 7, 2025
  • 9 replies
  • 171 views
  • Translate All

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)

 

 

 

View original

9 replies

Dipak Nilkanth
Pro III
Forum|alt.badge.img+14

Hi ​@Fie,

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

Translate

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!

 

Translate

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.

 

 

 

Translate

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!

Translate

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!

Translate

ricoybanez
Jr Varsity III
Forum|alt.badge.img+5

​@Fie 

Are you looking something like this?

 

Translate

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

Hi ​@ricoybanez

Yes, that's right

 

 

Translate

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

​@Fie 

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

 

 

 

Translate

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

I’ll try this. Thanks!

Translate