I figured it out. Somehow the missing field got set to "inline" Display Type. That causes it not to be loaded in the sublist.

Thanks. I was not aware of the expression ability in the saved search. I'll give that a try.

Yes, it does look like they have made it possible with this latest release. However, it still does not feel easy. Here is my approach: // BEGIN: Supporting Functions // Hacky way to format a number with leading zeros // For example: 5 becomes '05' function formatDatePart(x) { return x > 9 ? x.toString() : '0' +…

I realize this is an old thread, but I just ran across this as well. I'm trying to search for serial numbers using a filter expression (so I can't use nlobjSearchFilter), but the join is using the ID not the text value of the serial number. That is not very useful at all. Anyone come up with a workaround for this? I see in…

I like this idea. There are some javascript charting libraries that I have been wanting to play with, but they're mostly solutions looking for problems. This seems like a worthy problem to solve.

If you are using nlapiSearchRecord, then you can have a method available to you on each search result called getRecordType(), which gives you the record type of the item in the search. Note: This won't work if you are summarizing (group, count, sum, max) any column. Some record types appear to be inconsistent as far as…