Another question, shipmethod, how can I access the shipmethod on the Sales Order. I tried transaction.shipmethod but it tell s me that shipmethod does not exist.

The ShipMethod is stored at the lineitem level. Depending on how the business is setup, you might be able to use the value from the mainline, like this...

SELECT
	ShipMethod,
	BUILTIN.DF( ShipMethod )
FROM
	TransactionLine
WHERE
	Transaction = 2179731
	AND MainLine = 'T'

Back to my question of shipmethod, I tried select shipmethod from transaction, did not work. I tried select shipmethod from transactionline, did not work. I know it's impossible. I want to convert many searches to SuiteQL but if I can't access shipmethod I'm "dead". Any idea ?

Yeah, maybe. Try this: SELECT * FROM salesOrderShipGroup WHERE ROWNUM = 1 Does that return anything for you?

Search error occurred: Record 'salesOrderShipGroup' was not found.

How about this one?

SELECT * FROM ShipGroup WHERE Doc = 2179731

Thank you very much for your help Search error occurred: Record 'ShipGroup' was not found.

Are you querying via SuiteTalk?

No, I'm using your tool SuiteQL, which I like a lot

That's cool.

Yes. Even in your tool with both dots, I don't see the field shipmethod 😞

And you don't see it on the Sales Order form?

Yes I do see it . it's shipmethod in lower ca

Ok, so this is a long shot:

SELECT
	ShipMethod
FROM
	(
		SELECT
			*
		FROM
			TransactionLine
		WHERE
			Transaction = 2587456
	)

Search error occurred: Unknown identifier 'ShipMethod'. Available identifiers are: {=SELECT [1x] FROM [1x] WHERE} Something is weird. I will take a chance and enter a support ticket at Netsuite...

Yeah. Something is definitely whacked.

I started to have doubt SELECT type FROM Transactionline inner join transaction on transaction.id = 40635696 WHERE transaction = 40635696 [ { "type": "SalesOrd" }, { "type": "SalesOrd" }, { "type": "SalesOrd" }, { "type": "SalesOrd" } ] but if I request shipmethod, all fail. The strangest part is that I tried with another customer, and there too, they don't have the shipmethod