Fields missing from the search

Why is my custom field in the saved search results but blank on every row?

Updated
saved-searchcustom-fieldstore-valueblank-columnis-emptysilent-failure

Short answer

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.

Because Store Value is unticked on the custom field record. Nothing is being stored, so there is nothing for the search to return. The field itself is fine, it is listed, it selects, it resolves, and it hands you a column of blanks.

Minimal reproduction

A transaction body custom field, Free-Form Text, script id custbody_probe_h01_storeval, with Store Value unticked and everything else at baseline. It was then used three ways in a Transaction search:

as a Results column      runs, returns empty for every row
inside a formula         runs, returns empty for every row
as a Criteria filter     runs; "is empty" matched every row in the table

Not one of the three raised an error.

The criteria case is the dangerous one

A blank column is at least visible. A filter that matches everything is not.

Because no row has a stored value, "is empty" on that field is true for every row in the table, and the search returns the whole table. The row count that comes back looks like a real answer and the filter sits in the Criteria tab looking like it is doing work. The check is to remove the filter and see whether the count changes.

The opposite filter was not run in this test, so this page does not state what "is not empty" returns on such a field. Only "is empty" was measured, and it matched everything.

Nothing errors, which is the whole problem

A report built on an unstored field is structurally correct. The field exists, the column header carries its label, the search runs to completion. Someone reviewing the search definition sees a valid definition. Someone reviewing the output sees blanks and assumes the data is missing upstream, which sends the investigation to the wrong place entirely.

Compare it with a field name that does not resolve at all in a Results formula. That case is loud in its own way: every row comes back populated with the literal string ERROR: Field Not Found, which is a different failure with its own page in this section. Wrong, but at least it is a string you can grep the export for. An unstored field gives you nothing to grep for.

How to tell if you are affected

Open the custom field record and look at Store Value before you go looking for a data problem. If a column is blank on every single row, including rows where a value certainly ought to exist, the field is the suspect and not the data.

Then check your saved searches for that field in Criteria. Any search filtering it with "is empty" is returning everything.

If you do want the field's value in search results, Store Value has to be on. What happens to records that already existed while it was off was not tested here, so treat backfill as an open question in your own account rather than something this page has established.

The other symptom, which is not this one

If the field is not in the picker at all, this is not your problem. That is the Inactive checkbox, and Store Value has nothing to do with it. Two different symptoms with two different causes, and conflating them is why the forum threads go in circles. The page on a custom field missing from the saved search field list covers that case, including the measurement that Store Value is not the cause of it.

Scope: one sandbox account on NetSuite 2026.1, Administrator role, a single purpose-made transaction body field of type Free-Form Text on a generic Transaction search, created for the test and deleted afterwards. The three usages were run as ad hoc searches. 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 missing from the saved search field list?

    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.

  • Why does my saved search formula column say "ERROR: Field Not Found" instead of a value?

    Because the search succeeded. A field token in a Results formula did not resolve, and NetSuite writes the literal 22-character string "ERROR: Field Not Found" into the column as its value on every row. It is data, not an exception, it appears in Formula(Numeric) columns, it survives SUM, and NVL does not protect it.

  • Does wrapping a saved search formula in NVL fix the null rows in a CASE WHEN?

    No. Both versions were run and grouped, and the output was identical in every bucket, to the row. NVL turns null into 0, and 0 still fails > 0, so the row lands in the same ELSE. NVL only helps if the formula branches on the substituted value, as a first WHEN.

From the blog