Fields missing from the search
Why is my custom field missing from the saved search field list?
Short answer
Because the field is marked Inactive. That one checkbox on the custom field record, labelled exactly "Inactive", removes it from the Criteria, Results and Available Filters dropdowns at the same time. Store Value is not the cause, whatever the forum threads say: with Store Value off the field is still listed in all three. Display Type = HIDDEN and Applies To do not remove it either.
Because the field is marked Inactive. That is the exact label of a checkbox on the custom field record, and ticking it removes the field from the Criteria, Results and Available Filters dropdowns simultaneously. With Inactive unticked the field is listed in all three.
Minimal reproduction
A transaction body custom field was created for this test, Free-Form Text, script id custbody_probe_h01_storeval, and deleted afterwards. Each candidate setting was then toggled one at a time with the others held at their baseline, and after every change the three field pickers on the saved search form were re-read from the form's own dropdown objects rather than by eye:
Criteria dropdown "filters", column filterfilter
Results dropdown "returnfields", column rffield
Available Filters dropdown "filterfields", column fffilter
Reading them as objects rather than scanning by eye is deliberate: a miss by eye is indistinguishable from the field being absent.
Five configurations, one variable each:
A Store Value on, Display Type NORMAL, Inactive off, Applies To Sales Order present in all three
B Store Value off present in all three
C Display Type HIDDEN present
D Inactive on absent from all three
E Applies To Journal only present
None of the five produced an error. They differ only in visibility, and only one of them changes it.
With Inactive ticked, the option count of every one of the three dropdowns fell back to exactly the count recorded before the field existed. Not approximately, exactly, on all three. That is as clean a confirmation as this kind of test gets: the field left the list and nothing else moved.
Store Value is not the answer
This is the reason the page exists. Store Value is the answer on essentially every forum thread about a missing custom field, and it is wrong. Configuration B had Store Value unticked and the field was still offered in all three dropdowns, and still fully usable: as a Results column, inside a formula, and as a Criteria filter.
What Store Value actually controls is whether the field returns anything once you have selected it, which is a different symptom with a different fix. That one has its own page in this section, on a custom field that is present in the search and blank on every row.
Display Type and Applies To are not the answer either
Both were tested individually rather than assumed away.
Setting Display Type to HIDDEN (configuration C) does not remove the field from the saved search pickers. What HIDDEN does to the record form was not measured here, only what it does to the search field list, which is nothing.
Restricting Applies To (configuration E, Journal only) does not remove it either. A field scoped to one transaction type is still offered on a generic Transaction search, because a Transaction search spans all types. Scoping the field does not scope the picker.
Presence in C and E was confirmed by scanning the rendered form for the field's label rather than by option count, so those two readings are slightly weaker than A, B and D. They are consistent, and in the same direction: the field stayed.
What else is on that record
The custom field form carries a cluster of settings that all read like they might govern searchability. Verbatim labels, read from the form itself at /app/common/custom/bodycustfield.nl:
Store Value Inactive Display Type Show In List
Global Search Search Compare Type
Default Level for Search/Reporting Level for Search/Reporting
Of these, only Store Value, Display Type and Inactive were tested, along with Applies To. The rest were left at baseline and this page makes no claim about them. The one to check is plain "Inactive".
How to tell which symptom you have
Ask one question before touching anything: is the field absent from the picker, or present in the picker and empty in the output?
Absent from the picker means Inactive. Present but blank on every row means Store Value. Two different symptoms with two different causes, and conflating them is why the forum threads go in circles.
Scope: one sandbox account on NetSuite 2026.1, Administrator role, a single purpose-made transaction body field of type Free-Form Text. The three field pickers were read from the rendered saved search form in the UI rather than from an ad hoc search, on a generic Transaction search. One field, one field type, one record type.
How this was established
1 probe run against one NetSuite 2026.1 sandbox account on the Administrator role, through the saved search UI and the SuiteScript search engine. Where this page draws a boundary around a finding, that boundary is the edge of what was actually run.
Related
- Why is my custom field in the saved search results but blank on every row?
Because Store Value is unticked on the custom field record, so there is nothing stored for the search to return. The field stays fully usable: as a results column it runs and returns empty on every row, inside a formula the same, and as a criteria filter "is empty" matched every row in the table. Nothing errors, so the report looks structurally fine and is silently empty.
- Can I use a formula as an Available Filter on a saved search?
You can select one and you can never make it work. The Available Filters sublist has four columns, Filter, Show in Filter Region, Show as Multi-Select and Label, and none of them is a formula box. Criteria has a column literally labelled Formula; Available Filters does not. The search saves anyway, with no error, carrying a filter that has no expression in it.
- How do I make a saved search public, and what is the difference between Public and the audience settings?
Tick the checkbox labelled Public on the saved search form. Internal roles and External roles control who can see it, Allow Audience to Edit controls whether they can change it, and Available for Publishing on Website is a different feature about website publication rather than internal sharing. Run Unrestricted sits next to them and decides whose permissions the search runs with.
From the blog
- NetSuite Field Explorer vs MokuBot: Two Different Questions
Field Explorer tells you what a field is called. MokuBot uses the field. An honest comparison of the two, including where Field Explorer is still the better tool.