Skip to main content

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.

Hi, can you try the below code:

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

I hope it helps.


Reply