Wildcards

[samij]

Hi,

I added the criteria AUDIT_SPLIT.DETAILS to the Supplier Activity report, so for example I can filter only "payments on account".

At the moment when entering the criteria i have to enter [Details IS "payments on account"] to list only the payments on account, but can I use wildcards to enter just "payments" for example ?

Thanks,
Sam

[brucedenney]

The answer to your question is

Code: Select all

Contains(AUDIT_SPLIT.DETAILS, "Payment")

BUT

The text in the details does on a payment on account or a purchase payment does not have to contain the word "payment" it can have anything in it.

There is a better way and that is to use the Transaction Type field in the header this is 100% reliable.

The Transaction type wants to be "PP" or "PA" to list all your payments.
This sort of comparison is also less hard work for the computer, so should run a bit faster.

The filter would be

Code: Select all

AUDIT_HEADER.TYPE = "PP" OR AUDIT_HEADER.TYPE = "PA"