Skip to main content
Question

How would I filter out purchase orders that contain 'Record Goods Receipt'?

  • July 21, 2022
  • 1 reply
  • 2 views
.
Level 1

I currently use this load script:

FILTER MATCH_ACTIVITIES( "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN", EXCLUDING_ALL ['Record Goods Receipt'] ) = 1

 

But as far as I can tell this is only item level, so POs that have any item in which "Record Goods Receipt" doesn't occur still show up. I want to exclude any purchase order that has "Record Goods Receipt" anywhere in the process of any item in the PO.

    1 reply

    P
    Level 7
    • preethi.p12
    • Level 7
    • July 22, 2022

    Hi, can you try the below code:

    FILTER "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" NOT IN('Record Goods Receipt') ;

    I hope it helps.

    Community Code of ConductAccessibility statement