Hagar Ahmed
09/01/2024, 5:46 PMCeligo AI
09/01/2024, 5:46 PMAI generated answer (using internal Slack threads):To create a saved search that shows sales orders with no work orders, you can follow these steps: 1. Navigate to
Reports > Saved Searches > All Saved Searches > New
.
2. Select Sales Order
from the list.
3. In the Criteria
tab, add a new criteria:
- Field: Main Line
- Operator: is
- Value: True
This will ensure that the search only returns the main line of the sales order, not the item lines.
4. Add another criteria:
- Field: Type
- Operator: any of
- Value: Sales Order
5. In the Results
tab, add the fields you want to display. For example, you might want to include Internal ID
, Document Number
, Date
, Status
, etc.
6. In the Summary
tab, add a new summary type:
- Summary Type: Count
- Field: Internal ID
- Function: Group
7. Add a new criteria in the Criteria
tab:
- Summary Type: Count
- Field: Internal ID
- Operator: equal to
- Value: 1
This will ensure that the search only returns sales orders that do not have any associated work orders.
Please note that this is a basic example and you may need to adjust the criteria and results to fit your specific needs.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
09/01/2024, 5:46 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.839674234
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.837586403
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.829464555
Celigo AI
09/01/2024, 5:46 PM