-
Saved Search Formula > Compare all lines in a transaction
Hi Team, I'm trying to create a saved search that has a Case When formula that keeps the higher value between the expected ship date and the transaction date. This is my current saved search formula CASE WHEN {custcol_avt_exp_shipdate} IS NOT NULL AND {custcol_avt_exp_shipdate} > {trandate} THEN {custcol_avt_exp_shipdate}…
-
On-Demand Virtual Event: Creating NetSuite Saved Search Formulas
Video: Discover tips enhancing your NetSuite Saved Searches [PDF] More Tips for Enhancing Your NetSuite Saved Searches
-
dc
-
sea
-
In a Transaction Saved Search,
In a Transaction Saved Search, I want to return the Amount from the line where Class = 'Operator Commissioning' and Department contains 'Service', but only if another line in the same transaction has Class = 'Operator Sales' and Department contains 'Sales'. Can this type of comparison logic be achieved directly in a Saved…
-
NSC | Resolve Error: "There is a divide by zero error in this search..."
Scenario A user is attempting to display the item rate field in a sales invoice saved search in NetSuite but is encountering issues due to the absence of a direct 'Rate' field and encounters error when attempting to derive this using a formula instead. The user encounters the error, "There is a divide by zero error in this…
-
NSC | Saved Search Formula to Show Same Value in NS_CONCAT with DISTINCT Formula
Scenario: A user is working with a Project Saved Search, specifically focusing on extracting unique Sales Orders and their corresponding Total Amounts. The initial approach involved using a formula to concatenate the Sales Order number and Amount, ensuring uniqueness by combining them into a single string. Initial Formula:…
-
First sales of the fiscal year
Good morning I hope you are well. I'm having a bit of a trouble with a saved search. I have been asked to find a list of customers whose first sale of this fiscal year was March 2025. I've tried the below but this doesn't quite get what I need as it's showing customers who have been buying all year. I need to screen these…
-
SuiteTip: Use the Correct Symbols in Saved Search Formulas
Welcome back to SuiteTip, your trusted guide in the world of NetSuite! In this edition, we'll talk about using symbols correctly in Saved Search Formulas, ensuring your queries are error-free and efficient. Let's dive in! Symbol Usage in Saved Search Formulas When crafting formulas in NetSuite Saved Searches, it's crucial…
-
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} =…