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

UKCamaroSS
UKCamaroSS Member Posts: 3
edited 2010-12-01 in NAV/Navision Classic Client
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,

Comments

  • FDickschat
    FDickschat Member Posts: 380
    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'
    Frank Dickschat
    FD Consulting
  • UKCamaroSS
    UKCamaroSS Member Posts: 3
    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.

Categories