This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

SuiteScript 2.0:
```search.lookupFields({
type: 'employee',
id: intInternalId,
columns: ['entityid', 'custentity_checkboxa']
});```
Getting an `SSS_INVALID_SRCH_COL` when the column is a custom checkbox field.

Any idea why?

`This API cannot be used on a field unless the value is stored in the database. To prevent this error the Store Value option should be checked. To verify if the option is checked complete the following steps:
• Navigate to  Customization &gt; Lists, Records &amp; Fields &gt; Select the field type you wish to edit (Entity, Item, CRM, etc.)
• Search for the field and view it.
• Search the “Store Value” option and ensure that it is checked.
 
Note that this error is also returned when the field is not supported or not documented in SuiteScript Records Browser.`

Hi <@U61TENRBJ>, it is customized field and marked as Stored Value.

One thing, it has access limit.

how are executing script and which role you using to execute as

Client script: Tried using SEARCH.create and SEARCH.lookupFields

Role is CB Payroll. If using Admin, it works.

Permission issues. But if this persists, might use Suitelet as backend instead.

Can you check that roles has suitescript access

Added a Suitescript permission to the role. Let me check.