-
Saved search to see all Purchase contracts and their related Purchase Orders.
Hello I'm looking to make a one stop shop search to include all Purchase contracts and related Purchase orders without the need of entering each specific Purchase contract to see if the Maximum Amount has been met.
-
Bin Field Not Functioning on Item Search
There is a checkbox on our bin records (see attachment) that indicates a bin has mixed items. Client has created an item search and wants to filter based off of this checkbox. It does not appear to be working, though. I've tried many different things and it just isn't working. See Criteria and Results.
-
Search operators on "Match Bank Data" Page
As far as I can tell, the "Match Bank Data" page does does not support Regex in its search field. Is there any operators available for more granular search? I could not find anything beyond that I can not interact with the page with scripting.
-
Search for BOM Components BIN Availability/On hand per location
Hi All, Is there a simple join using Saved Search to view an Assembly's BOM/BOM Revision and its components along with the # of Available and On Hand BIN Quantities on a said location? Does that make sense? End result would be: Is there a way to achieve this using Saved Search / Analytics? Or would it be only possible…
-
How to get Sales Order line Item entry to act like Global Search?
We would like to have “Global Search” ability for Sales Order Item fields. Currently, only Item names are index/displayed. In the Netsuite GUI global search bar, we’re able to find an item based on a secondary field (ie: Historical Part # in our case). If we search for the Historical field name, the associated Item with…
-
NetSuite Tip - Total Sales Orders per Day Using SuiteQL
In NetSuite, SuiteQL allows you to extract and manipulate data from your NetSuite account. It offers flexibility and efficiency in accessing data, enabling users to write complex queries to retrieve specific information. Here's a sample SuiteQL query to calculate total sales per day: SELECTTranDate,COUNT(*) as…
-
Account Search in Bill Dropdown No Longer Works by Description – Only by Account Number
Hi All, Previously we used to search and select the Account by typing the Account description in the Bill record transaction but now its not working anymore, Instead by the Account number its working now. Does anyone faced the issue ?Any suggestion or the solution will be helpful for me to go ahead with this. Hey NetSuite…
-
Is there a suggestion already to improve search criteria?
A number of times I have thought how useful it would be to be able to select the value of a field in the Value box for a search criterion. For example, I am trying to find orders where the sum of their deposits does not equal the order total. It's a real pain to do it, requiring some messing around with formulae and, I…
-
JavaScript Disabled Message & Product Descriptions Not Appearing in Search
Hi, We're experiencing an issue where some product descriptions don't always appear in search results. Occasionally, they load after refreshing the page, but other times, a message appears stating: "JavaScript is disabled on your browser. To view this site, you must enable JavaScript or upgrade to a JavaScript-capable…
-
Item LOV to dislay item code+description
Hello Currenlty the item LOV on Sales Order displays item code and description but we cannot search by item description. Can anyone tell me if there is preference etc to be set/changed so that we may be able to look for items by description as Sales representetives do not know the codes, they know only the item description…