This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I'm reading the Sales Orders, how can I access shipmethod ?

I think in some places, it's shipvia instead. try that?

It's not shipvia :disappointed:
It used to be shipmethod on the mainline = 'T'

<@UN8UBEXK2> Does this work for you?
```SELECT
	Transaction.ShipCarrier,
	BUILTIN.DF( TransactionLine.Item ) AS ShipMethod
FROM
	Transaction
	INNER JOIN TransactionLine ON
		( TransactionLine.Transaction = Transaction.ID )
		AND ( TransactionLine.ItemType = 'ShipItem' )	
WHERE
	( Transaction.Type = 'SalesOrd' )
	AND ( Transaction.ID = 9999999 )```

Unfortunately it's not working.

I used to do
SELECT
	ShipMethod,
	BUILTIN.DF( ShipMethod)
FROM
	TransactionLine
WHERE
	Transaction = 61044500
	AND MainLine = 'T'

but it's not working anymore

I guess Netsuite move the ShipMethod somewhere else

select  shippingmethod from transaction inner join transactionshipment on transactionshipment.doc = transaction.id where transaction.id = 61044500