Hey All: I have an interesting issue. I have a query:

select ExternalID as Validation FROM item where itemid='1-1624-8-89' or DisplayName ='1-1624-8-89' or UPCCode = '1-1624-8-89'

However, it returns NULL. When I look up the item in the NetSuite UI I see that it is Item ID 590557. When I run the following query it still returns NULL,

select ExternalID as Validation FROM item where id  = '590557'

. The item url is

app/common/item/item.nl?id=590557

. I am at a loss here why it's returning a NULL, when by all angles it should be returning the correct item. Any assistance is appreciated! TIA 🙂

@Alli Deacon The ID column is numeric, so maybe that's the issue? Try this:

SELECT ExternalID AS Validation FROM Item WHERE ID = 36315

@tdietrich thanks Tim, it seems on this record there is no External ID, when doing a select * on it externalid = null, and in the xml view of the item in the UI the external id isn't listed.