-
How to Include Multiple Locations in Historical Item Sales Search Without Duplicating Quantity?
Hi Team, I am working on the Historical Item Sales search (Item 360) and need to update the same to include multiple locations in the search criteria. However, when I add multiple locations, the quantity is calculated incorrectly and appears to be doubled. Our account has both Multi-Location Inventory and Line-Level…
-
create a formula but shows ERROR: Invalid Expression
I need some help. I want to create the formula column in "item saved search". But still ERROR: Invalid Expression Information 1. Use the system field. such as (quantityonorder + quantityonhand) - minimumquantity 2. I use the formula numeric and formula text did not work. the system still show error 4. There are no criteria…
-
NetSuite Admin Tip | Identifying Records Updated by Workflows vs Users
In environments with heavy automation, it can be tricky to know whether a record was updated manually by a user or automatically by a workflow. This tip shows how to use System Notes in a Transaction Saved Search to identify the source of changes. Scenario / Use Case Administrators observe unexpected record updates and…
-
Save search Formula Issue
Hello Team, I am facing an issue with formatting a date in the YYYYMMDD format within a saved search using the NVL function. I want to ensure that the date appears in the specified format, but I'm encountering errors whenever I run my formula. Can anyone assist me with this? Thank you! My formula: CASEWHEN {type} =…
-
How add the 'Item Last Purchase Date' to the Saved Search
Hello! I have a saved search with the type 'Transaction', and I need to add the 'Item Last Purchase Date' field to the results. I'm not entirely sure if such a field exists, as it's not mentioned in the documentation. Saved Search: Criteria: Results: I also saw an article that seems to be related to my question, but I…
-
Remove "Sum of" displayed in Saved Search
Hi All, When you create a saved search which has "Summary Type" selected (for my example "Sum"), you get this displayed on the saved search results view. Can you take off the "Sum of"? I use a Custom Label but it adds "Sum of" to the column title which then takes too much column width and is not required! It's hopefully a…
-
Saved Search from SOAP is missing some transactions from UI
I have a SavedSearch which I am trying to access via an API call to the Soap web services API. However, certain transactions that show up in the web UI do not appear in the results from the SOAP API. The missing transactions are all of 'Currency Revaluation' or 'Transfer'. All transactions of those types are missing and…
-
How to create a Saved Search for Pending Fulfillment status with no backordered quantity?
I am trying to do a simple saved search to show orders for specific customers that are and Pending Fulfillment status with no backordered quantity on any lines. This will be used in a workflow to change an integration status field to send the orders to our 3PL via EDI. I've tried a couple of the searches provided by…
-
How to create Save Search From Expenses Sublist Line?
Hi, All. I have tried to create a saved search to show account and amount information from the expenses sublist on the 'items' subtab in purchase order, but I haven't found suitable criteria and only found 'Expense category fields' which has an account but it was empty. How can I get expense sublist lines in the saved…
-
Is it possible to group specific Criteria Results into one?
Hello! I have saved search that displays all of our Sales reps (criteria - Sales rep is any = name1, name2, etc.). Our sales team is requesting that a few of these reps be grouped into one. Is this possible? Here is how the search is set up currently