I have a saved search which lists inventory items and want to add a column to display the cost price for the preferred vendor.
I can get latest or average cost no problem, but can't figure out how to get preferred vendor cost. Can anyone shed any light on how to do this?
I can see using nlapiLoadRecord in a console that it's in .linefields.itemvendor within an array, but am not sure how to get at this in a search?