It is a scheduled script that uses a saved search to write values to an item record.
Never written to a sublist before - and it is not happening for me! Help would be much appreciated:
This is the script, first writing values to the item record itself (which works) and then writing to the price sublist (which does not work):
for (var r = 0; r < itemResults.length; r++) {
// records the current price in a field
nlapiSubmitField('inventoryitem', itemResults[r].getValue(columns[0]), 'originalprice', itemResults[r].getValue(columns[2]));
// straight from NS userguide - apparently enables a sublist to be written
nlapiSetFieldValue('itemid', itemResults[r].getValue(columns[0]));
// straight from NS userguide - apparently selects sublist and line 4
nlapiSelectLineItem('price', '4');
// straight from NS userguide - apparently writes the field value to column 3 in the specified row where 'promoprice' is ID of the pricelevel (row 4)
nlapiSetCurrentLineItemMatrixValue('price', 'promoprice', 3, itemResults[r].getValue(columns[1]), true, true);
}
It does not record an error so I assume it just simply does 'nothing'! :h_a_w:
It is a time sensitive project so please please please let me know what this script should look like
George