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 () {
if (swritebestseller == null) { return; }
// Cycle through the search results, get the record ID and
// submit the sum-value to the field using getValue
for ( var i = 0; i < swritebestseller.length; i++ ) {
nlapiSubmitField(swritebestseller[i].getRecordType(), swritebestseller[i].getId(), 'custitem30daysales', swritebestseller[i].getValue('Sum of 30daysales') );
}
}
It does not work! Suspect the "sum" function on the column is one problem and suspect the way I call the column value is not correct.
Can anyone point me to how the script should change / where my error is?
George