Tyler Fox
10/15/2024, 10:59 PMCeligo AI
10/15/2024, 10:59 PMAI 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.
******Celigo AI
10/15/2024, 11:00 PMSlack 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
Celigo AI
10/15/2024, 11:00 PM