I am trying to generate a Saved Search that will:
- List Sales Orders and Transfer Orders
- Ship Date is on or before tomorrow (or if today is Friday, on or before Monday)
- Has items committed but not packed
- If the order is marked 'Ship Complete', only if all lines have full quantity of items committed
It is the last point that is giving me trouble. I tried it using this, but it doesn't work:
I've been re-looking at this seeing if I can do something with identifying the lines with items to pick, and then the max of the Line Sequence number ( to check if all lines have items to pick), but I don't think I can compare a SUM of one field against a MAX of another field in a Summary Criteria screen?
Seems like this should be a relatively common requirement? I can't see any examples in SuiteAnswers for this - has anyone else generated a Saved Search for something similar?
And, once I've got this working to list the number of Orders for Picking, I then need to develop it further to show the value of orders due to be shipped tomorrow (/Monday).....