yeah I don't think I should need to use nlapiLookupField. I should be able to get the column with nlapiGetLineItemValue and I can't see why it is returning null

double check the function documentation on it, index start at 1, need sublist name

try from the record.getLineItemValue

XEDIT vs EDIT doesnt let all info present

you have to reload the record

I can get the sublist fine.

var internal_id = nlapiGetLineItemValue('apply', 'internalid', i); var invoice_gp = nlapiGetLineItemValue('apply', 'custbody_name_of_my_field', i);

the second line returns null

(I'm using the right field name, that's just an example)

what is XEDIT?

Xedit is like an inline edit event

but there's a handful of other things that trigger it too

nlapiSubmitField does it too i think

@jen double checked there is something there ? can you try from the record ? no permission issues ?

custom fields can have different audience

it does work with nlapiLookupField until I run out of governance

so field is accessible

and the value shows in the sublist

pretty odd

rec = nlapiLoadRecord(nlapiGetRecordType(), nlapiGetRecordId())

rec.getLineItemValue

the XEDIT vs EDIT still applies here, nlapiLookupField would work in both, but nlapiGetLineItemValue only in Edit

let me try your example, standby

comes back blank

I think I'll have to ask NetSuite support

what kind of script are you using

can you show your code?

workflow action

// Get all the "apply" items. var n_icount = nlapiGetLineItemCount('apply'); for (var i = 1; i <= n_icount; i++) { // Comes back null! var invoice_gp = nlapiGetLineItemValue('apply', 'custbody_gross_profit', i); }

I've got the right fieldname, I can see that's the same thing that's being used when I click to sort by that column in the sublist