[Iris TanMember Contributions: 3Level 1☆@iris_tan]

Resolved! Posting the script here and hopefully it helps someone in the future. Item Location Configuration is a separate record type to item.

function updReorderPoint(rec_type, rec_id)

{

var itemRec = nlapiLoadRecord(rec_type, rec_id)

itemRec.setFieldValue(‘reorderpoint’, null);

itemRec.setFieldValue(‘preferredstocklevel’, null);

nlapiSubmitRecord(itemRec);

}

[Iris TanMember Contributions: 3Level 1☆@iris_tan]

Ah thanks Adolfo! How embarrassing. I’m new to scripting. Have fixed that up. Next challenge is trying to target the right field in the sublist as the script runs fine but the values are not being updated. have tried Null or a numeric value but it is not updating. Have also ensure auto reorder points and auto preferred stock level is unchecked.

[Author]

Posts