Search Inbound Shipment by script

I try to crate search, but it doesn’t work with filter field ‘status’. Does anybody know how create filter for this field?


var searchInboundShipment = search.create({

type: search.Type.INBOUND_SHIPMENT,

columns: ['status', 'custrecord_shipment_id'],

filters: [['status', search.Operator.IS, 'In Transit'],

'and', ['custrecord_shipment_id', search.Operator.ISNOTEMPTY, null]]

});

Rookie Asked on July 2, 2020 in SuiteScript.
Add Comment
1 Answer(s)

It might be a good idea to check what the values are in that field. You might find that instead of “In Transit”, it is actually using the Internal ID of the status value, or maybe the values (when using N/search) are actually like “Inbound Shipment: In Transit” instead of just “In Transit”. Or maybe the field that contains “In Transit” is actually the “Shipment Status” field instead of the “Status” field (per records browser here: https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2017_2/script/record/inboundshipment.html). I know this isn’t a direct answer—I don’t have Inbound Shipment installed in my instance—but hopefully it will get you started until somebody with a more direct answer can come along 🙂 – Tony Zuko | 2020-07-06 | 11:14

Rookie Answered on July 6, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor