This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

on the item record, the location is a sublist? how can i  access via a script?

I need to set a sepcfic location reorderpoint to 0

```            itemRecord.setSublistValue({
                sublistId: 'location',
                fieldId: 'reorderpoint',
                line: /// whatever line number youre setting,
                value: /// whatever you want to set the reorder point to
            })```

Where itemRecord is…
```                        var itemRecord = record.load({
                            type: record.Type.INVENTORY_ITEM,
                            id: itemId
                        });```

<https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_1/script/record/inventoryitem.html#field_locations_|Inventory Part - locations>
reasonable start to find ids

this is the current script
```/**
 * @NApiVersion 2.x
 * @NScriptType UserEventScript
 */
define([], function () {
    function beforeLoad(context) {

        context.newRecord.setValue({ fieldId: 'autopreferredstocklevel', value: false });
        context.newRecord.setValue({ fieldId: 'autoreorderpoint', value: false});
        context.newRecord.setValue({ fieldId: 'taxschedule', value: "1" });
        test  = context.newRecord.getValue({ fieldId: "locations" });
      log.debug({title: test,
                 details:test})
    }
    return {
        beforeLoad: beforeLoad,
    };
});```

The first issue here is that these fields cannot be set with a beforeLoad script

<https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_1/script/record/assemblyitem.html#field_locations_|Assembly Item - locations>
same basic idea for assembly items

find the correct ids to use with <https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4273166777.html|Record.setSublistValue>

for your beforeLoad, only expect it to work on create

if you want a robust script, use <https://system.netsuite.com/app/help/helpcenter.nl?fid=section_4273157398.html|Record.findSublistLineWithValue> to find your matching line number

otherwise hope nobody inactivates a location and hardcode the line

ok if im using set sublistvalue , what is the sublist id -- is that  the internal id of the location ?

internal id of the sublist, i recommend the record browser to find that

the truth i need that whole location on all items for reorder point set to 0