Skip to main content
Question

Identify User where the person who created order is same as one who approved .

  • Mar 30, 2023 7:04 AM UTC
  • 2 replies
  • 97 views

Dear Experts , Can you suggest right way to find list of violation users who not only created Purchase order but also approved purchase orders. ?

 

2 replies

mukesh.gupta11
Level 7
Forum|alt.badge.img+15

Assuming that User information is availble in activity tabel:

 

COUNT(CASE WHEN PU_FIRST (EKPO, ACTIVITY.USER_NAME, ACTIVITY.ACTIVITYNAME = 'Created Purchase Order') =

PU_FIRST (EKPO, ACTIVITY.USER_NAME, ACTIVITY.ACTIVITYNAME = 'Approved Purchase Order') THEN EKPO.CASE_KEY END )

 

It will return #number of PO items Created and Approved by same user.


  • Mar 30, 2023 12:14 PM UTC

That makes sense , Thank you Mukesh , much appreciated.