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

with advanced order management, does anyone know what the acceptable values are for the pickupstatus field? for instance, does "1" mean picked, "2" picked up, etc. Keep getting stuck here: const result = record.submitFields({
type: record.Type.STORE_PICKUP_FULFILLMENT,
id: request.internalId,
values: {
pickupstatus: *????????*,
pickedupdate: new Date(),
custbody_tcs_pickedup_flag: request.pickedUpFlag,
custbody_tcs_if_pickedup_datetime: new Date(),
custbody_tcs_pickup_customer_identmeth:
request.customerIdentificationMethod,
custbody_tcs_pickup_customer_identy: request.customerIdentification,
custbody_tcs_pickup_employee: request.employeeIdentification,
},
});


 We have tried integers and we have tried strings.

 INVALID_KEY_OR_REFInvalid pickupstatus reference key 1

your best chance is to load an existing record and get the value of the `pickupstatus` field to see what the internal id looks like

you can also load the record in dynamic mode to get the select options of the field

<https://chrome.google.com/webstore/detail/netsuite-advanced-field-h/ehgcekpdldhgfjpionbkilpnaahjiejj|NetSuite Advanced Field Help> may also be an option

i will look into these options. thank you