Sage 300

Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

IC Item Finder shows duplicate line for one item

Posted By Ron Boyd over 4 years ago

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

0 MusickInt over 4 years ago

Take a look at the ITEMNO compared to the FMTITEMNO field. One of them is wrong.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ron Boyd over 4 years ago in reply to MusickInt

checked ICITEM and those two fields match in value and length and I even edited them to remove everything to right in case there was a hidden tab or something.

maybe another related table has a problem - did not check that
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Ron Boyd over 4 years ago 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%'
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

IC Item Finder shows duplicate line for one item

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING