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, I'm just starting to learn suiteql and having an issue with adding a custom "Other Sublist Record" field of type "Bill of Materials Revision Component". I'm using the table BomRevisionComponent. Here's my query:

SELECT
	BomRevisionComponent.bomRevision,
	BomRevisionComponent.bomQuantity,
	BomRevisionComponent.displayName,
	BomRevisionComponent.id,
	BomRevisionComponent.item,
	BomRevisionComponent.itemSource,
	BomRevisionComponent.quantity,
	BomRevisionComponent.units,
	BomRevisionComponent.custrecord_tst_buildableqty

FROM
	BomRevisionComponent

WHERE BomRevisionComponent.bomRevision=1814

Here's the error message I'm getting.
```Search error occurred: Field 'custrecord_tst_buildableqty' for record 'BomRevisionComponent' was not found. Reason: NOT_EXPOSED - Not available for channel SEARCH```