Has anyone been able to pull in a hidden NetSuite field from a record into a saved search when it's not available in the drop down menu? For instance, on Bill Payment records, I noticed there's a hidden NetSuite field for Cleared Date ( cleareddate ), and it doesn't allow me to pull that field into a saved search. However, if I create a custom transaction body field, I can source that Cleared Date field into it, and when viewing the record, it populates the field with the correct cleared date. But, when trying to pull in my custom transaction body field into my saved search it gives me an error message that the field is not found, I'm assuming because the field does not store value. When I store the value and default it to the formula {cleareddate} it is blank, so it returns nothing in my saved search.

I am able to do this, however, only via customization. The pattern has, basically, a writable custom field that users can’t update (“inline” on forms and restrictive permissions) and a user event script that keeps it in sync with the hidden field.

@zvictor thank you for your input, but I need to be able to search in closed periods and adding a field with data in it won't work in Closed periods. I actually have a user event script that grabs the cleared field and the cleared date and puts them in fields created by the user event script so when viewing the record, you can see if it has cleared and what the cleared date is. But, we need to be able to search through thousands of transactions. To test, I also updated that script to write to my custom body field the cleared date and store the option, when I do that, viewing the record that field is blank, running my saved search on that field is also blank. I tried removing the Store Value, now when viewing a record, the field shows up with the correct date, but running my search and pulling from that field, it is blank.

I’m not sure I fully understand the test described in the second paragraph. As an alternative (and I realize that this could be ugly), would it be possible to create a custom record that is a child of the main record? I have not tried writing to child records of transactions in a closed period: is it possible? If it is possible, then you could put the custom fields on the child record. The child record’s fields would be exposed in a saved search as a join.