-
Formula (Text) Field in Custom Record Saved Search
I have a saved search on a custom rental ticket record that includes a Formula (Text) field that uses an NVL function to replace the asset type field value with the rental ticket item if the asset type field value is null. However, when I run the search, I get an "ERROR: Field Not Found". I suspect that maybe there is not…
-
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}…
-
dc
-
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…
-
AE:Formula to extract substring to first blank space
Hi There I have the following field (purchase order lookup ) which I am trying to extract a substring from with a saved search formula: I want this substring to extract everything until the first blank space i.e. exclude the word 'regards' and only extract '13448/93458' On the record itself this is what the contents of the…
-
Need a saved search that has no lines that meet the exclusion criteria
I have been reviewing posts in the Community for several hours looking for the answer I need but am still falling short. I need to create a sales order saved search that excludes sales orders where ANY line meets the exclusion criteria (which is that the field tagsrqd is not checked on any line). My criteria is currently:…
-
Workflow Show Message Action on {trandate} if greater then {today} + 90
I have been working on this condition for most of the day. I got it fire, but it was firing on all dates. These are the condition formula's I have tried: TO_DATE(TO_CHAR({today}, 'YYYY') || '-12-31', 'YYYY-MM-DD') {trandate} > TO_DATE(TO_CHAR({today}, 'YYYY') || '-12-31', 'YYYY-MM-DD') {datefield} <= {today} + 90…
-
How to use summary function on formula text?
Hi Guru. So I need to summary exactly like this but there is this error. Is there anything I should consider?
-
concatenate 2 free text format fields
I have this record where I want to concatenate the YEAR and MONTH field into a YEARMONTH field. All fields are free form text. Here is the view of the record: I use this formula in the workflow, after field edit on both month and year the result is that only the year is entered in the YEARMONTH field and I have no clue…
-
Creating a Formula in Price Update Saved Search
Hello, I am trying to create a formula in my NetSuite saved search but I am not too comfortable with creating formulas, can anyone assist? Scenario: Price Update Search I would like to have the lines highlighted for this scenario, If customer has multiple end date for the same Item highlight the row(s)/line(s) Customer…