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

Hi All, How can we get the location and subsidiary field from the Invoice. I tried using the below query but It was throwing an error stating tha*t Search error occurred: Field 'location' for record 'transaction' was not found. Reason: REMOVED - Field is removed*`SELECT`
        `Transaction.location`
	`Transaction.ID,`
	`Transaction.TranID,`
	`Transaction.TranDate,`
	`BUILTIN.DF( Transaction.Entity ) AS Customer,`
	`BUILTIN.DF( Transaction.Status ) AS Status,`
	`Transaction.ForeignTotal AS Amount`
`FROM`
	`Transaction`		
`WHERE`
	`( Transaction.Type = 'CustInvc' )`
	`AND ( Transaction.TranDate BETWEEN` 
		`TO_DATE( '2020-01-01', 'YYYY-MM-DD' )` 
		`AND TO_DATE( '2021-12-31', 'YYYY-MM-DD' )` 
	`)`
`ORDER BY`
	`Transaction.Trandate ASC,`
	`Transaction.ID ASC`	

You need to join to transactionLine and grab location off there