how can I eliminate duplicates on item fulfillment...
# ask-stanley-ai
e
how can I eliminate duplicates on item fulfillments lines from a saved search?
c
AI 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. ******
Slack 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
Please provide your feedback on this answer.