Stack Overflow
Stack Overflow

Questions tagged [saved-searches]

193 questions
0
votes
1 answer

Netsuite - Saved search: Show kits available

For a netsuite saved search I and trying to find a formula that does the following. Have a saved item search display Kits only if all members of the kits have... (Quantity available / member quantity) >3 I've been netsuite with support and they…
Brandon Reale
  • 39
  • 2
  • 11
0
votes
2 answers

Extract a substring in a NetSuite saved search

I have the following: Auto Parts : Manufacturers : Mercedes Benz I need to extract the brand Mercedes Benz from this in a saved search inside NetSuite.
Raymond Anderson
  • 81
  • 2
  • 13
0
votes
1 answer

Netsuite - How do you get saved search results into an scriptable email template from a workflow

So I am trying to create an email that will be sent out to customers with past due balances and details from a saved search proccessed by a workflow. I want to use a scriptable email template to create the layout of the information that we are…
Sidious
  • 87
  • 1
  • 6
0
votes
0 answers

I want count of saved search in idx api

I want a count of saved search from https://www.idxhome.com/login/clientid?username=email as an api result to post it to my website.
Abdul Wahab
  • 27
  • 5
0
votes
1 answer

Prevent duplicates across multiple sublists

Our organization runs a daily transaction list (via saved search) to forecast our opportunity pipeline. For this saved search, we set the customer mainline to false to eliminate duplicate values in our search. I've built a saved search text formula…
Snuggie_Deluxe
  • 1
  • 1
0
votes
1 answer

Can RANK or ROW_NUMBER be used in summarized Netsuite search results?

I apologize if this question is a duplicate. Most answers I see were not related specifically to Netsuite search format. I need to rank a search result by sum of amount, grouped by item. I tried ROW_NUMBER() OVER (ORDER BY Amount) but it didn't…
Jake Freeman
  • 35
  • 1
  • 7
0
votes
1 answer

Trying to Script a Search Result into a Netsuite Entity Field

Having two issues with this. One is that I keep getting an error when trying to upload my script. The other is that one version that I did get to upload, didn't load any value into the field (ie. field blank after script ran) The error I keep…
gstea96
  • 145
  • 1
  • 10
0
votes
1 answer

Is there a way to script a scheduled update based on a saved search?

Having difficulty working out how to store a Saved Search result in a Custom Vendor Field. I have a Saved Search that can provide the value (a count of all purchase transactions under a Vendor for the last year, divided by 365) but obviously it…
gstea96
  • 145
  • 1
  • 10
0
votes
1 answer

Netsuite saved Search Formula Trimming a Word

I'm trying to get the number next to the word. For example "1bot 10box 100cs" i have another field in netsuite which is "BOX". What i need is the number next to the word box which is 10 in my example. I already tried Ltrim and…
J Ban
  • 3
  • 1
  • 2
0
votes
1 answer

System Notes old value is x% greater or lesser than new value

I'm trying to create a saved search that compares the old value vs the new value of a specific system notes field. Basically, I want to be able to search on if a Freight Cost new value is greater than or equal to 150% of the old value. I have some…
NinjaRuki
  • 27
  • 10
0
votes
1 answer

If it is possible, how do I create a custom field containing a document number on NetSuite in a saved search?

In NetSuite, I am setting up a new (currently untitled) saved search that is meant to display three columns simultaneously: Invoice document number, Sales Order document number and Item Fulfillment document number. I have configured my transaction…
Joseph Candava
  • 65
  • 13
0
votes
1 answer

Accessing Netsuite Saved Search Data From Python

I am trying to access the data obtained from Netsuite Saved Search using python. I want to write a script (in python) that runs a saved search and saves the results on my computer. Where can I read about how to structure my API requests to…
sampippin
  • 123
  • 1
  • 2
  • 12
0
votes
2 answers

Email Saved Search based on conditional field

I am looking to send an email from netsuite using the "Recipients from Results" I already have a saved search that emails based on field "salesrep", however I want to send a 2nd report to "TAMS" (Territory adoption managers) but only if the TAM is…
Ruthie_techie
  • 11
  • 1
0
votes
0 answers

NetSuite Saved Search: How can I create an average daily number of transaction created by a certain individual?

I'm not sure whether this is possible or not, but is it possible to create a saved search that displays the average number of daily transactions created by an individual? For example, I'm trying to create a Productivity KPI and would like to see how…
Brent
  • 11
  • 3
0
votes
3 answers

NetSuite: Can I expose a pdf of an invoice in a saved search for download?

I need to expose the pdf version of a NetSuite invoice in my ecommerce site. I'm using saved searches to push up invoice header info but I want to be able to click a link and it will download the NetSuite invoice pdf.
Raymond Anderson
  • 81
  • 2
  • 13
1 2 3
…
12 13