I am using a saved search to return all Sales Orde...
# general
j
I am using a saved search to return all Sales Orders that have no back-ordered items in them. I finally got the search to work as expected, but when I tried to run it through SuiteTalk I found out that I cannot have any "summary" columns in a saved search. I have spent a lot of time on this, and could really use a tip on how to get these orders in a way that will work using SuiteTalk. The only data I actually need returned is the top 1 Internal Id of the oldest Sales Order with no back-ordered items that are in a specific Location. Thanks for any tips!
k
Could you use your search as a workflow criteria to mark a checkbox and use that checkbox as your criteria in suite talk?
👍 1
j
Ok. I'll check into that tomorrow. Thanks!
j
other option is to write a script that saves the results of the search to a file, then suitetalk in to get the file
j
@KevinJ of Kansas That is what I ended up doing. It worked out great. Thank you!
k
No problem.
👍 1