I need to create a saved search to alert me if I d...
# ask-stanley-ai
u
I need to create a saved search to alert me if I do not receive FX rates on any given day
c
AI generated answer (using internal Slack threads):
To create a saved search that alerts you if you do not receive FX rates on any given day, you can follow these steps: 1. Create a new saved search of type 'Currency Exchange Rate'. 2. In the criteria tab, add a new criteria: - Field:
Date
- Operator:
on
- Value:
today
3. In the results tab, add the fields you want to display in your alert. For example, you might want to include the
Base Currency
,
Transaction Currency
, and
Exchange Rate
. 4. In the email tab, set up the email alert. Add your email in the 'Recipient' field, and customize the 'Subject' and 'Message' fields as needed. 5. In the 'Audience' tab, ensure that the saved search is only visible to you or the relevant parties. 6. Save the search. This saved search will return the FX rates for the current day. If no rates are returned, it means you did not receive any FX rates for that day. However, there is a limitation in NetSuite that it does not send email alerts when a saved search returns no results. To overcome this, you might need to schedule a SuiteScript that checks the results of this saved search and sends an email alert if no results are found. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.818765223
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.816844583
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.815274298
Please provide your feedback on this answer.