Editing an existing saved search

Using Suitescript 1.0, I want to flag results in an existing saved search after they’ve been read so it doesn’t include them the next time it runs. So some lines will have, for instance, ‘Y’ in the flag column to denote they’ve already been read, and some will not. Is this possible?

Beginner Asked on November 15, 2019 in SuiteScript.
Add Comment
1 Answer(s)

You’ll want to add a checkbox field to the record type. Leave it unchecked by default, and check it once your processing is complete. Add a filter to the saved search to only look for those records with the box unchecked.

Beginner Answered on November 15, 2019.

Thank you! What I am trying to do is track back orders on sales orders. I have a saved search that finds the items, then a script that will run to add them to a TO so it takes them out of our central distribution warehouse availability (these orders are from distant warehouses so the items don’t get committed until a TO is written). I think what you are saying is that I could add a checkbox to the SO, and flag it once processed. However, what if someone edits the SO and adds another back ordered item? I was hoping I could just change the value of a column in a row in the saved search for each result that gets processed.

on November 15, 2019.

Actually – you’ve just made me realize I can put a field on the sales order line items, and check that when processed. Now I can go back to my original plan to use a workflow action script to find the backorders and add them to the to when the SO is saved. My problem there was also that I couldn’t figure how to know if it was already processed if someone edited the Sales Order. So – thanks again!!

on November 15, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor