I have a SuiteTalk integration with Netsuite. We pull down transactions into another application using advanced search with saved searches, and sometimes we need to know what kind of items (e.g. serial, lot, assembly) are on the transaction lines as that affects the data transformation & the records we create in the linked application. We have returnSearchColumns set to false as we're pulling through the full transaction every time, the drawback being that we then can't easily add related entities.
I've tried adding a custom field to the line in Netsuite so that it comes through on the response but I can't find a related field that will give me what I need. If I could access the "isSerial" and "isLotNumber" flags on the inventoryItem that would probably be enough. I can't see anything obvious in the schema browser.
I'd prefer to avoid making any nested calls to e.g. pull down the item records, if possible.
I've tried adding a custom field to the line in Netsuite so that it comes through on the search response but I can't find a related field that will give me what I need. If I could access the "isSerial" and "isLotNumber" flags on the inventoryItem that would probably be enough. If I can do it through a custom field on the order line, maybe with a formula, that would be ideal as I can easily access the custom fields in the web service response.
I'd prefer to avoid making any nested calls to e.g. pull down the item records. if possible. TIA!