Approval Terms Query: Activate for PO's for specific BP's only
I would like to create an approval term like this:
Launch approval when PO document total is between 5,000 and 10,000 for the following business partners (V1022,V1256,V1644) etc.
All other BP's would not require approval assuming this is the only approval template created.
Select Distinct 'TRUE' FROM OPOR A
Where $[OPOR.CardCode] in ('V1022','V1256','V1644') and $[OPOR.DocTotal.number]>=5000 and $[OPOR.DocTotal.number]<=10000