>So if the field and index name of the primary index is- itemcode -then the index should be- itemcode + not deleted()?

You can add the ".NOT. DELETED()" to the index by modifying the table structure. If you can also create the index by using the INDEX command:

INDEX ON itemcode TAG itemcode FOR .NOT. DELETED()

I'm pretty sure that'll work. If not, experiment...