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 everyone,
I'm trying to query Tax codes (SalesTaxItem) via SuiteQl and facing trouble in filtering by subsidiary.

Getting this error
```Invalid search query. Detailed unprocessed description follows. Search error occurred: Field 'subsidiary' for record 'salesTaxItem' was not found. Reason: NOT_EXPOSED - Not available for channel SEARCH\n.```
On Netsuite Tax codes record page I can see subsidiary is present but I'm not able to query.

I'm pretty sure we can resolve this issue with "join"

I checked record catalog for SalesTaxItem, could'nt find JOIN with subsidiary

Could you pls provide more context? what is this query supposed to do?

&gt; query Tax codes?
Yes
Query:
```		SELECT
			SalesTaxItem.id,
			SalesTaxItem.itemid,
			SalesTaxItem.taxtype AS taxtypeid,
			BUILTIN.DF(SalesTaxItem.taxtype) AS taxtypename,
			SalesTaxItem.taxaccount AS taxaccountid,
			BUILTIN.DF(SalesTaxItem.taxaccount) AS taxaccountname,
			SalesTaxItem.taxagency AS taxagencyid,
			BUILTIN.DF(SalesTaxItem.taxagency) AS taxagencyname,
			SalesTaxItem.externalid,
			SalesTaxItem.includechildren,
			SalesTaxItem.city,
			(TO_NUMBER(SalesTaxItem.rate) * 100) as rate,
			SalesTaxItem.description,
			SalesTaxItem.displayname,
			'netsuite' AS sourcesystem,
			'Percentage' AS amounttype,
			(CASE SalesTaxItem.isinactive WHEN 'T' THEN 'inactive' ELSE 'active' END) as status
		FROM
			SalesTaxItem
		ORDER BY
			SalesTaxItem.id````

image.png

even if it appears on the record page, we can not query since that is not the field of the salestaxitem table.

Currently we deploy a script for integration. I will utilize that to expose endpoint and do a record search. This is only solution I can think of

I think subsidiary is not a mandatory field, right?

It's not mandatory, but we are facing issues with a client having separate tenants for subsidiary, they end up selecting wrong tax then sync fail

No, We have developed our own integration package

we can use another approach. just use record.load(), record.getValue()

Then record.load('type':'salextaxitem','id':""), record.getValue({fieldId:'subsidiary'})

It's my pleasure. Feel free to DM if you have any issues.