I have a Saved Search for item fulfillment. I crea...
# general
k
I have a Saved Search for item fulfillment. I created it to see the total quantity of items in that fulfillment. I created a custom body field on the item fulfillment record so that it'll show the total item quantity right away rather than counting it manually. I want to connect the saved search to the Custom body field but don't know how. Side note: I have a script that does this already (not deployed), but my only issue is I have to Edit and Save each record individually for the script to run. I also don't know how to create a Mass Update script so I'm now trying this method lol
t
I assume that you have this custom body field with the store value unchecked?
k
Yes, correct.
t
You can can create another field (keep it hidden if needed) and create a workflow that sources the new custom body field from the old custom body field and the new custom body field check store value
Which will then be visible in saved searches
The new custom body field that is sourced after the workflow runs
k
But this is only needed if I wanted to Store the Value. How would I even get my saved search to be visible when I'm editing my custom body field? I can't see it in the Validating or Sourcing tab
t
You have to make a summary saved search to source a custom body field
k
Sorry, what does that mean exactly? My apologies, still getting use to NetSuite 😅
The first part of this article walks through how to set this up. The second part is what @Tim Chapman is describing with the workflow to store the value if needed
👍 1