Contact Us
A close up view of a typewriter shown from above.

Question: Accessing Item Options

Anyone ever find a way to query the Item Options that are available for a given item? If you look at the item record, there is a field called itemoptions, but I can't query it using SuiteQL, N/search, Saved Search...

There's also a record type called itemoptioncustomfield...but that's not queryable in SuiteQL or N/Search or Saved Search either. I can export the XML definition via SDF CLI...but that doesn't include the list of item records it's enabled on.

This is maddening. I can see everything in the UI, in multiple places, but the only way I can find to access the values programmatically is using record.load and currentrec.getText({fieldId: 'itemoptions'}). That doesn't make it available in searches, but it at least opens up possibilities. I'm just looking for an alternative to running something on each item record to copy these to a queryable field.

The only thing I found on this from NetSuite is this page, which says the record (Item Options Custom Field) is only available via SOAP API: NetSuite Applications Suite - SuiteCloud Supported Records

Answer: Query the Specific Item Subtype

You cannot query the Item Options list, but you CAN query the Item Options on a particular item record by using SuiteQL and querying the specific item subtype record. For example, SELECT itemOptions from noninventoryresaleitem WHERE id=12345 will return a result, whereas SELECT itemOptions from item WHERE id=12345 will NOT return a result.

image - 2026-11-19T135547.045.webp

This will return an array of item options, which are really the IDs of CustomField records. You can parse the string on the fly in SQL and run a join on each option to the CustomField table.

Related Articles

Tagged with Training, Troubleshooting