Fields don't show up in NetSuite Saved Search

[hristinabendeva]

Hi,

I'm trying to create a saved search in NetSuite and I need to show specific fields in the search but I can't access them, how can I access these fields and show them in the results of the saved search?

Here are the fields that don't show up in the Saved Search:

[tylerlamparter]

@hristinabendeva what does your saved search criteria and results look like? What record type is this for? Maybe you have main line = true which is filtering out line level data?

[hristinabendeva]

Hi Tyler,

I have found the fields since they are custom fields they were named differently on display and in the search filter.

Now I have another blocker where I'm trying to use a formula where I compare 2 date fields if one is bigger then the other then I need to show those orders and the formula works in the results tab but not in the criteria tab do you know why?

Here is the formula that I'm using:

case when TO_CHAR({date1}, 'MM/DD/YYYY') > TO_CHAR({date2}, 'MM/DD/YYYY') then 1 else 0 end

[muneswarathotakura]

Hi Hristina Bendeva,
Did you configure it as per the below criteria condition? It's working for me, but I don't see any issue with your formula.