-
Portlet Type: Custom Search Portlet vs. List Portlet
NetSuite dashboards offer several portlet types to help users organize operational data and analytics. Two of the most commonly compared options are the Custom Search Portlet and the List Portlet. While both can display Saved Search results, they serve slightly different purposes and are optimized for different dashboard…
-
How to restrict PBCS locked saved search reports from custom roles?
Hello, We have a requirement where we need to allow some saved search reports and not show others. For example, we need to restrict PBCS saved search reports that are locked and installed through a bundle for custom roles. The custom role uses Sales Center and has Reports tab. Thanks,
-
Search filter returning incorrect result
Hi I have a saved search which is searching on the project table. This is the search criteria: in script view mode: var jobSearchObj = search.create({ type: "job", filters: [ ["custentity_pc_location","anyof","1"], "AND", ["entityid","contains","45"] ], the search result being returned is one project: The project only…
-
Invoice and Invoice Group in the sublist
Hi Gurus! Is it possible to show which invoice group record an invoice is tagged to in a sublist (i.e. customer record > Transaction list) or in a saved search? For example add the Invoice Group # as a column in a view like below? (screenshot from a demo account) Appreciate any input!
-
Saved Search with Item Next Count Date and Count Interval
We do not use SmartCount, however, we still use inventory counts by filling in the Next Count Date and Count Interval on the item or assembly record. I want a saved search to show the Next Count Date and Count Interval but it keeps showing up as blank. Does anyone know how to do this?
-
How to show only the latest change to a saved search?
Hi, I am trying to write a saved search that will show me the last modification date and the person modifying any saved search (using audit trail search). However, I am struggling to just show the last update as it keeps grouping the results by every user and does not show only the top row (last modification). The grouping…
-
SAVED SEARCH: Pull field from Payment in Invoice Record Saved Search Type
We want to pull the custom date field from the related Payment record in Invoice record type. Is that possible? Please help
-
Saved Search: Days a Sales Order Was Open
Hello NetSuite experts and gurus! Do you now if how we could show the difference between the dates of when the Sales Order was created and when the Sales Order was fulfilled? Thank you so much! Any insights are appreciated!
-
Saved Search Formula To Sum Numbers In Text Field
I have a text field let's just call it {textfield} that will contain data like this:- e.g. ["400.00","500.00","300.00"] [300] ["100.00","200.00"] etc.. I am trying to create a formula field to sum the numbers in this text field but no luck. I tried this to remove all the [, " and comma and hope by adding a + it will auto…
-
Invetory report in NetSuite
Do we have an existing report in NetSuite --- inventory report that shows stock on hand per item over time?.. A saved search is also great