Fields don't show up in NetSuite Saved Search

Avatar
Hristina Bendeva
Awesome Follow-up
Engaged
Celigo University Level 4: Legendary

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

Comments

3 comments
Date Votes
  • Avatar
    Tyler Lamparter
    (Edited )
    Principal Product Manager
    Awesome Follow-up
    Engaged
    Top Contributor
    Answer Pro
    Celigo University Level 4: Legendary

    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
  • Avatar
    Hristina Bendeva
    (Edited )
    NetSuite Integration Whiz
    Awesome Follow-up
    Engaged
    Celigo University Level 4: Legendary

    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
  • Avatar
    Muneswara Thotakura
    NetSuite Integration Whiz Salesforce Integration Whiz Software Engineer
    Answer Pro
    Celigo University Level 4: Legendary

    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.

 

Didn't find what you were looking for?

New post