From a cash sale record, I need to look up the shipping cost on the sales order it was created from, using this piece of script:
var createdfromid = nlapiGetFieldValue('createdfrom'); var createdfromshipcost = nlapiLookupField('salesorder', createdfromid, 'shippingcost');but I get this error:SSS_INVALID_SRCH_COL
An nlobjSearchColumn contains an invalid column, or is not in proper syntax: shippingcost.
My script is fine, I checked other fields and they are accessible. And I checked the NS documentation, shippingcost shows up in the record browser:https://system.netsuite.com/help/helpcenter/en_US/RecordsBrowser/2010_2/records/salesOrder.htmlWhat's the problem, am I missing something?