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

image.png

This formula is not present in my search results in SS. I've got two formulas in the search and results only seem to contain the second one. Any idea why?  I also note that the Custom Label is not being pulled into the search results for the other formula.

It also looks like the quantitycommitted field, in the search, returns null (empty value) for 0 values on the transaction which is why I am defaulting it to 1 for testing. (this is a transaction search with type: sales order

I created the search in the UI and can see the quantitycommitted field is always empty, this might be something to do with it not pulling into to SS results.

I would have thought that the formula setting it to 1 would make it visible though.

On further investigate it looks like empty columns are not included in search results - this is crappy because a column could appear/disappear without notice. It's smart to null check the presence of a column in your code but I would at least expect the search result data structure to be reliable, and it looks like it's not (if my assumption about empty values not even returning the column name are right).

I'd expect an empty/null value column, not the complete removal of the column.