How to filter sales orders if any lines are on bac...
# ask-stanley-ai
t
How to filter sales orders if any lines are on backorder from wave?
c
AI generated answer (using internal Slack threads):
To filter sales orders if any lines are on backorder from wave, you can create a transaction saved search with the following criteria and results: Criteria: 1. Type = Sales Order 2. Main Line = False 3. Quantity Back Ordered > 0 Results: 1. Document Number 2. Item 3. Quantity 4. Quantity Back Ordered This will give you a list of sales orders where any line item is on backorder. If you want to exclude sales orders where all line items are fully committed, you can add a formula (numeric) field to the criteria with the following formula:
{quantity}-{quantitycommitted}
. Set the condition to be greater than 0. This will exclude sales orders where all line items are fully committed. ****** 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.821577132
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.820570409
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.819731
Please provide your feedback on this answer.