Anyone have experience with

setMatrixSublistValue

? I'm loading an item record and setting the MSRP using

setMatrixSublistValue

. I'm then calling

itemRecord.save()

. Is that all that I need to do or is there a matrix sublist commit or any like that?

depends on the features in your account

Here is what I am trying

var priceSublistCount = itemRecord.getLineCount({ sublistId: 'price1' });
for (var priceSublistLine = 0; priceSublistLine < priceSublistCount; priceSublistLine++) {
    var selectedLine = itemRecord.selectLine({ sublistId: 'price1', line: priceSublistLine }); // Don't know if this is needed
    var selectedPriceLevel = itemRecord.getCurrentSublistValue({ sublistId: 'price1', fieldId: 'pricelevel', line: priceSublistLine });
    
    itemRecord.setMatrixSublistValue({ 
        sublistId: 'price1', 
        fieldId: 'price', 
        column: 0, 
        line: priceSublistLine,
        value: priceData[selectedPriceLevel] 
    });

    //TODO: DOES THIS WORK?
    itemRecord.commitLine({ sublistId: 'price1' });

    }
}
itemRecord.save();

i personally cant tell if you are using dynamic mode or standard mode

There is no "setMatrixSublistValue" in SuiteScript 2.0 APIs. You will have to use "Record.setCurrentMatrixSublistValue(options)". Note that this is used in dynamic mode only. So use

isDynamic: true

when loading the item record. Also yes itemRecord.selectLine({ sublistId: 'price1', line: priceSublistLine }); is needed. Hope this helps. All the best!

yes, I stand corrected. Record.setMatrixSublistValue(options) is there in 2.0 APIs. Thanks @battk

Cleaned up Code:

var itemRecord = recordModule.load({
    type: recordModule.Type.LOT_NUMBERED_ASSEMBLY_ITEM,
    id: productId,
    isDynamic: true
});

var priceSublistCount = itemRecord.getLineCount({ sublistId: 'price1' });

for (var priceSublistLine = 0; priceSublistLine < priceSublistCount; priceSublistLine++) {
    var selectedLine = itemRecord.selectLine({ sublistId: 'price1', line: priceSublistLine });
    var priceLevel = itemRecord.getCurrentMatrixSublistValue({ sublistId: 'price1', fieldId: 'pricelevel', column: 0 });
    log.debug('Line: ' + priceSublistLine, 'PriceLevel: ' + JSON.stringify(priceLevel));

    itemRecord.setCurrentMatrixSublistValue({ sublistId: 'price1', fieldId: 'price', column: 0, value: 0 });
    itemRecord.commitLine({ sublistId: 'price1' });
}

what does your price list look like?

Real quick, this works

var priceLevel = itemRecord.getCurrentSublistValue({ sublistId: 'price1', fieldId: 'pricelevel', line: priceSublistLine }); // dynamic