Robert Nedelkow-Oracle · Oracle NetSuite Community Manager · Admin

SuiteAnswer 35270 provides an example search: 1. Navigate to Lists > Search > Saved Searches > New > Select Transaction. 2. Under the Criteria tab > Standard Subtab: [LIST] [*]Type is Credit Memo [*]Status is Credit Memo:Open [*]Main Line is True [/LIST] 3. Under Results tab > Columns subtab: [LIST] [*]Date [*]Type [*]Name…

I saw a similar example in SuiteAnswer 39986 - Transaction Search that show separate columns for Amount of Sales, Tax Total, Amount with Tax, Gift Certificate Amount and Amount Due…

JP-112, there are a few similar examples in SuiteAnswers: [LIST] [*]Answer 35437: Saved Search for All Credit Memo Showing the GL Account Impacted, the Status and Invoice Applied To for Fully Applied Credit Memo [*]Answer 70902: Saved Search Invoices that has Credit Memo [*]Answer 50852: Credit Memo Applied To An Invoice…

There are a few examples in SuiteAnswers but Answer Id: 13731 comes close: To create a search that computes the days spent in an Opportunity Status, perform the following steps: 1. Navigate to Lists > Search > Saved Searches > New. 2. Select Opportunity. 3. Provide a Search Title. 4. In the Criteria tab > Standard subtab,…

Are you using TO_CHAR for the date formula? Something like: TO_CHAR({date}, 'HH:MI:SS')

SuiteAnswer 61543 provides a search example for Customers with no Sales Activity: 1. Go to Reports > Saved Searches > All Saved Searches > New > Customer. 2. On the Criteria tab, add the following: a. Date of First Sale = is empty b. Date of Last Sale = is empty 3. Mark the Use Expressions box. 4. Along the Date of First…

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.…