eminero
09/19/2025, 9:27 PMCeligo AI
09/19/2025, 9:27 PMAI generated answer (using internal Slack threads):To eliminate duplicates on item fulfillment lines from a saved search, you can follow these steps: 1. In your saved search criteria, set the following fields to `false`: - Main Line - Shipping Line - Tax Line 2. In the Results tab of your saved search, group by the fields that uniquely identify a line. For example, you might group by
Document Number
and Item
.
3. Add a summary type of Count
on the Line ID
field. This will give you the count of each unique line.
4. In the Criteria tab, add a new criterion where Count of Line ID
is greater than 1. This will filter out any lines that do not have duplicates.
Here is an example of how your criteria and results might look:
Criteria:
- Standard:
- Transaction Type = Sales Order
- Main Line = False
- Shipping Line = False
- Tax Line = False
- Summary:
- Count of Line ID > 1
Results:
- Group by Document Number
- Group by Item
- Count of Line ID
Remember to adjust these steps according to your specific needs. For example, if you are dealing with Transfer Orders, you might need to add additional criteria to exclude receive lines.
******
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/19/2025, 9:28 PMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.840026915
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.838806272
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.838806212
Celigo AI
09/19/2025, 9:28 PM