Requester Syntax

Hi,

I have created a requester on Sage X3 Version 11 and I would like to filter the results, via the 'Advanced' tab 'Selections' to return results that Do Not start with 'REV' so basically the syntax of 'NOT LIKE' in SAGE X3.

Regards & Thanks

Lil

  • 0

    Hi Lil,

    Try something like:

    left$([F:XXX]XXXXXX,3)<>"REV"

    the left$(x,3) will get the first 3 characters of x

    <> will return those not equal to.

    You may find it useful to use the Formula wizard from the Selection Criteria field action. The Analyse Formula may also be useful as that explains what the formula is doing.