SuiteQL Query Library

Shipments: Inbound

Returns all inbound shipments, including expected and actual ship dates, expected delivery dates, and more.

-- Contributor: Tim Dietrich (timdietrich@me.com)
-- Additional Info: https://timdietrich.me/blog/netsuite-suiteql-inbound-shipments/
SELECT
	InboundShipment.ID AS InboundShipmentID,
	BUILTIN.DF( POTransaction.Entity ) AS Vendor,
	POTransaction.TranID AS PONumber,
	InboundShipment.ShipmentStatus,	
	InboundShipment.ExpectedShippingDate,
	InboundShipment.ActualShippingDate,
	InboundShipment.ExpectedDeliveryDate,
	BUILTIN.DF( InboundShipmentItem.ReceivingLocation ) AS ReceivingLocation,
	InboundShipment.ShipmentMemo,
	BUILTIN.DF( POLine.Item ) AS ItemID,
	InboundShipmentItem.ShipmentItemDescription,	
	InboundShipmentItem.QuantityExpected,
	BUILTIN.DF( InboundShipmentItem.Unit ) AS Units,
	InboundShipmentItem.ExpectedRate,
	InboundShipment.ExternalDocumentNumber,
	InboundShipment.BillOfLading
FROM 
	InboundShipment
	INNER JOIN InboundShipmentItem ON
		( InboundShipmentItem.inboundshipment = inboundshipment.ID )
	INNER JOIN Transaction AS POTransaction ON
		( POTransaction.ID = InboundShipmentItem.purchaseordertransaction )
	INNER JOIN TransactionLine AS POLine ON
		( POLine.uniquekey = InboundShipmentItem.shipmentitemtransaction )
WHERE
	( InboundShipment.ShipmentStatus <> 'received' )
ORDER BY
	InboundShipment.ExpectedDeliveryDate,
	InboundShipment.ID

← Back to Query Library