Robert Nedelkow-Oracle · Oracle NetSuite Community Manager · Admin

Here's a thread dedicated to formulas - 100 Ways to Use Formula Fields: https://usergroup.netsuite.com/users/showthread.php?t=5889&highlight=101+formulas Thanks,

Here's an alternate solution I came across recently but haven't tested yet - Set a Criteria filter for the Formula (Text) field which will provide the default setting for the corresponding filter set in Available Filters tab of the saved search. In this example, we are going to use the formula {message} to pull out data…

Customize the report > Under More Options, make sure to check Show on Reports Page. The saved custom report should be listed under Saved Reports. Thanks,

I also don't have last fiscal month, but you can enter a custom date range using the From - To fields. Thanks,

This should work: substr({custentityX},0,1) Thanks,

4) Formula (numeric) sum decode({custrecord_pr_process_step},'Created',1,0) / nullif(decode({custrecord_pr_process_step},'Package Sent',1,0),0) Yen 4) Solution: SUM(decode({custrecord_pr_process_step},'Created',1,0)) / SUM(nullif(decode({custrecord_pr_process_step},'Package Sent',1,0),0)) Thanks,

We are tracking this via Enhancement Request 125071 : Saved Search > Support multiple levels of join or subqueries (without using ODBC driver and 3rd party application). Thanks,

If you know which employees created the calls, you could list all phone calls and filter by Organizer. Activities > Scheduling > Phone Calls. Thanks,

A Transaction Audit Trail is available at Transactions > Management > View Audit Trail. The audit trail provides information about the transaction, who entered the transaction, and when the transaction was created or modified. Thanks,

A good start would be the NetSuiteODBC Views Guide available in Help. Thanks,

You could try putting links to specific reports/searches under a custom tab(s). See Help Guide topic "Creating Center Tabs" for more info. Thanks,

Any ideas on how to make the - None - disappear from my search results? You could add criteria like State/Province is 'none of' - None - . This should remove the - None - results. Thanks,

In a Transaction search, it should be at the bottom of the criteria list.

Try adding Vendor Fields... > Name/ID > filter by 'is not' vendor_name. Thanks,

You can find this information in the Help Guide topic titled, Tables of ODBC Views. Tables are listed with the names of fields included in the view, field descriptions, and field links. Thanks,

Maybe placing each search on the dashboard or a custom tab would help. You are limited to three Custom Search portlets on the home page dashboard, but if you want to display results of additional searches on your dashboard, you have some other options to make this happen. For information, see Help topic, Displaying…

Try an Activity search and Group your results. Under the Results tab, Summary Type column, Group the Customer field and apply other summary types to the other fields as required. Thanks, Rob

Enhancement 125289 is currently accepting votes and may be considered for a future release. You can check the status of Enhancements in SuiteIdeas - see this Help topic for more information on Voting for Enhancements.

A description of each report is available in Help topic Sales Reports. Thanks, Rob

A description of each report is available under the Help topic Sales Reports. Thanks, Rob

John, I used this on an item search to return items without hierarchy: Formula (Text) LTRIM(regexp_substr({itemid},'[^:]*$')) HTH, Rob

If the saved search uses any summary type (Group, Count, Sum, Minimum, Maximum, Average) on the Results tab of the search, the search can't be used to create a Dynamic Group. To resolve this, remove any summary type set to the search and save the changes. Thanks,

I recently created some new dynamic groups, to which I want to publish certain searches. Problem is, they don't appear in the list of groups on the Audience tab. Some of our other existing groups do, but I can't figure out why some do and some don't. Can anyone help? Thank you, Evan Enhancement 156427 should address this…

Hi Brock, Try these: 1. Use Formula (Numeric) --- to_char({createddate}, 'D') --- for the numeric day 2. Use Formula (Text) --- to_char({createddate}, 'day') --- for the text day 3. Use Formula (Numeric) --- to_char({createddate}, 'HH24') --- for the hour Thanks, Rob

Currently you cannot schedule the time that saved searches are run. All scheduled saved searches run at 2 a.m. Pacific Time but you can vote for Enhancement 11575 for the ability to email saved searches at a scheduled time.

Hi Michael, You can vote for enhancement request 111420 - Reports > Pipeline Analysis : Show conversion rate from Lead to Prospect, Prospect to the Customer in a Date range. You can vote for this enhancement and review statuses through the NetSuite Support Center. Thanks, Rob

Development on Enhancement 136701 continues and will be considered for Release 2015.2. An Alternate Solution is available: Saved Search / Report to show Budget per Department versus Accounting Period NOTE: Users can only set one Column view (i.e. either Column = Accounting Period or Department) 1. Navigate to…

Re: Defect 519932 : Shipping Integration = T > Item Fulfillment > FedEx Shipping Method > Print Shipping Label > No Shipping Label Printed. We have confirmed that NetSuite did not make any changes in this area, and it appears that FedEx has changed something on their side which we believe is responsible for this problem.…

Support filed Defect 519932 : Shipping Integration = T > Item Fulfillment > FedEx Shipping Method > Print Shipping Label > No Shipping Label Printed. Please contact Support to have your case attached.

Support compared EPL files that printed successfully against ones that did not print, and found a possible cause. The file is generated by FedEx servers and we are currently coordinating with FedEx Support.