You can include more than one condition in the statement using AND / OR. Something like this might work: CASE WHEN {Translation.Description_E} is not null AND {Translation.Description_E} is not null THEN 'Some Value' END

Can you try combining the case statements like this: CASE WHEN {translation.language_tag} = 'en-CA' AND {translation.item_name} IS NOT NULL THEN (case when {translation.language_tag} = 'fr-CA' AND {translation.item_name} IS NOT NULL THEN ({translation.item_name}) ELSE 'some value' end) ELSE {translation.item_name} END

SuiteAnswer Answer Id: 61311 provides this example using a saved transaction search: 1. Navigate to Reports > Saved Searches > All Saved Searches > New > Click on Transactions 2. Under Criteria tab > Standard sub tab set the following: a. Account Type: is any of Accounts Receivable b. Status is none of Invoice: Paid in…

A similar problem was reported for a customer search. The problem was caused by fields which were added in both the Criteria tab and Available Filters. The solution was to remove one of the fields from either the Criteria tab or Available Filters tab.

I'm not too familiar with workflows, but the date format change may be caused by the date format configured under Home > Set Preferences > General.

I think BrettKnights was the author of that bundle, but I'm not sure if it's still available.

Something like this should work: <strong>Formula (Text) | TO_CHAR({trandate},'fmYYYY'). </strong>

SuiteAnswer 37231 provides this example: <br> tags are HTML codes, these are not considered for Formulas and will result in unexpected errors. Should Line breaks be needed for Formula Fields, the tags below will work. ‘< br >’ This is applicable for Custom Fields or Formula Fields in Saved Searches. Example: {field1}|| ‘<…

Here's a link to the Records Browser ;)

The LTRIM string function might do the trick. SuiteAnswer 21503 provides a few examples.

There's also this formula that works on parent : child hierarchy results: rtrim(regexp_substr({field},'[^:]*$'))

The US State filter should be doable using the alternate solution provided in SuiteAnswers Answer Id: 38602.

Maybe this will help. Try adding the Quick search portlet to your dashboard so you could search by record type using Name/ID. See this SuiteAnswer for more details - https://netsuite.custhelp.com/app/answers/detail/a_id/8406/kw/quick%20search%20portlet

The ns_concat() method might reach the character limit of the text field as Olivier Gagnon NC said, if you are concatenating a lot of messages.

It might also be dependent on the 'Show List When Only One Result' preference under Home > Set Preferences > Analytics. Support should be able to confirm the expected behavior.

This should grab the first person assigned to the case: [LIST=1] [*]Case Search [*]Criteria tab > Standard subtab [*]Select the Filter: System Notes Fields…, and on the new pop-up window choose: Field, for the Field selection: any of: Assigned, click Set. [*]Results tab, Sort by: Number, click the button Remove All…

Are you using a formula?

The ability to inline edit the memo field on opportunities is documented in Enhancement 88106.

Another way to achieve this would be setting Criteria > Summary subtab, with the following: Summary Type = Maximum Field = Call Fields... Phone Call Date is not after 7 days ago

In order for a user to see the Global Search field, the role requires the Perform Search permission set to View (at least). Try removing this permission from the role and have the users to clear cache or log out and back in.

Or try the "customer":REI prefix with the quotes. There are several prefixes that work with global search. SuiteAnswers Answer Id: 8402 provides examples. - https://netsuite.custhelp.com/app/answers/detail/a_id/8402/kw/global%20search%20prefix

Paul Reading post image: [ATTACH=CONFIG]n378931[/ATTACH]

This is currently an Enhancement Request. You can vote for Enhancement 267919 in SuiteIdeas or submit a Support case and reference the Enhancement.

You could use a saved transaction search and look at the (Maximum) Line ID to pull the last line item. Try something like this: 1. Saved Searches > Select Transaction. 2. Under Criteria tab > Standard subtab: Type = is Sales Order Main Line = is False Tax Line = is False Shipping Line = is False Memorized = is False 3.…

SuiteAnswers Answer Id: 22384 might help - Search for Saved Searches using SuiteScript.

I think the setting your'e looking for is under Set Preferences > Analytics > SHOW LIST WHEN ONLY ONE RESULT

I think there is something close to what you are looking for in SuiteAnswers Answer Id: 12701.

You could use an employee saved search: 1. Lists > Search > Saved Searches > New > Employee 2. Leave Criteria tab Blank (No Criteria) 3. In the Results tab you should have the following fields: * Role * Role Change Action * Role Change Date 4. Save and Run

If you base the search off date created or similar date field, you could try adding a formula to the criteria like: Formula (Numeric) > Enter formula as: case when to_char({trandate},'D') in (2,3,4,5,6) then 1 else 0 end > then compare the value to 1. This should return all records created on weekdays. This example applies…

The formula is from SuiteAnswers Answer Id: 30407 and it looks like the 'F' is enclosed in a slanted apostrophe (’ vs '). Also, you can try comparing the result to 'T' instead of just T.