Scenario: Users would like to be notified of Sales Orders that were invoiced but not yet fulfilled.
A Saved Search Alert can be created to show Invoiced Orders that have no related Item Fulfillment.
Here are the steps we may take to create the Saved Search:
1.Navigate to Lists > Search > Saved Searches > New
2. Select Transaction
3. Under Criteria tab, add the following:
- Type = Sales order
- Main Line = False
- Tax Line = False
- Shipping Line = False
- COGS Line= False
- Status = any of Sales Order:Pending Billing/Partially Fulfilled, Sales Order:Partially Fulfilled, Sales Order:Pending Fulfillment
- Formula (Text) = starts with Invoice | Formula : {fulfillingtransaction}
4. Add necessary fields under the Results tab
5. Under the Email tab, select one of the following options:
- Send Email Alerts When Records are Created/Updated
- Send Emails According to Schedule
- Summarize Scheduled Emails
- Send if No Results
6. Click Save and Run
I hope this helps! 😊
Let us know your insights about this topic in the comments!