ITEMNO and ITEM don't match 1

[NeilLDK]

Hi

I am trying to link ITEMNO in ICITEM table with OEINVD.ITEM however I'm not getting any results because I have dashes in ITEM and no dashes in ITEMNO.

I think this is the normal way of linking these tables but is there a way of getting around this problem?
Maybe another field to link on or another table to use?

Any help would be greatly appreciated.
Thanks
Neil

 

[Jay Converse]

ICITEM.FMTITEMNO

 

[NeilLDK]

Perfect
Thanks
Neil

 

[DjangMan]

In general, tables that are used to display data on the screen or on reports the Item field is formatted. If the table is used internally then typically the Item field is the unformatted version.