The filter '(xx)' is invalid - invalid expression

UKCamaroSS

Hello,

Firstly, hello - well it is my first post!

I use serial numbers for inventory items. The serial numbers contain parenthesis (), as I need to use the serial number provided by our vendors.

In the event I need to unship an order, I am unable to as I get an error message informing me of an invalid expression in the filter on the serial number field in the item ledger entry table.

Is there any way to make the use of parenthesis () workable?

Thanks,

FDickschat

If you want to filter a field for a value that contains brackets you need to put the filterstring in ''.
So don't filter for
ABC(123)EFG
but for
'ABC(123)EFG'

UKCamaroSS

FDickschat wrote:

If you want to filter a field for a value that contains brackets you need to put the filterstring in ''.
So don't filter for
ABC(123)EFG
but for
'ABC(123)EFG'

Thanks, that works.