Stack Overflow
Stack Overflow

Questions tagged [saved-searches]

193 questions
4
votes
2 answers

Saved Search of Saved Searches with Email Subject and Body in results tab

I'm trying to create saved search of saved searches in order to see which saved search is sending which e-mail. Now once i have like 100 auto e-mails from saved searches in netsuite i would like to organize them. For example i would like to have all…
Aleksandar Đokić
  • 2,118
  • 17
  • 35
3
votes
2 answers

NetSuite Saved Search Formula for This Week

I am trying to create a saved search that shows total orders today, yesterday, this week and this month. I am able to get all but the weekly one using date formulas. All are Formula(Numberic) fields with summary type Count. Today: CASE WHEN…
Marina Pantilus
  • 33
  • 1
  • 3
3
votes
0 answers

Netsuite:- how to extract Saved Searches & Reports data using SuiteAnalytics Connect Service (ODBC)?

As per documentation:- the SuiteAnalytics Connect Service enables you to run queries against two different data sources: NetSuite.com data source – Uses the only schema available up to 2018.2 to retrieve data. NetSuite2.com data source – Uses the…
ManiK
  • 377
  • 1
  • 21
3
votes
1 answer

Nested CASE WHEN Formula(text) in Saved Search Results in NetSuite

I have two fields _courier and _trackingnumber. I would like to create in results nested CASE WHEN formula (text) under the following conditions: the courier is = 'NAME' and if the _trackingnumber of this courier does not start with 0 then add 00…
Radoslav Penov
  • 47
  • 1
  • 5
3
votes
2 answers

How to get Sales Order 'shipaddresslist' value from Transaction Saved Search/Suitescript Search?

In Netsuite, the Sales Order record type contains a field called "shipaddresslist" which contains the Customer Address Internal ID associated with the selected Customer Address. Unfortunately, there is no search column for Sales Orders that will get…
Alex Hirota
  • 51
  • 1
  • 8
3
votes
1 answer

Duplicate results in NetSuite saved search

I created a simple saved search in NetSuite on the Transaction object, but for some reason I'm seeing duplicate results being returned. Screenshot below shows the duplicate results for the same Transaction record. Can anyone help me understand why…
Marty C.
  • 576
  • 2
  • 7
  • 22
2
votes
2 answers

TRIM or REPLACE in Netsuite Saved Search

I've looked at lots of examples for TRIM and REPLACE on the internet and for some reason I keep getting errors when I try. I need to strip suffixes from my Netsuite item record names in a saved item search. There are three possible suffixes: -T, -D,…
Jake Freeman
  • 35
  • 1
  • 7
2
votes
1 answer

NetSuite Saved Search Calculate Date Difference Between Two Related Records

I'm trying to calculate the difference in days between an Invoice Date and the Date it was emailed out on a Saved Search. I have a saved search created where I can see both the Invoice date (trandate) as well as the email date (messages.messagedate)…
ShannonQ
  • 21
  • 1
  • 2
2
votes
1 answer

NetSuite Suitelet add select field based on saved search or custom field

I know that I can use form.addField to add a select field with a list of records by adding it as a source in the addField method. I'm trying to show a list of customers that is filtered and only shows the name an not the id. What are my other…
Gus
  • 45
  • 5
2
votes
2 answers

Netsuite Custom Sublist Saved Search Filtered by Free-Form Text Field?

I am familiar with creating custom sublists on NetSuite forms by creating a Saved Search and on the Available Filters subtab, adding at least one available filter from a List/Record type field. If you don't use a List/Record type field as the first…
Accounting
  • 134
  • 1
  • 8
1
vote
0 answers

Please configure the inventory detail for item

I am trying to create an item fulfillment for an item , the on hand quantity on item fulfillment record is showing as X for that item at that location , but when it says configure inventory details for line X i am not able to see available under the…
Addy
  • 67
  • 3
1
vote
2 answers

How can we create splunk alerts using config files?

I am new to splunk and I am trying to configure alerts using configuration files, so I used the following savedsearches.conf file but I can't see the new alert in the UI: [Gurobitest] # send an email notification action.email = 1 action.email.to =…
Fatma Maamoury
  • 13
  • 3
1
vote
1 answer

How can I get a certain record’s system notes from SuiteScript?

I need to get the system notes of a transaction from a button on the transaction record form. I tried to create a saved search of type SYSTEM_NOTE, however, SuiteScript returns the following error when the record filter is used as follows: filters:…
edamazzio
  • 38
  • 6
1
vote
1 answer

Is there a way to use SuiteQL to create a saved search?

The subject is pretty much my entire question. I've got a SuiteQL query that I'd like to have sent to me each day. I've confirmed that the query runs as a POST via the REST API without error. Is there a way to take this query and create a saved…
CatPhish
  • 39
  • 6
1
vote
2 answers

Netsuite saved search subtract one column from another

As far as I know, there's no way to reference a column result in a subsequent column formula, right? If, on a line, I want to subtract one column from another, the formula for the result column has to recreate the formulas from the input columns? …
jerry
  • 31
  • 5
1
2 3
…
12 13