Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
script: write column value of saved search to item record
Loving the automation possible with scheduled scripts, but having trouble:
- I have a custom saved search: ID 1177
- It sums all sales made over the previous 30 days to the parent record: custom column label 30daysales (albeit it is displayed as 'Sum of 30daysales' in the UI)
- I want to submit that sum-value to a custom field in the parent record: custitem30daysales
I cannot find any documentation on how to do this, but put together NS guidance and User Group posts to make this script:
// call the search
var swritebestseller = nlapiSearchRecord('inventoryitem', 'customsearch1177');
// Set up a function
function s30daybestseller () {
0