I have created a Transaction Saved Search to identify Sales Orders with a single line item that are ready to be added to a wave. I would like to add an additional criteria filter that returns only Sales Orders that have not yet been assigned to a wave.
My challenge is that I have not been able to find a way to expose the wave information within the saved search. It appears that the wave number is associated with the order lines, but I cannot find a field or join that allows me to filter on whether a Sales Order has already been added to a wave.
Has anyone successfully built a saved search that identifies Sales Orders eligible for wave creation while excluding orders that have already been assigned to a wave? If so, what field, join, or criteria did you use?
This is my search:
Criteria > Standard
Type is Sales Order
Tax Line is false
Shipping Line is false
Main Line is false
Closed is false
Date is on or before today
Status is Sales Order:Pending Fulfillment
Commitment Status (Custom Body) is Fully Committed
Location is ABC
Criteria > Summary
Count Line ID is 1
Results > Columns:
Document Number Group
PO/Check Number Group
Name Group
Line ID Count
Item Maximum
Quantity Maximum