Stack Overflow
Stack Overflow

Questions tagged [saved-searches]

193 questions
0
votes
1 answer

How to set up prefixes on saved search for multiple choices in netsuite?

I have a multiple select field that allows multiple selections of colors. I created a formula that would append a prefix of "color-" to each selected list, but it only appends it to the the beginning of the field. I'm not sure how I can split the…
Connie
  • 3
  • 2
0
votes
1 answer

NetSuite Saved Search - Display Total/Calculate Percent when using Grouping

When using the summary function "Group" in Saved Searches (SS), is it possible to show the total count inline or even use it inline? For example, I have a SS that counts the number of cases closed in a certain date range and it groups by the…
user8948896
0
votes
1 answer

Applying formula on saved search columns

We are trying to generate a report to find out turn around time (TAT) of our deliveries of orders, categorize them in different buckets like 0-5 days, 5-8 days, etc. I am able to get the count of orders delivered within these buckets using the…
Manpreet Singh Bhalla
  • 1
  • 2
0
votes
1 answer

NetSuite - saved search- dynamic date range formula

Is it possible to write dynamic date range formula in NetSuite Saved Search? For example I have one of the expression in results tab is | case when {type} = 'Sales Order' and {custbody6} = 'F' then {amount} else 0 end | and I want to be able to…
Imran
  • 93
  • 2
  • 15
0
votes
2 answers

Showing Last Sold Date In a Netsuite ITEM Saved Search

I've created a search that shows current inventory on hand, their purchase price, and a formula that multiplies the two to have current value. In the results field I want to have a column that shows the last time an item was on a sales order. but i…
J_lano
  • 11
  • 1
  • 5
0
votes
1 answer

Netsuite Item Search - Goal: show items of non-zero quantities available

I'm creating a current inventory value search. It is an item search and the results show the item name, quantity on hand, cost, base price and formula(cost*quantity on hand). I need one more result to appear. Last date sold. I can not seem to find…
J_lano
  • 11
  • 1
  • 5
0
votes
1 answer

Netsuite Saved Search Criteria Formula

I am trying to filter my criteria based on 4 custom fields. How can I write the correct formula text in criteria? {custitem_field1} and or {custitem_field2}and or{custitem_field3}and or{custitem_field4}
Manny Rodriguez
  • 33
  • 1
  • 7
0
votes
2 answers

Formula to display items that have more than one value selected in a custom multi select field

I need help with creating a search to display only items that have more than one value selected in a custom multi select field. Is that a possibility via a formula? Thanks.
Imran
  • 93
  • 2
  • 15
0
votes
0 answers

Saved search to show quantities sold plus available quantities at multiple locations

I’m trying to build an item saved search which can show total quantities sold by couple order types, plus couple columns which will show how much available quantities are at couple locations. For order types I have these two formula columns which…
Imran
  • 93
  • 2
  • 15
0
votes
3 answers

Duplicates on Saved Transaction Search

I'm searching over transactions with the following criteria: Type is Transfer Order Internal ID is 547871 Main Line is false Tax Line is false Shipping Line is false COGS Line is false I just have one results column, which is Quantity. So I'm just…
Lydia Miller
  • 3
  • 4
0
votes
2 answers

Suite Script 2.0 - Handling Duplicate Fields in Saved Search

I have a Transaction's saved search, in which I have used Account fields three times with custom label. please see attached screenshot. but when pulling data for this saved search using suite script 2.0, netsuite returns first account field as…
umesh shukla
  • 139
  • 3
  • 13
0
votes
1 answer

NetSuite User Note saved search gives duplicate results

I'm searching over user notes with no criteria. When I only included a few basic results columns (Date, Author, Title, Memo, Internal Id), there were 86 results. Then I added another results column, a Formula (Numeric) field with the following…
Lydia Miller
  • 3
  • 4
0
votes
1 answer

Formula Saved Search

I have a saved search to display invoices with original amount due, then if any credit memos applied, along with if any discount taken by the customer for terms, and then the actual payments against the invoices. The issues I'm having is when I'm…
Imran
  • 93
  • 2
  • 15
0
votes
2 answers

saved search to pull date invoice was paid in full

I've a transaction saved search in which I've various formula columns displaying invoice date, any related credits, and then actual payments after any term discounts taken. Now I need to add another column to display the date invoice was marked…
Imran
  • 93
  • 2
  • 15
0
votes
2 answers

How to get column headers of a saved search in NetSuite via suite talk in C#.Net?

I am trying to get information about saved search like how many columns are there in a saved search and their information. I have saved search ID and when I do search with netsuite service through code then i am able to get data in a recordList…
syed ahmed
  • 11
  • 2
1 2 3
…
12
13