Hey folks! I am trying to get some data on all the items on a Sales Order, and I've started with something like this:

var newRecord = context.newRecord;

var itemName = newRecord.getSublistValue(

{

sublistId:'item',

fieldId: 'item',

line: i // this is in a loop

});

What I don't understand is why fieldId isn't the field Id I was expecting. For example, 'item' in fieldid in the above code returns the Internal Id of an item, but on the item's record, Internal Id is 'internalid' (not 'item'). Why are these different? How do I grab different/custom fields on an item that is on a Sale Order, if those item's field's id isn't recognized in this call? I am guessing this is just the wrong call to use, but it does return the right internalIds as 'items.' Thanks for any help!

Ok, thanks.. I will take a look at top link and add that extension!

look at the lineFields key for the item sublist

Ah, ok, thanks . . . I see that now. I had no idea that it was handled that way. Is there a way to add custom fields to the Item Sublist?

thanks a ton for that link!

you will want to use sourcing if you want the field to automatically populate with the value from the item https://system.na1.netsuite.com/app/help/helpcenter.nl?fid=section_N2839623.html

ok, thank you. I'll definitely have to dig into this info and mess around. I know that in trying to figure out my initial question used a few of the internal ids from the item sublist and still got unusual data to return (like just a 1 for price), so I'll start by trying to figure that part out and then move onto setting up and using custom fields.

getSublistValue returns internal ids for select fields getSublistText returns the text for the select fields

So this is a user event script. As such, it appears I will not be able to use the getSublistText ?

it depends. if the field was set using setSublistText, then yes

It wasn't. All I am trying to do is loop through items on a set of Sales Orders, and check some fields and then do some asks depending on the value/text in those fields

in general, get used to working with internal ids

Yes, that list you sent was helpful and I can see the difference in the ids now. But I still haven't figured out how to grab the data I need from the items on a Sales Order. I guess part of it is inexperience, but even looking at that Records Browser, I am not seeing a correlation for most fields. For example, we have a field for an item's SKU, with an id of 'itemid,' but I haven't figured out what that is in the Records Browser, and it isn't a custom field. Beyond that, I'm also not sure I am going to be able to get what I need since the getText won't work. Definitely a learning curve here, and typically this would be such a simple task/script to write.

its not always the same, but you can try using item_display

ok, thanks, I will look into it.

keep in mind, transactions only show some fields from items, not all

I haven't really got to it yet because I can't even get the simple fields back, but can fields be added: https://1259134.app.netsuite.com/app/help/helpcenter.nl?topic=LIST_CUSTCOLUMNFIELD&whence=

yes, thats how you add custom transaction line fields

@battk So if I have created a custom transaction line field, and need it sourced from a multi-select custom item field . . . . NS won't allow that, yes? I saw that in the docs. Do you know of a good work-around? Thanks again for your help on this. I got through the sublist ids and item ids, then I got some custom transaction line fields sourced, and was making progress, and then I run into sourcing from a multi-select!

you will probably have to break out N/search to get the value of your field

Ok, thank you (yet again!) . . . I'll have think about what kind of search to build -- but basically build/run a search on this event that gets the items on the order, and then use that and grab the actual item fields instead of the transaction line fields . . . I think, ha!