Stack Overflow
Stack Overflow

Questions tagged [saved-searches]

193 questions
1
vote
2 answers

NetSuite Saved Search where {location} = {user.location}?

This seems like it should be simple, but for some reason I can't get this to work... I am trying to build a transaction saved search that shows the user (person viewing the search) all transfer orders that have their location in either the…
Cody Schram
  • 19
  • 6
1
vote
1 answer

Inserting Characters into NetSuite Saved Search Results Column

I'm trying to find a way to insert line breaks into certain places in a text area column in a NetSuite saved search. In some instances this "comments" value contains data separated by line breaks with each line started by a digit followed by a…
Michael McCauley
  • 853
  • 1
  • 12
  • 37
1
vote
1 answer

Netsuite Saved Search in Scheduled Script No Results

I have a Saved Search (SS) which yields results when run in the browser. However, when executed in code, via a Scheduled Script, there are no results. Here's a simplified example: The SS with ID customsearch1181 returns 10 results in the…
Sevan Golnazarian
  • 827
  • 9
  • 18
1
vote
2 answers

NetSuite List of Items by Bin

I'm looking to create a list of all inventory items that we have. Most of our items are stored in 2 different geographical locations, and each location may have the same item stored in a primary bin (picking), and another bin (secondary storage…
Tim Pedersen
  • 25
  • 1
  • 4
1
vote
1 answer

Is it possible to add filters to a saved search when using N/Task module to run saved search

I have a script (2.0) successfully running saved searches and writing the results to CSV files in the File Cabinet via the N/task.searchTask. The issue is that the full system requires multiple saved searches that vary only by date range, and…
netsour
  • 11
  • 2
1
vote
1 answer

Error on NetSuite Saved Search Formula Using CAST and a Custom Field

I have my customer's GMT/UTC time zone saved in a custom Free-Form Text field on the customer record (for reference, field ID custentity2 in the first formula below). The time zone is set by a scheduled script using Google Maps API. For example if…
Ben M
  • 15
  • 2
1
vote
1 answer

Is there a way to search multiple keywords in a Saved Search on NetSuite?

I am creating a Saved Search for my team where users can filter by different parameters but the most important one is a ‘Keyword’ field where we have multiple text strings separated by commas. Eg: One could be (Horses, Apples, Cows, Carrots,…
Glorfindel
  • 49
  • 1
  • 7
1
vote
1 answer

NetSuite saved search formula to determine if all the components are in stock

Sorry a novice at Stack Overflow, so hope I'm doing this correctly. I'm trying to make a saved search to find out which assemblies can be built by determining if all the components are in stock. I found a similar question by Garrett Penfield at…
Stephen Davie
  • 23
  • 4
1
vote
1 answer

Netsuite saved search formula that sums distinct values within a date range

I am trying to create a saved search of time entries in Netsuite. Under criteria, I have specified a date range. This varies as this is an available filter For the purposes of this example, the date range is 1/4/2020 to 10/4/2020 The first column…
Vernita
  • 93
  • 3
  • 15
1
vote
1 answer

Combining two separate case statements in NetSuite Case Statements

I currently have two separate saved search columns for these two statements, and I'm hoping to combine them and list the data in just one column. I've tried OR AND, but the results then error out. First Statement Case when {item.custitem54} is null…
Imran
  • 93
  • 2
  • 15
1
vote
1 answer

Netsuite formula for randomizing numbers

Is there a formula I can use in a saved search to randomize numbers in Netsuites. Like the excel formula =RANDBETWEEN?
Manny Rodriguez
  • 33
  • 1
  • 7
1
vote
2 answers

How can I add a formula field in my NetSuiite saved search to show me where the invoice date is equal to the due date

How can I add a formula field in my NetSuite saved search to show me where the invoice date is equal to the due date. I only want to see these records as they would be wrong.
Danielle
  • 11
  • 1
1
vote
3 answers

How can I include the main line ship date in line item results for a sales order saved search?

I am trying to create a Saved Search that can be used to break down on time shipments by item type. However, I've noticed that {shipdate} isn't included in the results for the line items on sales orders. Here is an example search where the…
El Beastie
  • 13
  • 1
  • 4
1
vote
1 answer

Performing calculation of two separate case statements

I have created a saved search in NetSuite which displays two separate case statements. 1- case when {transaction.type} = 'Item Receipt' and {transaction.account} = '5505 Cost of Goods Sold : Product Cost' or {transaction.type} = 'Item Fulfillment'…
Imran
  • 93
  • 2
  • 15
1
vote
1 answer

How to add extra filter and columns into existing saved searches while loading in Netsuite 2.0

I have the following SuiteScript 2.0 code in a UserEvent where I would like to add an additional filter and columns to the loaded saved search. A filter is working properly but how to get column value from Array which is added as an extra column in…
Shreya
  • 11
  • 2
1
2
3
…
12 13