Fields don't show up in NetSuite Saved Search

Hristina Bendeva NetSuite Integration Whiz

• February 09, 2023 14:21

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:

 

0

• 

  Tyler Lamparter Principal Product Manager

  • February 10, 2023 15:43
  • Edited

  

  

  

  

  

  Hristina Bendeva 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?

  0
• 

  Hristina Bendeva NetSuite Integration Whiz

  • February 10, 2023 16:43
  • Edited

  

  

  

  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

  0
• 

  Muneswara Thotakura NetSuite Integration Whiz Salesforce Integration Whiz Software Engineer

  • February 10, 2023 17:19

  

  

  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.
  
  

  0

Please sign in to leave a comment.