Here is the list of the questions sent out during the webinar and the answers that were provided.
If the owner is no longer an employee will this stop the scheduled emails.
if the employee record is deactivated then the scheduled search will not send.
How do I (admin) publish a search template so it appears in all user's dashboard as a Shortcut?
You would need to use/login to a role where the whole dashboard is already customized to be shared to the user. You would then need to ensure that the Shortcuts portlet is already configured with the corresponding link to the search. After that, you would need to publish a dashboard to the role assigned to the user/s. For more information on publishing a dashboard, please see SuiteAnswers ID: 8122.
Can the hours and minutes be removed from the date column? I tried using a formula but was unable to do it.
Try using Formula Date as opposed to Formula Date/Time
I created a Vendor Bill (transaction) search but having trouble obtaining the Bill Payment info. The Applying Transaction fields is only pulling in the Reimbursements info; i.e. client invoice where the bill was charged to the client. SuiteAnswer ID 92641 lists the Bill Payment as an Applying Transaction, but I can't get it. Please assist.
I just tried using Applying Transaction Fields... and can see the related Bill Payment on a test account. This may require further testing or discussion. We encourage you to post it in our community, where our experts can provide further guidance.
Are there any tutorials or cheatsheets for formatting formulas within searches?
Hello, You may check SuiteAnswers Article IDs: 8439 and 10101
How do I get a list of the searches that are saved as email alerts?
you can try creating a search of type 'Saved Search', and use the Criteria 'Send Triggered Emails' = T.
If someone builds a save search, and they leave the organization is the save search still available for others to use?
Yes, the search would still be available for use.
Can the highlighted section of saved search export with the colors?
it does not export with the highlighting.
Is there a way (in a search criteria) to copy a Vendor/Entity Name in a transaction search that is only available at the main line/header level but not at the line level?
Just to confirm, do you want to show the Vendor/Entity Name in the search result? Or do you want to use the Vendor/Entity Name as criteria?
In the results. I see our reports showing the Entity name only at the header/main line level but not at the line level which makes sense because that value is prob only found at the header level. However, is there a formula or code that we could add that could pull the Vendor Name at the header level down to the line level in the search?
Thanks for the clarification. This may require further testing or discussion. We encourage you to post it in our community, where our experts can provide guidance. Here's the link: https://community.oracle.com/netsuite/english/categories/ask-a-guru
Can you export your saved search results into excel, csv file? Thanks
Yes. If you aren't seeing export options upon executing the search, you may be missing a permission.
Could you walk thru high level how to create a recurring email to accounts (members for our non profit) who have not paid membership fees after a certain date? Maybe a reminder sent automatically every week after the original request? Non payment would be an open invoice as of date sent
you can setup a saved search with Criteria of Type = Invoice and Status = Open. Refer to SuiteAnswers 8482 for info on Saved Search Email Alerts. https://suiteanswers.custhelp.com/app/answers/detail/a_id/8482/loc/en_US
Where can we learn to use formulas in saved searches?
Hi, you can learn about formulas through this MyLearn course. We also offer other webinars over Advanced Searches as well.
https://mylearn.oracle.com/netsuite/course/suiteanalytics-advanced-searches/125610
can you recommend a other class more focus on how to use correct criteria and results for saved search?
Try attending the Beginner Search webinars in MyLearn if you have the LCS Pass. If not, try to reach out to your Education Advisor/AMO to see if this can setup.