Has anyone encountered an error like this before: ...
# general
j
Has anyone encountered an error like this before:
Copy code
Search error occurred: Unknown identifier 'cfd228.EVALUE'. Available identifiers are: {shipaddress=AddressBook AS shipAddress, vendorbillmatching=VendorBillMatching AS vendorbillmatching, entitycurrencymap=EntityCurrencyMap AS entityCurrencyMap, entityrate=EntityRate AS EntityRate, billaddress=addressbook AS billaddress, primarycontact=SELECT [2x] FROM [1x] WHERE GROUP BY [1x], subsidiary=Subsidiary AS subsidiary, vendor=SELECT [1x] FROM [3x] WHERE, cfd5=CFDEntity AS cfd5, cfd3=CFDEntity AS cfd3, cfd4=CFDEntity AS cfd4, account=Account AS account, cfd1=CFDEntity AS cfd1, entity=Entity AS entity, cfd2=CFDEntity AS cfd2}
Suddenly started happening when trying to do some SQL calls e.g. SELECT * FROM vendor
we did just add a new field (multiselect) to vendor.
ugh. After checking Records Catalog, field was set up wrong (by NetSuite, was showing as String despite being MultiSelect Employee in UI)
netsuite 1