-
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}…
-
Invoice Saved Search - # of $ Edits
Hi, Im trying to create a saved search that looks at the number of times the total/amt of an invoice has been edited/changed and WHO made the change. Date is anything after 11/1/25. The customer should be included along with the old and new total/amts if possible (but only the new amounts can be included if easier). Im…
-
dc
-
sea
-
Formula doesn't work in saved search
I create a new saved transaction search type : item fulfillment. Then I want a calculate the total from sales order - the rate in Sales Order. I use the formula(numeric) is CASE WHEN {createdfrom.quantity} != 0 THEN {createdfrom.amount} / {createdfrom.quantity} ELSE 0 END. » It does work when I preview, It show 0 - the…
-
Saved Search Formula Text only if the new value contains a specific word
I would like some assistance with a formula for a transaction based saved search where it will only display results of the specific field being set contains Hold. In this case, I only want the value if the field Install Project Status contains Hold. I would also like to limit this to only add line items to the results if…
-
Struggling with a Saved Project Task Search with an IF/THEN formula and RIGHT variable
I have an Excel file that I'm trying to replace with a NetSuite Saved Search. One of my Excel formulas is: =IF(RIGHT(F22,9)="Retainage",W22,0) Where: F22 is a Project Task Name field downloaded from NetSuite W22 is a Estimated Cost field downloaded from NetSuite I am attempting to write a NetSuite formula to use in a new…
-
SQL Essentials: LIKE Operator in CASE Explained
Overview The LIKE operator allows you to perform pattern matching within CASE WHEN statements. It is used to compare a character string or a field value to a specified string or text and returns a boolean result (true or false). This operator is especially useful when you need to find data that matches a specific string or…
-
SQL Essentials: CASE Function Explained
Overview The CASE function in NetSuite's Saved Search SQL is a powerful tool reminiscent of the IF-THEN-ELSE logic, allowing you to apply conditional logic to your data. This function allows you to evaluate different conditions and return specific results based on those conditions, making it a powerful asset for…
-
Saved Search: Result Formula for Case When under Case When
Hi all, I wanted to display a formula result where a Case When is under a Case When, may i know is this something doable? Tried below code but it is not working: CASE WHEN (CASE WHEN {custrecord_deprhistdate} = {custrecord_deprhistasset.custrecord_assetpurchasedate} THEN {custrecord_deprhistasset.custrecord_assetcost} ELSE…