Have tested this script a few times with both "customer" and "lead" for the record type on nlapiLoadRecord. I can see the record ID and the value in the execution log, but nothing shows on the Customer/Lead record. I've tried setting the custom field as both decimal and free-form text, but still can't get any results. Is there something I am missing?
function updatePSF() {
var SFA_PSF_2021_results = nlapiSearchRecord("customrecordsfa_yearly_sales_forecast",null,
[
["custrecord337","greaterthan","0.00"]
],
[
new nlobjSearchColumn("internalid","CUSTRECORD_SFA_Y_RECORD_KEY","GROUP"),
new nlobjSearchColumn("custrecord337",null,"SUM")
]
);
if (SFA_PSF_2021_results) { // validate if the saved search has returned some results
for (var z = 0; z < SFA_PSF_2021_results.length; z++) { // loop to go through all the results of the saved search|
nlapiLogExecution('DEBUG', 'Interation', z + ' of ' + SFA_PSF_2021_results.length);
var result1 = SFA_PSF_2021_results[z];
var column1 = result1.getAllColumns(); // retrieve all the defined columns within the saved search (amount, credit and debit)
var custID = result1.getValue(column1[0]); // get the value of the results within Column 0 (0 is the first column defined on the results tab -> Amount)
nlapiLogExecution('DEBUG', 'Customer ID', custID);
var amount = result1.getValue(column1[1]); // get the value of the results within Column 0 (0 is the first column defined on the results tab -> Amount)
nlapiLogExecution('DEBUG', 'Sales Amount', amount);
var rec = nlapiLoadRecord('customer', custID);
rec.setFieldValue('custentity_2021_forecast_sales_k', amount);
var id = nlapiSubmitRecord(rec);
}
}
}
I've also tried simply nlapiSubmitField, but with the same result where the record does not show the amount.
Thanks,
Hunter