IC Item Finder shows duplicate line for one item

Have a situation where IC Item Finder (on any screen) shows 2 lines for 1 item

If I do a CONTAINS  'dill'  on Description field I get several items with one item showing 2 lines that go to same record

SQL database only shows one item, reindexed all tablesin SQL

Criteria option on finder with Description field and any part of item code only shows 1 line

Anyone ever seen a finder show duplicate line for one item, document etc.

Thanks

Parents Reply
  • 0 in reply to Ron Boyd

    something else weird  CONTAINS dill     becomes LIKE '%dil;l%'   in RVSPY but  ** why the semicolon **

    CONTAINS diss  becomes '%diss%'     ** no semicolon

    like the letter L or double L has some kind of special meaning in a like phrase for Sage300;

    but in a SQL query window

    '%dill%; works but not '%dil;l%'

Children
No Data